The importance of Defined Names and Excel Tables is detailed in our course “Excel – Two Must Know Features: Defined…
Over the years, Excel has added MANY new features and functionality, yet most people still use it in the same…
This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced…
Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like…
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it…
Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using…
Before you can analyze data, you first must get the data. This course focuses on getting data into Excel using…
This course is designed to build the foundation to becoming an Excel formula expert. Our focus will be on design…
In this course, we will focus on Text functions and Date and Time functions. Want to automatically update the date…
In this course, we will focus on the Logical, Information and Lookup and Reference functions. In the Logical function section,…