BECOME THE GO-TO EXCEL EXPERT AT YOUR COMPANY
We Have Taught Professionals from 300+ Companies Including
Learn a new Excel tip or trick every week. You’ll also find some PowerPoint tips and Accounting articles here.
Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!
Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.
Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.
You probably know the quickest way to select a column of data in Excel is with the shortcut CTRL + Shift + ⯆. But what do you do if that column includes blank cells and you'd like to highlight the entire column of data? Check out this post to find out.
Check out this Excel formula hack to count text cells only. This mysterious syntax, excludes blank cells, numbers and also cells with formulas that result in an empty string.
LOOKING FOR SOMETHING SPECIFIC?
HAPPY STUDENTS FROM 135 COUNTRIES
★★★★★ “The instructor’s explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith
★★★★★ “Lots of tips and techniques. Already using them in my own work!” Alison
★★★★★ “It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great “hacks” for excel.” Teo
Get my Excel Tutorials & updates from me, directly to your Inbox:
You can expect to hear from me on a monthly basis. Unsubscribe anytime.
We pass on your support
By investing in your education through our courses, you give children in remote areas a chance for a better future.