#excel2021

[thelearningzone]

Your Own Tab in Excel because... Why not?

Microsoft Excel Tricks Customize Excel, Word and PowerPoint by creating your own tab in the Ribbon. This way you can pick all the features you use most often and place them together in the same tab. Credit Leila Gharani

[thelearningzone]

4 Hidden Excel Dashboard Design Tips for Beautiful Reports

Microsoft Excel Tricks Creating Excel Dashboards can be very time consuming. You need to define the most important key performance indicators and find a reliable data source for your dashboard. But the visual representation of the data is just as important. Credit Leila Gharani

[thelearningzone]

When Should you Use the Hash Sign (#) in Excel Formulas?

Microsoft Excel Tricks The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference an entire spilled range. You can only use this if you have Office 365 version and already have Excel functions like filter, unique and sort. Credit Leila Gharani

[thelearningzone]

Easily Calculate Ratios in Excel

Microsoft Excel Tricks Learn to easily calculate the ratio of two numbers in Excel with Excel formulas. A ratio tells you how much of one thing there is, compared to another thing. It's a common way to compare amounts. Credit Leila Gharani