Microsoft Excel - The Ultimate Excel Course from ZandaX
- Description
- Curriculum
- FAQ
- Reviews
Whether you’re a new Excel user who wants to go to the highest level you can manage, or an existing user who’d like a combined “best practice” refresher, skills enhancer and a reference for whatever you may want in the future, this is the choice for you!
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 our instructors get to the point so you make the best use of your time.
The Introduction course takes you from the very basics in using the different tabs, working with data and editing data, formatting sheets, reviewing workbooks and creating charts.
The Intermediate course starts with file management, encryption and accessibility, before moving on to functions and formulas. It teaches you about using tables, data tools like validation, before moving on to more advanced charts and finishing with SparkLines.
The Advanced course really does take you to another level. It begins with grouping, outlining and subtotals before showing you how to perform What If Analysis, use PivotTables, perform advanced tasks before teaching you about HLOOKUP and VLOOKUP functions. If that wasn’t enough, it finishes with one of out most popular lectures: an introduction to Macros.
Finally, the Professional course you’ll learn about advanced ways of using conditional formatting, LOOKUPs, more functions and PivotTable tools. There’s a lecture on form controls and templates, and the final section introduces you to User Defined Functions (UDFs) using VBA.
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 at the start of each course – which really enhance and deepen your learning. Remember that practice makes perfect!
So although this is offered as a single course, it’s genuinely four courses in one – there are no shortcuts or reduced features. We don’t think you’ll find better value, so why not stop wondering which course to choose, and enrol with us now!
-
2IntroductionVideo lesson
-
3Starting Out - OverviewVideo lesson
-
4Opening ExcelVideo lesson
-
5Starting OutVideo lesson
-
6About Workbooks - OverviewVideo lesson
-
7About WorkbooksVideo lesson
-
8Exploring your Workbook - OverviewVideo lesson
-
9Exploring your WorkbookVideo lesson
-
10Getting Help with Excel - OverviewVideo lesson
-
11Getting Help with ExcelVideo lesson
-
12IntroductionVideo lesson
-
13The Quick Access Toolbar and File Menu - OverviewVideo lesson
-
14The Quick Access Toolbar and File MenuVideo lesson
-
15The Home Tab - OverviewVideo lesson
-
16The Home TabVideo lesson
-
17The Insert Tab - OverviewVideo lesson
-
18The Insert TabVideo lesson
-
19The Page Layout Tab - OverviewVideo lesson
-
20The Page Layout TabVideo lesson
-
21The Formulas Tab - OverviewVideo lesson
-
22The Formulas TabVideo lesson
-
23The Data Tab - OverviewVideo lesson
-
24The Data TabVideo lesson
-
25The Review Tab - OverviewVideo lesson
-
26The Review TabVideo lesson
-
27IntroductionVideo lesson
-
28Working with Excel - OverviewVideo lesson
-
29Working with ExcelVideo lesson
-
30Moving your Data - OverviewVideo lesson
-
31Moving your DataVideo lesson
-
32Basic Excel Features - OverviewVideo lesson
-
33Basic Excel FeaturesVideo lesson
-
34Smart Tags and Options Buttons - OverviewVideo lesson
-
35Smart Tags and Options ButtonsVideo lesson
-
36Editing Tools - OverviewVideo lesson
-
37Editing ToolsVideo lesson
-
38IntroductionVideo lesson
-
39Cell Formatting - OverviewVideo lesson
-
40Cell FormattingVideo lesson
-
41Conditional Formatting - OverviewVideo lesson
-
42Conditional FormattingVideo lesson
-
43Enhancing a Worksheet's Appearance - OverviewVideo lesson
-
44Enhancing a Worksheet's AppearanceVideo lesson
-
45IntroductionVideo lesson
-
46Using the View Tab - OverviewVideo lesson
-
47Using the View TabVideo lesson
-
48Using the View TabVideo lesson
-
49Managing a Single Window - OverviewVideo lesson
-
50Managing a Single WindowVideo lesson
-
51Managing Multiple Windows - OverviewVideo lesson
-
52Managing Multiple WindowsVideo lesson
-
53Setting Up Your Workbook - OverviewVideo lesson
-
54Setting Up Your WorkbookVideo lesson
-
55Printing Options - OverviewVideo lesson
-
56Print Page Layout OptionsVideo lesson
-
57IntroductionVideo lesson
-
58Using Recommended and Standard Charts - OverviewVideo lesson
-
59Using Recommended and Standard ChartsVideo lesson
-
60Chart Elements - OverviewVideo lesson
-
61Chart ElementsVideo lesson
-
62Chart Tools - Design & Format - OverviewVideo lesson
-
63Chart Tools - Design & FormatVideo lesson
-
65IntroductionVideo lesson
-
66Saving and File Management - OverviewVideo lesson
-
67Saving and File ManagementVideo lesson
-
68Converting and Encrypting Files - OverviewVideo lesson
-
69Converting and Encrypting FilesVideo lesson
-
70File Properties and Digital Signatures - OverviewVideo lesson
-
71File Properties and Digital SignaturesVideo lesson
-
72File Accessibility and Compatibility - OverviewVideo lesson
-
73File Accessibility and CompatibilityVideo lesson
-
74IntroductionVideo lesson
-
75Formulas with References - OverviewVideo lesson
-
76Absolute References - OverviewVideo lesson
-
77Formulas with Absolute ReferencesVideo lesson
-
78Autosum Functions (SUM & AVERAGE) - OverviewVideo lesson
-
79Autosum Functions (SUM & AVERAGE)Video lesson
-
80IF and Nested Functions - OverviewVideo lesson
-
81IF and Nested FunctionsVideo lesson
-
82Working with Named Ranges - OverviewVideo lesson
-
83Working with Named RangesVideo lesson
-
84Array Functions (SUMIF & AVERAGEIF) - OverviewVideo lesson
-
85Array Functions (SUMIF & AVERAGEIF)Video lesson
-
86Array Functions (SUMIF & AVERAGEIF)Video lesson
-
87Formula Auditing - OverviewVideo lesson
-
88Formula AuditingVideo lesson
External Links May Contain Affiliate Links read more