Using the report page you have created in Power BI Desktop as a base, you can create visually rich report tooltips that will be shown while hovering on them. When you create a report page that will be used as tooltips, your exclusive tooltips can contain the visuals, tables, and all the other element collections you have created on the report page.
Shall we try this together now? Let’s go!
CREATING THE TOOLTIP PAGE
First, let’s create a new page. Click on the (+) sign that is on the right to create a new page. I created a new page with the name of Tooltip.
In order to set the new page we have created as the Tooltip page, select the size page as tooltip from the tab that you can find on the right. Here we can also select the normal page size, but keep in mind that the tooltips are located on the report canvas so it is important to keep them as short as possible.
You can name the tooltip page you have created in a way that indicates your goal. It is enough to select the Page Information card in the Style section and write the name you want into the Name field.
Now, let’s design the tooltip page the way we want. I will be designing a tooltip with the size of a normal page.
.
.
CONFIGURING THE TOOLTIP PAGE
After creating a tooltip report page, the page will be saved as a tooltip for Power BI Desktop. It is necessary to set the correct visual on it. First, we need to open the tooltip slider on the page information card in order to turn the page into a tooltip.
Any visual element that supports report tooltips now has a tooltip card in the style section. In order to set a tooltip, select the visual you want. And then go to the “Style” section of “Visualization” and expand the “Tooltip” card. After activating the tooltip slider, select the Tooltip page you have created as the report page.
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
Note: Some features listed below are not included in Excel LTSC 2021 for commercial customers. Each of those features is noted if it does not apply to Excel LTSC 2021 for commercial customers.
Co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other’s changes quickly — in a matter of seconds.
Note: Co-authoring is not available in Excel LTSC 2021.
Better collaboration with modern comments
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
Note: Modern comments is not available in Excel LTSC 2021.
MODERN COMMENT
Know who’s in your workbook
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021.
WHO’S?
Visual refresh
Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.
Note: Visual refresh is not available in Excel LTSC 2021.
NEW STYLE
Look left, look right… XLOOKUP is here!
Row by row, find anything you need in a table or range with XLOOKUP.
Return exact matches by default—there’s no need to specify.
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
Write one formula and return an array of values. Expedite calculations and insights with six
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
Note: The Accessibility ribbon is not available in Excel LTSC 2021.
ACCESSIBILITY
Increase the reach of your content
Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.
ACCESSIBILITY
Performance improvements
Experience improved performance, stability, and speed across Excel.
Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
SUMIF, COUNTIF, AVERAGEIF
Unhide many sheets at the same time
No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
We’re constantly adding more rich media content to the Office Premium Creative Content collection that helps you express yourself, such as a curated library of stock images, icons, and more.
At the top of your Microsoft Office apps on Windows, you’ll find the new Microsoft Search box. This powerful tool helps you quickly find what you’re looking for, such as text, commands, help, and more.
Do you use a stock report and are you in constant need of renewing the report and keeping up with it in order to not go stock out? Do you want to receive a notification immediately when one of the IOT devices you follow with Power BI reports get too hot? Then it is safe to say that data alert is your jam!
Data alerts is a feature exclusive to the cards on the Power BI dashboards. The values are checked for being over or below a certain level and if the limit is exceeded, then the person who created the data alert gets notified by Power BI regarding the situation.
Now, let’s take a look at how we can create one.
1- Pin the card to the dashboard
First thing first, we need to pin the card on the relevant report to the dashboard. As you know, we can make this card be shown on the dashboard we want by clicking the pin icon on the upper right of the cards.
2 – Click “Manage Alerts”
Once we pin the card on our report to the dashboard, we will go to the relevant dashboard and click the ellipsis icon on the upper right of our card. Here, we choose the “Manage alerts” option.
3- Determine the Conditions for Data Alert
Now, we enter the information regarding the data alerts in the window that pops up on the right of the page. The title of the alert, our condition, if it will be over or below a certain value and that will this value be… You need to enter this value manually. Then, we will choose the frequency of this alert. And since we want to get an e-mail about the subject, we leave the mail option checked. Then, we “Save and Close”. This way, we get to complete the action.
From now on, once all the data is updated an evaluation with the comparison to the determined value will be executed. And we will receive a notification when it is necessary. Here is an example of one of the e-mails:
Depending on the urgency of the situation, it is also possible to design different flows for when the e-mail arrives. We will talk about this in our other articles. You can take a look at the other articles here.
Hi there dear readers! Today, we will talk about Microsoft’s Power Automate (formerly called Flow). Power Automate is a member of Microsoft’s Power Platform family, and allows you to automate your business processes and design them with as little code as possible. It integrates with nearly 300 connectors and handles your work automatically without the need to visit multiple sites or run multiple programs. To begin with, I recommend reading this article and then looking at the templates on Power Automate’s site. These are ready-made templates that you can get started with right away. Here I leave a few of them for you to review:
One of the best parts of Power Automate is that you can perform a variety of business processes in the simplest level possible, even without having the tiniest idea of how to code. Of course, every now and then you will need formulas here as well when appropriate, And for that kind of situations, Power Automate has its own formulas. Many of these formulas, referred to as “Expressions”, are similar to those of Excel.
FUNDAMENTAL COMPONENTS
Flows have 2 main components:
Trigger
Action
The main question when it comes to the trigger title would be “What will be required to happen for this flow to run?”
The titles like:
When an e-mail is received,
At 10 o’clock every day,
When a new task is created,
When a new line is added to the Sharepoint list,
When a button (Power Automate button, Power Apps button, Power BI button) is pushed,
etc. are all triggers. A flow doesn’t work without a trigger.
The main question when it comes to the action title would be “Which actions will be executed once this flow starts running?”
Here, we will select the actions we want to execute and connect them one after the other.
Send an e-mail.
Create a task.
Send a message on Teams.
Add a new record to the Sharepoint list.
Create a new file on Sharepoint.
etc. are all actions.
As a matter of fact, most of our business processes depend on various conditions and approvals. For example, you will save the files to a folder, but your administrator must approve these files first. Here the process gets a little more complicated and you have to apply various conditions to the processes as well. Since these situations are quite normal, Power Automate also has a solution for this situation: Flows can be designed to create special reactions to the results of certain conditions by selecting conditions as an action and working according to these conditions.
Everything goes step-by-step in the Power Automate flow. Thus, one of the main points to know here is that when you add an action, you can use the outputs of the actions or triggers from the previous steps. In the Dynamic Content area, Power Automate already shows you what and which titles you can use.
Below you can see an image of a conditional process.
The steps here are as follows:
We have created a survey, and we want this flow to be triggered when a new answer comes in.
We get the details of the answer that caused the trigger.
In the survey, we’ve got the question of: “Did you like our event?”. We will execute 2 different actions depending on the answer to this question. For this very reason, we add a condition.
We choose the title to which we will apply the condition: “Did you like our event?”. We want it to check if the answer here is equal to 5. 5 is the highest value.
If it is equal to 5, then we send an e-mail to the sender saying “Thanks”.
You can click here to check out our other articles about Power Automate. And if you ever have a question, feel free to let us know. See you in other articles.
You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻 Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of May.
May 2021
May 14, 2021 , Version 2106 (Build 14107.20000)
Word
Notable fixes
We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.
We fixed an issue where pressing key combinations such as ctrl + shift + @ would not produce the expected accented character( in this case, ‘å’).
We fixed an issue related to z-order of SVG objects when converted to shapes.
We fixed an issue related to image compression.
We fixed an issue where copying a mail attachment to an application other than Word would fail if the filename included DBCS characters.
We fixed an issue where Word sometimes displayed a border around text that should have not been there.
Excel
Notable fixes
We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.
We fixed an issue related to z-order of SVG objects when converted to shapes.
We fixed an issue related to image compression.
PowerPoint
Notable fixes
We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.
We fixed an issue related to z-order of SVG objects when converted to shapes.
We fixed an issue related to image compression.
Outlook
Notable fixes
We fixed an issue that caused users to see actionable messages either constantly refreshing or reverting back to headers after download when running in Download Headers Only mode.
We fixed an issue that caused the people picker in Outlook to expand upwards rather than downwards for users with a perpetual license.
We fixed an issue that caused users of custom domains to see a warning message about permissions when pasting a link into an email message.
May 7, 2021 , Version 2106 (Build 14029.10000)
Excel
Notable fixes
We fixed an issue that prevented the Name Manager from opening books with a large number of hidden names.
Outlook
Notable fixes
We fixed an issue that caused users to see copies of all of their sent items appearing in their Outbox folder.
We fixed an issue that caused Outlook to close unexpectedly when using Read Aloud with other versions of Windows.
Word
Notable fixes
We fixed an issue that caused Word to close unexpectedly when using Read Aloud with other versions of Windows.
May 3, 2021 , Version 2105 (Build 14026.20052)
Excel
Linked data types: Real data for real life
We’re excited to announce brand new data types in Excel, resulting from our partnership with Wolfram. Have you ever tried to get data from the web into Excel and keep it up to date? Then, you’ll know it’s not for the faint of heart. These new linked data types and smart templates not only save you time but also make keeping data up-to-date a breeze.
We’ve heard your feedback! We’ve created a contextual Accessibility ribbon that offers one consolidated place to look for tools that make authoring accessible content easier. To try it out, open the Accessibility Checker on the Review tab and the Accessibility ribbon will open automatically.
We compiled all the new features and fixes in May in Office insider.Hope to see you in our other articles, bye bye. 🙋🏻♂️You can share this article with your friends and family to help them get information about Office insider updates released in the month of May. 👍🏻
You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻 Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of April.
April 2021
April 30, 2021 , Version 2105 (Build 14026.20000)
Visio
AWS stencils and shapes
You can now use stencils with the latest AWS shapes to help you create diagrams and represent your AWS architecture more accurately.
Outlook
Ensure accessibility of your content
When composing an email to large audiences or external users, for example, accessibility violations will now be brought up to your attention, through a mailtip.
To turn off this feature, select File > Options > Ease Of Access > Accessibility checker options and select the Run the accessibility checker only when I open it option.
Notable fixes
We fixed an issue where using High Contrast mode for extended periods of time would cause Outlook to crash.
Excel
Notable Fixes
We fixed an issue which could cause Excel to crash when using Paste Special with formats in certain situations.
We fixed an issue that cause Excel to crash when moving through comments in the Comments pane.
We fixed an issue that caused date formatting to be displayed incorrectly in some languages when using add-ins.
We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
Word
Notable fixes
We fixed an issue that caused the ability to collapse margins in a document containing multiple columns to be available.
We fixed an issue where text formatting remains after removing hyperlinks.
We fixed an issue where users would not be prompted to save documents when using a command (rather than the CTRL+S keyboard shortcut).
We fixed an issue where Word was unable to perform a Mail Merge with an Access database.
We fixed an issue where the sensitivity label disappears from a file in Word after uploading the file to SharePoint Online.
We fixed an issue where comments are not displayed after filtering by people.
We fixed an issue where Word would become unresponsive when editing fields.
We fixed an issue where some characters are not displayed correctly in table cells when there are comments in the document.
We fixed an issue where the file format changes occurred when saving documents with the AIP add-in enabled.
We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
PowerPoint
Notable fixes
We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
Project
Notable fixes
We fixed an issue where changes done through Planning Wizards weren’t always captured by change events.
We fixed an issue where users were unable to remove projects from the resource pool.
April 23, 2021 , Version 2105 (Build 14014.20002)
Excel
Import data from dynamic arrays
You can now import, shape and refresh data from dynamic arrays in the current workbook.
Notable fixes
We fixed an issue to support backward compatibility with older versions of Excel. The issue may cause a file that is saved in a more recent version of Excel fail to load properly in older versions of Excel due to functions such as IFERROR and XLOOKUP added to Excel since Office 2007.
We fixed an issue where some files would occasionally fail to open in Protected View.
We fixed an issue that caused the status bar to not indicate a Ready state for some users.
Outlook
Notable fixes
We fixed an issue that caused name resolution to fail when sending on behalf of another user and resolving against an address book that is not the Global Address List.
Word
Notable fixes
We fixed a issue where placeholder text was clipped in comments when using right-to-left languages.
Office
Notable fixes
We fixed an issue where hyperlinks including digits would be broken when composing a message in Outlook in a right-to-left language.
We fixed an issue where some Scalable Vector Graphics (SVG) did not render correctly.
April 16, 2021 , Version 2105 (Build 14007.20002)
Excel
Notable fixes
We fixed an issue that caused Excel to crash when using 32 bit Office on 64 bit Windows.
We fixed an issue that caused Narrator to incorrectly read the properties of two buttons on the Header/Footer tab in the Page Setup dialog box.
PowerPoint
Notable fixes
We fixed an issue related to linked pictures.
April 9, 2021 , Version 2105 (Build 14002.20000)
Excel
Accessibility ribbon
Find all of the tools you need to create accessible content in one place – the Accessibility ribbon!
Word
Proofing for selected text within the Document
With these changes you can now review spelling, grammar and other intelligent writing suggestions for just the selected text. Additionally you can also review suggestions for the whole document.
April 2, 2021 , Version 2104 (Build 13926.20000)
Outlook
Turn on shared calendar improvements
For shared calendars in Office 365, Outlook can update these calendars using the REST API. Turn on the preview for faster and more reliable updates to shared calendars.
Word
Notable fixes
We fixed an issue that prevented specific policies from being honored.
We fixed an issue in auto save.
We made a fix in Application.OnTime where it might not trigger correctly.
Access
Notable fixes
We fixed an issue when an external application requests an accessibility interface, it will prevent us from shutting down until they release their reference.
We compiled all the new features and fixes in April in Office insider.Hope to see you in our other articles, bye bye. 🙋🏻♂️You can share this article with your friends and family to help them get information about Office insider updates released in the month of April. 👍🏻
E-mail signatures are one of the most targeted digital marketing tools. Especially in our work routine, all e-mails sent by all employees in line with their communication needs can be used as marketing endpoints. But, how? In this article, you can see the integration steps of the interaction reports via e-mail signatures to the Google Analytics platform and discover the market potential.
Google Analytics uses two basic methods to collect data on website traffic from 3rd party domains.
Connectors on Google Analytics
UTM and similar routing parameters
The Google Analytics connectors are sections that you can integrate with your Google Analytics properties by connecting with your authorized user information through channels such as Google Ads and Youtube. These integrations include your Google Ads advertisements on Google Analytics screens, the traffic and feedback generated by these advertisements. It allows you to create your digital marketing strategy by viewing how much of your total traffic it has generated and its total impact in a segmented manner with the traffic from these channels.
On the other hand, in order to link your website to Google Analytics screens, you need to add the Tracking Code page tags under the Admin > Tracking Info tab to thesection of all the pages of your website.
UTM (Urchin Tracking Module) parameters are used to define where and for what purpose the traffic directed to the website from influencer marketing, social media advertisements, newsletters and all similar content from third party domains. It basically means creating a custom redirect URL by adding additional text to the URL you use to redirect your website. You need to add 4 parameters to have the access from this link reflected well on Google Analytics reports.
The redirection created by these parameters transmits the description of the information contained in the other items while
directing the users to the site defined in the URL section.
While editing your e-mail signatures with the Sign&Go application, you can create corporate signatures similar to the designs below. Allowing you to define links to banner advertisements while creating signatures, Sign & Go creates a template that includes special UTM parameters as defined above for all emails sent throughout the company.
After this step, all individuals who click the banners in your mail signature will be anonymously reflected in your Google Analytics reports and your e-mail signatures’ contribution to the website traffic will be reflected in your reports.
When you go to your Google Analytics panel, Medium and Source sections of all report fields, especially of the Traffic Sources section under the Realtime tab under the Reports section, appear as defined just like in the 4th line of the table in the visual above.
With Sign&Go, you can turn your company-wide signatures into the most effective direct marketing tool and make sure that you use digital media effectively while creating quality signatures that reflect your brand’s power.
What is the contribution of e-mail signatures in the digital business environment? Do they really acts as a business card of the companies? In these times where we feel that we are moving into the digital age, according to Statista’s research, approximately 306.4 billion e-mails were sent and received every day in 2020, while the number is expected to increase to 376.4 billion per day by 2025. In recent years, the importance of professional e-mail signatures around the world has turned into a powerful marketing tool, benefiting companies’ success and brand recognition on a large scale. As Seth Godin said, “Marketing is a contest for people’s attention.” You can also get more attention by adding innovative differences to your e-mail signatures such as colorful designs or the GIF playback feature.
But, what is SIGNandGO and how does it contribute to your company?
E-mail signatures are the closure of messages. Considering that each employee represents your company, it provides information about your company, connects with your brand and creates trust. By adding information texts such as advertisements, campaigns or announcements to your e-mail signatures, you can transmit your campaigns according to dates and generate traffic to your company’s website. The advantage within your company is that it provides an easy-to-use interface to different departments and takes this burden off the IT department. The best part is that it doesn’t even cost you a lot.
We held our SIGNandGO webinar with Çözümpark, where we talked about the steps that will facilitate your e-mail signature management without the need for server installation with a cloud-based central e-mail management solution.
Scheduled signatures
Cloud signature structure
Web based management
Mobile friendly management
Defining signatures and rules from the web-based easy admin screen
System Architecture: Exchange online and local exchange
Easy setup: SaaS and o365
Security measures: IP restriction, TCP communication, domain name filter
PEAKUP donated saplings on behalf of their employees on March 8, International Women’s Day.
PEAKUP organized a meaningful organization on March 8, International Working Women’s Day this year, just like every year and donated saplings on behalf of their teammates. The team planted the saplings in Kağıthane Hasbahçe with the participation of the Mayor of Kağıthane, Mevlüt Öztekin, for the International Women’s Day.
PEAKUP wants to leave a mark that can be passed on from generation to generation, and for this, has brought its saplings to the soil with the support of Kağıthane Municipality with the planting of Ginkgo Biloba trees, which represent durability, originality and eternity on behalf of the entire team.
PEAKUP CEO Ahmet Toprakçı said, “As PEAKUP, we support women in every aspect and continue our activities as much as possible to set an inspiration and example for our company. In our company, we always ensure the balance of the number of female and male employees and equal rights. This year, we hope that the trees we donated on March 8, International Working Women’s Day, will continue to live by reflecting our women with their originality and all their elegance.”
We began our new content series “Introduction to Infrastructure” trainings. In this training that is planned to last for 8 weeks, the PEAKUP CEO Ahmet Toprakçı, who previously provided consultancy and training in various institutions, will be sharing his knowledge with you, our esteemed audience. The goal of our training is to start from the most basic level of infrastructure services and technologies and to touch on more professional subjects over time. The general topics of our event, which will take place every Wednesday at 17: 30-19: 00, are as follows:
. System and Network
. Introduction to Infrastructure Technologies
. History of Computer Networks
. The Concept of Internet
. IP
. Bit / Byte
. IP Network
. IP Subnetting / Supernetting
. Network Hardware (Router, Switch, Firewall, AP)
. VPN and more.
You can watch the training for free via the link below or in the bio.. 👇
Word
Excel
PowerPoint
Outlook
Visio
To turn off this feature, select File > Options > Ease Of Access > Accessibility checker options and select the Run the accessibility checker only when I open it option.
