Microsoft Excel The Ultimate Excel Course from ZandaX

Microsoft Excel – The Ultimate Excel Course from ZandaX, available at $39.99, has an average rating of 4.4, with 215 lectures, based on 32 reviews, and has 1127 subscribers.

You will learn about FOUR courses – Introduction to Professional – with everything you need to take you from a complete beginner to a professional Excel user Each course has its own workbook with exercises – downloadable within the first Introduction module – so you can practice and reinforce what you have learned This great four-course pack covers everything from getting to know the interface, through functions & formulas to LOOKUPs, PivotTables & VBA. Click to see more! The INTRODUCTION course covers: Workbook Basics – the Excel Interface – Editing Tools – Formatting – Printing/Viewing – Working with Charts The INTERMEDIATE course covers: Advanced File Tasks – Functions & Formulas – Tables – Data Tools – More About Charts – Sparklines The ADVANCED course covers: Grouping & Outlining and Subtotals – WhatIf – Pivot Tables – Charting Pivots – LOOKUPs – Introduction to Macros The PROFESSIONAL course: Advanced Conditional Formatting – Form Controls & Templates – Array Formulas – Advanced LOOKUPs & Pivot Tables – User Defined Functions This course is ideal for individuals who are This package is great for every level of Excel user! or If youre new to Excel, we show you what do do from the very beginning, so you neednt feel intimidated. or If youre an existing user, we can take you as far as youre likely to want to go or If youre an advanced user, were sure theres plenty there to learn – though check the content: we dont cover advanced VBA and programming in this package, for example. or And at all levels, dont underestimate the value of a refresher – why, they may help you to clarify a few hazy areas, or even unlearn some bad habits! or Above all, we want you to get the most from your training, so make sure you enjoy your time doing the courses, and revisit them as often as you want. It is particularly useful for This package is great for every level of Excel user! or If youre new to Excel, we show you what do do from the very beginning, so you neednt feel intimidated. or If youre an existing user, we can take you as far as youre likely to want to go or If youre an advanced user, were sure theres plenty there to learn – though check the content: we dont cover advanced VBA and programming in this package, for example. or And at all levels, dont underestimate the value of a refresher – why, they may help you to clarify a few hazy areas, or even unlearn some bad habits! or Above all, we want you to get the most from your training, so make sure you enjoy your time doing the courses, and revisit them as often as you want.

Enroll now: Microsoft Excel – The Ultimate Excel Course from ZandaX

Summary

Title: Microsoft Excel – The Ultimate Excel Course from ZandaX

Price: $39.99

Average Rating: 4.4

Number of Lectures: 215

Number of Published Lectures: 215

Number of Curriculum Items: 215

Number of Published Curriculum Objects: 215

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

FOUR courses – Introduction to Professional – with everything you need to take you from a complete beginner to a professional Excel user

Each course has its own workbook with exercises – downloadable within the first Introduction module – so you can practice and reinforce what you have learned

This great four-course pack covers everything from getting to know the interface, through functions & formulas to LOOKUPs, PivotTables & VBA. Click to see more!

The INTRODUCTION course covers: Workbook Basics – the Excel Interface – Editing Tools – Formatting – Printing/Viewing – Working with Charts

The INTERMEDIATE course covers: Advanced File Tasks – Functions & Formulas – Tables – Data Tools – More About Charts – Sparklines

The ADVANCED course covers: Grouping & Outlining and Subtotals – WhatIf – Pivot Tables – Charting Pivots – LOOKUPs – Introduction to Macros

The PROFESSIONAL course: Advanced Conditional Formatting – Form Controls & Templates – Array Formulas – Advanced LOOKUPs & Pivot Tables – User Defined Functions

Who Should Attend

This package is great for every level of Excel user!

If youre new to Excel, we show you what do do from the very beginning, so you neednt feel intimidated.

If youre an existing user, we can take you as far as youre likely to want to go

If youre an advanced user, were sure theres plenty there to learn – though check the content: we dont cover advanced VBA and programming in this package, for example.

And at all levels, dont underestimate the value of a refresher – why, they may help you to clarify a few hazy areas, or even unlearn some bad habits!

Above all, we want you to get the most from your training, so make sure you enjoy your time doing the courses, and revisit them as often as you want.

Target Audiences

This package is great for every level of Excel user!

If youre new to Excel, we show you what do do from the very beginning, so you neednt feel intimidated.

If youre an existing user, we can take you as far as youre likely to want to go

If youre an advanced user, were sure theres plenty there to learn – though check the content: we dont cover advanced VBA and programming in this package, for example.

And at all levels, dont underestimate the value of a refresher – why, they may help you to clarify a few hazy areas, or even unlearn some bad habits!

Above all, we want you to get the most from your training, so make sure you enjoy your time doing the courses, and revisit them as often as you want.

Whether you’re a brand new Excel user who wants to go from the basics 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 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 classroom environments 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 Introductioncourse takes you from the very basics in opening and saving workbooks, using the different tabs, working with data and editing data, formatting sheets, reviewing workbooks and creating charts.

The Intermediatecourse 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 Advancedcourse 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, in the Professionalcourse 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!

Course Curriculum

Chapter 1: General Introduction to Excel Introduction

Lecture 1: Introduction Course Overview – Includes the course workbook & exercises

Chapter 2: Getting Started with Microsoft Excel

Lecture 1: Introduction

Lecture 2: Starting Out – Overview

Lecture 3: Opening Excel

Lecture 4: Starting Out

Lecture 5: About Workbooks – Overview

Lecture 6: About Workbooks

Lecture 7: Exploring your Workbook – Overview

Lecture 8: Exploring your Workbook

Lecture 9: Getting Help with Excel – Overview

Lecture 10: Getting Help with Excel

Chapter 3: The Excel Interface

Lecture 1: Introduction

Lecture 2: The Quick Access Toolbar and File Menu – Overview

Lecture 3: The Quick Access Toolbar and File Menu

Lecture 4: The Home Tab – Overview

Lecture 5: The Home Tab

Lecture 6: The Insert Tab – Overview

Lecture 7: The Insert Tab

Lecture 8: The Page Layout Tab – Overview

Lecture 9: The Page Layout Tab

Lecture 10: The Formulas Tab – Overview

Lecture 11: The Formulas Tab

Lecture 12: The Data Tab – Overview

Lecture 13: The Data Tab

Lecture 14: The Review Tab – Overview

Lecture 15: The Review Tab

Chapter 4: Microsoft Excel Basics

Lecture 1: Introduction

Lecture 2: Working with Excel – Overview

Lecture 3: Working with Excel

Lecture 4: Moving your Data – Overview

Lecture 5: Moving your Data

Lecture 6: Basic Excel Features – Overview

Lecture 7: Basic Excel Features

Lecture 8: Smart Tags and Options Buttons – Overview

Lecture 9: Smart Tags and Options Buttons

Lecture 10: Editing Tools – Overview

Lecture 11: Editing Tools

Chapter 5: Editing Your Workbook

Lecture 1: Introduction

Lecture 2: Cell Formatting – Overview

Lecture 3: Cell Formatting

Lecture 4: Conditional Formatting – Overview

Lecture 5: Conditional Formatting

Lecture 6: Enhancing a Worksheets Appearance – Overview

Lecture 7: Enhancing a Worksheets Appearance

Chapter 6: Printing and Reviewing Your Workbook

Lecture 1: Introduction

Lecture 2: Using the View Tab – Overview

Lecture 3: Using the View Tab

Lecture 4: Using the View Tab

Lecture 5: Managing a Single Window – Overview

Lecture 6: Managing a Single Window

Lecture 7: Managing Multiple Windows – Overview

Lecture 8: Managing Multiple Windows

Lecture 9: Setting Up Your Workbook – Overview

Lecture 10: Setting Up Your Workbook

Lecture 11: Printing Options – Overview

Lecture 12: Print Page Layout Options

Chapter 7: Working with Charts in Excel

Lecture 1: Introduction

Lecture 2: Using Recommended and Standard Charts – Overview

Lecture 3: Using Recommended and Standard Charts

Lecture 4: Chart Elements – Overview

Lecture 5: Chart Elements

Lecture 6: Chart Tools – Design & Format – Overview

Lecture 7: Chart Tools – Design & Format

Chapter 8: General Introduction to Excel Intermediate

Lecture 1: Intermediate Course Overview – Includes the course workbook & exercises

Chapter 9: Advanced File Tasks

Lecture 1: Introduction

Lecture 2: Saving and File Management – Overview

Lecture 3: Saving and File Management

Lecture 4: Converting and Encrypting Files – Overview

Lecture 5: Converting and Encrypting Files

Lecture 6: File Properties and Digital Signatures – Overview

Lecture 7: File Properties and Digital Signatures

Lecture 8: File Accessibility and Compatibility – Overview

Lecture 9: File Accessibility and Compatibility

Chapter 10: Working with Functions and Formulas

Lecture 1: Introduction

Lecture 2: Formulas with References – Overview

Lecture 3: Absolute References – Overview

Lecture 4: Formulas with Absolute References

Lecture 5: Autosum Functions (SUM & AVERAGE) – Overview

Lecture 6: Autosum Functions (SUM & AVERAGE)

Lecture 7: IF and Nested Functions – Overview

Lecture 8: IF and Nested Functions

Lecture 9: Working with Named Ranges – Overview

Lecture 10: Working with Named Ranges

Lecture 11: Array Functions (SUMIF & AVERAGEIF) – Overview

Lecture 12: Array Functions (SUMIF & AVERAGEIF)

Lecture 13: Array Functions (SUMIF & AVERAGEIF)

Lecture 14: Formula Auditing – Overview

Lecture 15: Formula Auditing

Chapter 11: Managing Tables in Microsoft Excel

Lecture 1: Introduction

Instructors

ZandaX Training
80,000 students cant be wrong!

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 14 votes

5 stars: 14 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!