Menu

Search

The Microsoft Excel Zero to Master Complete Course

Microsoft Excel 2010, 2013, 2016, 2019 and 365 professional Master with Formulas, Charts, Pivot and VBA Macros
Instructor:
Manuel Estasio
223 students enrolled
English [Auto]
Learn to use Excel at the highest level, become a professional
You will be guided to consolidate your Excel basic Knowledge
Look into common and new Excel formulas
Manage large amounts of data, make your reports automatic and simplify your work routine
Follow the exercises and upgrade your Excel projects
Impress your colleagues with advanced formulas and pivot tables
Get to learn VBA and create the most significant macros with Excel
Follow the constant updates of the course and improve your skills

The Microsoft Excel Zero to Master Complete Course

A complete Master, recorded with Excel 365, constantly updated, made up of 5 levels which will make you a new Excel hero: Zero, Base, Intermediate, Advanced and Master.

The schedule provides a project with which you will be able to create and manage – on your own- a hypothetical Company- both as for the commercial part and for the administrative and bureaucratic part- in addition to a VBA project, with which you will create a data entry system, within an Excel file.

Suitable to any type of person, this course does not require any type of ITC know -how, you just need to have a PC to start off the adventure with this fantastic application program.

Every single recorded video was framed in a specific section so that to facilitate the learning, to give you the chance to follow it at your ease and at your own pace distributing the span of every step in the best possible way.

You will find more than 10 exercises helping you test what you’ve learned in the various phases of the course: the structure of every group of lesson was carefully planned to simulate a classroom experience, with the difference that it’s entirely up to you when to stop, easily acknowledging by yourself whether every topic has been fully grasped.

The topics of the lessons are the ones we consider essential to match the best expertise in the software with a perfect learning experience so that to enable you to work with Excel fully exploiting its potentials, at every level.

Every published update will be signposted: we will give you the opportunity to choose the topics to drill down.

Go through the list of the sections to get the idea of the carefulness displayed along this course: nothing is left to chance, everything is put forward in the easiest and in the most practical way and …don’t forget to follow our personal pages, where we will gradually insert all our courses, to become an absolute expert in the ITC realm!

If you have any questions, you can: check the list provided in this course- in case they have already been posted and answered-, use the Forum or simply ask! Any doubt deserves being resolved to enable you to learn everything without any difficulty.

Course Introduction

1
Course requirements
2
Course structure
3
Questions, reviews and course updates
4
Introduction to Microsoft Excel

Excel Zero: Getting Started

1
Create an Excel file
2
Excel interface
3
Rows, columns and cells
4
Save an Excel file
5
Open an Excel file

Excel Zero: Work Environment

1
Work environment and Excel sheet
2
Edit and hide rows and columns
3
Delete, duplicate and move an Excel sheet

Excel Zero: Text Formatting

1
Create your first words list
2
Create your first numbers list
3
Select, copy, paste and cut
4
Order, filter and remove duplicates
5
Find and replace
6
Fonts, text alignment and colors
7
Exercise #1 – To do List

Create a printable version of your first To-do list with Excel

8
Exercise #1 – SOLUTION

Excel Zero: Formulas

1
Structure of elementary Excel formulas
2
SUM math function
3
UPPER, LOWER and PROPER text functions
4
Arithmetical operators and calculation logic

Let’s explore the Bodmas logic, which Excel exploits to perform the calculations

5
Basic date and time functions

Let’s drill down the TODAY and WEEKNUM basic formulas

6
Exercise #2 – Name and years

Create a list of names and surnames, insert the ages and make the sum

7
Exercise #2 – SOLUTION

Excel Basics

1
Introduction to Excel Basics

Excel Basics: Fundamentals

1
Header and Footer
2
Table style formatting
3
Excel templates
4
Hyperlinks
5
Print preview
6
Exercise #3 – To do List template
7
Exercise #3 – SOLUTION

Excel Basics: Cells Formats

1
Text and special formats
2
Maths formats
3
Currency formats
4
Date and time formats
5
Percentage format

Excel Basics: Formulas

1
Structure of basic Excel formulas
2
COUNTA math function
3
AVERAGE math function
4
ROUNDUP and ROUNDDOWN math functions
5
LEN text function
6
CONCATENATE text function
7
ROW and COLUMN search functions
8
Exercise #4 – Text in five cells

Calculate the length of the text inserted in 5 cells, average it out and round it up

9
Exercise #4 – SOLUTION

Excel Intermediate

1
Introduction to Excel Intermediate

Excel Intermediate: Text Formatting

1
Text in columns
2
Conditional formatting
3
Format Painter

Copy the cell format into another cell

4
Transpose

Move a series of cells from a column to a row, or vice versa

5
Insert comments or notes
6
Advanced order
7
Advanced filters
8
Exercise #5 – To Do List cells text

Insert a comment to the cells and apply the conditional formatting to the previously created TO DO LIST

9
Exercise #5 – SOLUTION

Excel Intermediate: Content Management

1
Insert Picture
2
Insert shape and text box
3
Smart art, icons and 3D models
4
Arrange items
5
Insert background
6
Name management

Apply a customized name to cells, formulas, data ranges, columns and rows

Excel Intermediate: Formulas

1
IF logical function
2
IFERROR logical function
3
COUNTIF math function
4
VLOOKUP and HLOOKUP search functions
5
LEFT and RIGHT text functions
6
MID text function
7
SUBSTITUTE and REPLACE text functions
8
DATE, EMONTH and DATEVALUE date and time functions
9
Date and time expert functions

Let’s break through the intermediate-level formulas: NOW, DAYS360, YEAR, MONTH, DAY, HOUR , MINUTE, SECOND and TIME

10
Exercise #6 – Functions Mix

Starting from exercise 2, perform the following operations: Merge, Substitute, Identify, and Assign

11
Exercise #6 – SOLUTION

Excel Intermediate: Charts

1
Introduction to charts
2
Column and bar charts
3
Line chart
4
Pie chart
5
Hierarchical chart
6
Histogram

Lesson dedicated to the Pareto principle, in addition to the histograms without a growing trend

7
Bubble chart
8
Excel recommended charts
9
Modify and move chart
10
Exercise #7 – Revenue chart

Create a list of activities with data regarding cost, revenue and profit and insert a chart based on them

You can view and review the lecture materials indefinitely, like an on-demand channel.
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!

Be the first to add a review.

Please, login to leave a review
94eab8fa35497462f7940d6aff834ac0
Course available for 2 days
30-Day Money-Back Guarantee

Includes

13 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW