Subtotals help you to save bunch of time and let you handle with sales data, reports, etc.
Advanced Tutorial
-
-
In this lesson you can learn how to separate the text written in one cell. For this purpose one of the possibilities Excel is Text to Columns. This option is used to separate text, usually copied from another source such as the Internet.
-
Do you have cells which are extremely important for you? This lesson is for you.
-
Learn here how to do What-If Analysis within Excel. Well explained by examples.
-
You can use XML files in Excel as well. Learn here how to do it. Step by step explained tutorial for you.
-
Pivot table tutorial – you MUST know it and you will know after reading this.
-
Lesson about regression analysis and using analysis toolpak in Excel
-
Sharing a workbook is useful when many people have to make changes in one file in a short time. Learn some more.
-
Learn how to use SmartArt in Excel. Free tutorial for you. Check this out.
-
Enter and learn how to use Solver Add-in. Step by step online tutorial for you is waiting here.