Microsoft Excel Advanced: the Data Analysis Tools You Need
- Description
- Curriculum
- FAQ
- Reviews
Are you looking to use Excel to analyze your data?
With this course you’ll enter the world of analyzing your data, using your spreadsheets to interpret, illuminate and present your data in a whole new way.
With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the short “General Introduction” module at the start of each course). These are a great addition because they enable you to practice the skills you learn.
Our Microsoft instructors are seasoned professionals – they don’t just know the software: they’ve used it commercially and taught it in a classroom environment for years. You won’t be in better hands!
And we don’t woffle! Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and we get to the point so you make the best use of your time.
You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts. Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!
You will now be able to produce spreadsheets that not only display your data, but analyse and play tricks with it too …
Each lecture is self-contained, so you don’t need to sit through them all: once you’re at a comfortable level, you’ll be able to use this as your reference library, where you can select what you want to view.
We’ll say it again: don’t forget the course workbooks and exercises – downloadable with the first “General Introduction” module in each course – which really enhance and deepen your learning. Remember that practice makes perfect!
So this course is genuinely much more than just a talk-through video. We don’t think you’ll find better value, so why not enrol with us now?
-
15IntroductionVideo lesson
-
16Getting Started with PivotTables - OverviewVideo lesson
-
17Getting Started with PivotTablesVideo lesson
-
18Displaying Data in a PivotTable - OverviewVideo lesson
-
19Displaying Data in a PivotTableVideo lesson
-
20Formatting a PivotTable - OverviewVideo lesson
-
21Formatting a PivotTableVideo lesson
-
22Slicers - OverviewVideo lesson
-
23SlicersVideo lesson
-
29IntroductionVideo lesson
-
30Excel and Hyperlinks - OverviewVideo lesson
-
31Excel and HyperlinksVideo lesson
-
32Using Custom AutoFill Lists - OverviewVideo lesson
-
33Using Custom AutoFill ListsVideo lesson
-
34Sharing Workbooks - OverviewVideo lesson
-
35Sharing WorkbooksVideo lesson
-
36Tracking ChangesVideo lesson
External Links May Contain Affiliate Links read more