Xlookup: One of Excel Most Vital Functions.
In our course, vital functions like the XLOOKUP function are taught from two angles- the user’s view and the function’s view. In this lesson example , the XLOOKUP explains how it works and how it can help you save time and avoid hassle.
The Key to Understanding Pivot Tables.
Pivot Tables are one of the great tools in Excel. If your job involves data analysis, learn about them today. In this lesson, we explain the real KEY to understanding and mastering pivot tables and power pivots.
Printing Your Workbooks.
In this lesson from our online excel course, you will master printing your worksheets and workbooks . Learn all the tricks and techniques and save yourself hours of frustration.
In the course itself , you will be able to download the practice worksheet for this lesson and practice all that you have learnt.
[button link=”https://onlineexceltraining.com/register/workplace-excel-online-course/” size=”small” color=”lightblue” class=”pill” align=”right”] Order Now [/button]
Master Form Controls in Excel.
In this sample lesson from our course, you will learn about form controls in Excel , how to build and use them and some great examples of them in action.
In the course, you will be able to download the practice worksheet for this lesson and practice all that you have learnt.
What are Power Pivots
This is a lesson from our advanced course -Power Excel .
Its introduces Power Pivots and explains what they are. If you use ordinary pivot tables and find them limiting, then this lesson is definitely worth watch.