FOUR COURSE Training Pack: Learn Excel from Beginners to Professional in Easy Steps, with course workbooks & exercises | Discount Coupon for Udemy Course
Last updated 2/2021Course Language EnglishCourse Caption English [Auto]Course Length 12:03:53 to be exact 43433 seconds!Number of Lectures 215
This course includes:
12 hours hours of on-demand video
Full lifetime access
Access on mobile and TV
Certificate of completion
8 additional resources
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
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!Who this course is for:This package is great for every level of Excel user!If you're new to Excel, we show you what do do from the very beginning, so you needn't feel intimidated.If you're an existing user, we can take you as far as you're likely to want to goIf you're an advanced user, we're sure there's plenty there to learn - though check the content: we don't cover advanced VBA and programming in this package, for example.And at all levels, don't 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.
Course Content:
Sections are minimized for better readability, click the section title to view the course content
1 Lectures | 01:17
Introduction Course Overview - Includes the course workbook & exercises
01:17
10 Lectures | 25:16
Introduction
01:25
Starting Out - Overview
01:51
Opening Excel
04:28
Starting Out
00:52
About Workbooks - Overview
00:41
About Workbooks
07:48
Exploring your Workbook - Overview
01:00
Exploring your Workbook
01:33
Getting Help with Excel - Overview
00:42
Getting Help with Excel
04:56
15 Lectures | 45:44
Introduction
01:50
The Quick Access Toolbar and File Menu - Overview
00:45
The Quick Access Toolbar and File Menu
04:01
The Home Tab - Overview
00:46
The Home Tab
05:57
The Insert Tab - Overview
00:35
The Insert Tab
04:51
The Page Layout Tab - Overview
00:34
The Page Layout Tab
05:22
The Formulas Tab - Overview
00:48
The Formulas Tab
07:57
The Data Tab - Overview
00:34
The Data Tab
05:12
The Review Tab - Overview
00:52
The Review Tab
05:40
11 Lectures | 40:15
Introduction
01:10
Working with Excel - Overview
00:35
Working with Excel
05:43
Moving your Data - Overview
01:04
Moving your Data
03:07
Basic Excel Features - Overview
00:52
Basic Excel Features
07:35
Smart Tags and Options Buttons - Overview
01:58
Smart Tags and Options Buttons
09:19
Editing Tools - Overview
00:45
Editing Tools
08:07
7 Lectures | 21:23
Introduction
01:30
Cell Formatting - Overview
00:21
Cell Formatting
07:26
Conditional Formatting - Overview
01:04
Conditional Formatting
04:17
Enhancing a Worksheet's Appearance - Overview
00:33
Enhancing a Worksheet's Appearance
06:12
12 Lectures | 35:17
Introduction
00:58
Using the View Tab - Overview
02:01
Using the View Tab
05:45
Using the View Tab
03:01
Managing a Single Window - Overview
01:12
Managing a Single Window
05:15
Managing Multiple Windows - Overview
00:34
Managing Multiple Windows
04:21
Setting Up Your Workbook - Overview
00:47
Setting Up Your Workbook
05:52
Printing Options - Overview
00:47
Print Page Layout Options
04:44
7 Lectures | 19:57
Introduction
01:13
Using Recommended and Standard Charts - Overview
01:06
Using Recommended and Standard Charts
03:45
Chart Elements - Overview
00:28
Chart Elements
06:44
Chart Tools - Design & Format - Overview
01:03
Chart Tools - Design & Format
05:38
1 Lectures | 01:19
Intermediate Course Overview - Includes the course workbook & exercises
01:19
9 Lectures | 26:30
Introduction
01:10
Saving and File Management - Overview
00:48
Saving and File Management
04:19
Converting and Encrypting Files - Overview
01:34
Converting and Encrypting Files
06:10
File Properties and Digital Signatures - Overview
00:59
File Properties and Digital Signatures
03:26
File Accessibility and Compatibility - Overview
01:51
File Accessibility and Compatibility
06:13
15 Lectures | 01:08:19
Introduction
01:56
Formulas with References - Overview
00:59
Absolute References - Overview
01:49
Formulas with Absolute References
06:25
Autosum Functions (SUM & AVERAGE) - Overview
02:56
Autosum Functions (SUM & AVERAGE)
04:43
IF and Nested Functions - Overview
02:38
IF and Nested Functions
13:10
Working with Named Ranges - Overview
01:50
Working with Named Ranges
04:39
Array Functions (SUMIF & AVERAGEIF) - Overview
02:08
Array Functions (SUMIF & AVERAGEIF)
06:50
Array Functions (SUMIF & AVERAGEIF)
08:10
Formula Auditing - Overview
01:49
Formula Auditing
08:17
8 Lectures | 29:39
Introduction
01:19
Creating Excel Tables - Overview
00:56
Creating Excel Tables
09:07
Working with Records and Filters - Overview
00:42
Working with Records and Filters
02:12
Working with Records and Filters
09:32
Advanced Filters - Overview
01:22
Advanced Filters
04:29
9 Lectures | 33:39
Introduction
01:54
Text to Columns - Overview
01:19
Text to Columns
05:34
Remove Duplicates - Overview
01:12
Remove Duplicates
04:44
Data Validation - Overview
01:00
Data Validation
09:53
Consolidate - Overview
01:44
Consolidate
06:19
9 Lectures | 29:42
Introduction
01:23
Trendlines - Overview
01:00
Trendlines
04:46
Error Bars - Overview
00:39
Error Bars
04:54
Working with Axis Options - Overview
01:16
Working with Axis Options
08:36
Advanced Chart Formatting - Overview
00:54
Advanced Chart Formatting
06:14
2 Lectures | 06:35
Sparklines - Overview
02:01
Sparklines
04:34
1 Lectures | 01:29
Advanced Course Overview - Includes the course workbook & exercises
01:29
5 Lectures | 13:28
Introduction
00:46
Outlining and Grouping Data - Overview
00:36
Outlining and Grouping Data
05:40
Using the Subtotals Tool - Overview
00:57
Using the Subtotals Tool
05:29
8 Lectures | 34:22
Introduction
01:00
Exploring Scenarios - Overview
01:25
Exploring Scenarios
08:42
Goal Seek and Data Tables - Overview
03:17
Goal Seek
03:10
Data Tables
06:11
Using Solver - Overview
01:48
Using Solver
08:49
9 Lectures | 35:31
Introduction
01:02
Getting Started with PivotTables - Overview
01:00
Getting Started with PivotTables
04:53
Displaying Data in a PivotTable - Overview
01:09
Displaying Data in a PivotTable
09:07
Formatting a PivotTable - Overview
01:08
Formatting a PivotTable
08:19
Slicers - Overview
01:59
Slicers
06:54
5 Lectures | 14:27
Introduction
00:58
Getting Started with PivotCharts - Overview
00:56
Getting Started with PivotCharts
04:33
PivotChart Tools and Formatting - Overview
00:43
PivotChart Tools and Formatting
07:17
8 Lectures | 29:22
Introduction
00:39
Excel and Hyperlinks - Overview
01:12
Excel and Hyperlinks
08:29
Using Custom AutoFill Lists - Overview
00:41
Using Custom AutoFill Lists
05:23
Sharing Workbooks - Overview
00:43
Sharing Workbooks
06:26
Tracking Changes
05:49
5 Lectures | 15:53
Introduction
00:54
Using the VLOOKUP Function - Overview
02:41
Using the VLOOKUP Function
05:44
Using the LOOKUP Function - Overview
01:48
Using the LOOKUP Function
04:46
6 Lectures | 30:21
Introduction
01:05
Recording and Playing Macros - Overview
01:01
Recording and Playing Macros
13:05
The VBA Editor - Overview
01:48
The VBA Editor
05:25
Visual Basic and Macros
07:57
1 Lectures | 01:28
Professional Course Overview - Includes the course workbook & exercises
01:28
7 Lectures | 15:06
Introduction
01:16
Editing Standard Formatting Rules - Overview
00:57
Editing Standard Formatting Rules
04:37
Using Formulas in Conditional Formatting - Overview
00:43
Using Formulas in Conditional Formatting
04:17
More Formulas - Overview
00:46
More Formulas
02:30
5 Lectures | 20:06
Introduction
01:27
Using Form Controls - Overview
01:03
Using Form Controls
11:21
Creating Templates - Overview
00:39
Creating Templates
05:36
11 Lectures | 31:37
Introduction
02:33
Using the Index Function - Overview
01:18
Using the Index Function
03:19
Using the Index Function
02:44
Using the Match Function - Overview
01:33
Using the Match Function
02:03
Using Index and Match Together - Overview
00:56
Using Index and Match Together
05:27
Using Index and Match Together
05:11
Using the Indirect Function - Overview
02:09
Using the Indirect Function
04:24
12 Lectures | 36:08
Introduction
01:29
Using Error Functions - Overview
01:37
Using Error Functions
06:18
Conditional Error Functions
04:33
Using Logical Functions - Overview
00:48
Using Logical Functions
03:36
Using Array Formulas - Overview
02:08
Using Array Formulas
03:13
Using Array Formulas
02:12
Using Array Formulas
03:33
Using Rounding Functions - Overview
00:54
Using Rounding Functions
05:47
9 Lectures | 27:20
Introduction
01:16
Importing Pivot Table Data - Overview
00:57
Importing Pivot Table Data
05:29
Calculated Fields in Pivot Tables - Overview
00:56
Calculated Fields in Pivot Tables
05:21
Showing Pivot Data as a Percentage - Overview
01:00
Showing Pivot Data as a Percentage
06:41
Creating Custom Pivot Tables Styles - Overview
00:47
Creating Custom Pivot Tables Styles
04:53
7 Lectures | 32:23
Introduction
01:35
Creating a User Defined Function - Overview
00:57
Creating a User Defined Function
10:12
Creating an Interactive Procedure - Overview
00:40
Creating an Interactive Procedure
09:26
Create and Share a Function Add-in - Overview
01:10
Create and Share a Function Add-in
08:23
4.45
(23 course ratings)
1
0/23
2
1/23
3
2/23
4
8/23
5
12/23
JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED
If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.
Free Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
FOUR COURSE Training Pack: Learn Excel from Beginners to Professional in Easy Steps, with course workbooks & exercises
FAQ: Udemy Free course Most frequent questions and answers
Does Udemy offer Free Udemy coupons?
Yes, Udemy is the largest online education platform, with the broadest selection of video-on-demand courses and qualified instructors available to meet your needs. At theprogrammingbuddy.club we curate the latest udemy coupons, their expiry, and the number of uses left of these udemy coupons.
How to get free Udemy courses?
There are two ways to get free Udemy courses:
Go to udemy.com and search for your desired course category. Then select free from the filter options.
You can also get paid courses for free if you have a coupon. You can head to theprogrammingbuddy.club, where you can get a daily udemy paid course for free.
How to get Udemy Certificates for free?
Udemy offers certification on completion of each course. In order to receive a certificate of completion from Udemy, you need to complete your course 100%. There is a simple hack, you can open a video and jump on the timeline to complete a lecture.
To download the certificate from Udemy, you need to head over to your account on a desktop browser. Udemy certificates can't be accessed on the mobile app.
Do Udemy courses expire?
No, once you enroll, you will have lifetime access to the course. You can complete the course on your schedule.
Why are the Udemy instructors giving away free Udemy Coupons?
Every instructor has worked for hours on each of their courses. As new courses get launched, the instructors have no way to get their course in front of an audience to get some feedback. So, instructors share free coupons for their courses to get feedback from the students. We attheprogrammingbuddy.club work with these instructors to get their courses available to our buddies.
Is Udemy safe to use?
Yes, payments on Udemy are safe. It is no different than paying for other services on an application or website and inputting your payment information before receiving your goods. Just be sure to keep your account secure, do not share your udemy accounts.
Can Udemy courses get you a job?
Earning a skill is more valuable than earning a job these days. Skills are your most valuable asset. They can help you qualify for jobs you want and get promoted to more advanced positions within your organization. Unfortunately, it is difficult for many people to balance taking courses with work and family obligations. We have had many students, who have taken just Udemy courses, started a job as well as started freelancing with the skills they have learned.