Ultimate Microsoft Excel Course - Beginner to Expert in 5h

Learn Excel online and become an expert Excel User without any prior knowledge. We cover all basics, graphs and formulas
4.2 (140 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,924 students enrolled
$19
$90
79% off
Take This Course
  • Lectures 78
  • Length 5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

With this Excel training course you will get a State of the Art introduction to Microsoft Excel 2013. Learning how to use Microsoft Excel has never been more important. No matter what job you have, creating good Excel spreadsheets is a requirement in most jobs, not a bonus. Everything becomes more data driven and creating functional Excel spreadsheet is required for this. This Microsoft Excel training course is here to help, even if you have never used Excel before. This Excel training is a comprehensive course which can be taken by beginners as well as advanced users.

This Excel Course takes a beginner with no prior Microsoft Excel knowledge as well as intermediate users from the basics of Microsoft Excel 2013 into deeper and more advanced functions of this powerful spreadsheet software. Based on the Microsoft Excel Version 2013 and 2010 you will be able to use the most important and frequently used functions for analyzing business and research data. This Excel Training Course is specifically designed for a practical use and illustrates all concepts with easy to follow examples and exercises that you can complete yourself in order to apply what you have learned in this excel course.

What will you learn in this Excel course?

You will learn to apply the best practices of analyzing and displaying data in an easy and understandable way. If you want to learn excel from the ground up and want to know all the functions that you will need 90% of the time then this Excel course is for you. With a clear explanation, many examples and the possibility to try out everything for yourself this Excel training course will accelerate your learning curve significantly.

If you are a more advanced user you can use this Excel training course as a reference guide. Because of its detailed structured you will be able to look up certain functions and refresh your memory on how to use them very quickly.

Once you have completed this Excel training course, you will be able to harness the power of Microsoft Excel and take boring data, analyze it properly and display it so that it is easily understandable.

All working files are included, allowing you to follow along throughout the lessons.

What are the requirements?

  • No requirments needed. Course material starts with the basiscs. If you are an advanced user, just start at the apropriate lessons

What am I going to get from this course?

  • Use Excel proficiently at work, creating functional dashboards and analyzing/visualizing data
  • Get a framework for approaching Excel problems of all kind in a standardized way

What is the target audience?

  • Excel Beginner
  • Excel Intermediate User
  • Students
  • Professionals

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to MS Excel 2013
Lesson Files (Download these first)
Article
What is Microsoft Excel?
02:26
Section 2: Navigation and Basic Tasks in Excel
Excel File Formats and Extensions
02:24
Excel Navigation Tabs
04:39
Excel Contextual Tabs
02:08
The Developer Tab
02:10
The Quick Access Toolbar - Overview and Configuration
Preview
04:18
Section 3: Workbook
Creating a new Workbook
03:18
Saving a Workbook
05:48
Opening an existing Workbook
03:44
Navigating a Workbook
01:30
Navigating a Workbook with your Keyboard
05:13
Navigating a Workbook with your Mouse
04:26
Navigating a Workbook with the Scroll Bar
04:42
Section 4: Arranging and Formatting Worksheets
Adding and Deleting Worksheets
03:26
Renaming and Formatting Worksheet Tabs
Preview
03:38
Rearranging Worksheets and moving between Workbooks
03:05
Copying Worksheets
01:58
Hiding- and Unhiding Worksheets
04:48
Viewing Multiple Worksheets on one Screen
07:55
Section 5: Designing and Formatting Cells, Sheets and Workbooks
Change the column width and row height
07:10
Adjusting the Fonttype of a cell, column or row
01:40
Adjusting the Default Fonttype
01:12
Adjusting the Fontsize of a cell, column or row
01:36
Adjusting the Fontcolour of a cell, column or row
01:24
Adjusting the Cell Contents Alignment
03:21
Adjusting the Cell Contents Indentation
03:09
Adjusting the Cell Contents Orientation
03:12
Adjusting the Number Format
03:34
Creating a Custom Number Format
08:21
03:59

Give your Worksheets a more compelling style by adding some subtle borders around Cells Columns and Rows. In this video you will learn how to select cells and implement different boarder styles

Line break
03:44
Merging Cells
02:06
Section 6: Data Entry in Excel
Entering Texts and Numbers
02:59
Section 7: Formulas and Basic Calculations
Basic Calculations: Addition
08:12
Basic Calculations: Subtraction
03:45
Basic Calculations: Multiplication
03:01
Basic Calculations: Division
03:19
Order of Calculation
04:05
Section 8: Creating Charts in Excel
Introduction to Charts
14:54
How to create a Bar Chart with one Click
03:14
How to create a Pie Chart with one Click
04:43
How to create a Line Chart with one Click
03:50
Section 9: Basic Functions
Entering Data with AutoFill: Month series
01:42
Entering Data with AutoFill: Creating your Custom AutoFill List
03:16
The SUM Function
Preview
11:16
The AutoSum Function
04:41
The SUMIF Function
Preview
04:08
The AVERAGE Function
06:13
The MAX Function
04:40
The Min Function
02:33
Section 10: Date and Time Functions
The DATE Function - Combining Values into a Date Expression
07:27
The TODAY Function - Giving out the current Date
02:39
The DATEDIF Function - Calculating Time Intervals
04:38
The NOW Function - Giving out the current Date / Time Combination
03:41
The HOUR, DAY etc. Functions - Extracting Elements from Date and Time
05:26
The WEEKDAY Function - Accessing the Weekday as String
04:04
The NETWORKDAYS Function - Calculating Salaries
03:56
Section 11: Data and Text Functions
The CONCATENATE Function - Building Text Strings from Cell Values
03:48
The DOLLAR Function - Converting Numbers to Currency Strings
04:00
The EXACT Function - Comparing Text Strings
05:22
The LEFT(); MID(); RIGHT() Function - Extracting Text Parts
04:50
THE LOWER UPPER Function - Converting to Uppercase and Lowercase Letters
03:11
THE PROPER Function - Converting First Letter to Uppercase
02:37
Section 12: Conditional Formatting
What is Conditional Formatting?
01:57
Own Value Conditional Formatting
04:37
Between Own Value Conditional Formating
01:33
Equal to Own Value Conditional Formatting
00:59
Text that contains Own Value Conditional Formatting
01:23
Date occuring Own Value Conditional Formatting
01:24
Duplicate Own Value Conditional Formatting
00:55
TopBottom 10 - Relative Conditional Formatting
03:49
TopBottom 10percent - Relative Conditional Formatting
03:49
Average - Relative Conditional Formatting
02:24
Trend - Relative Conditional Formatting
03:47
Custom Conditional Formatting Rules
03:34
Formula Conditional Formatting Rules
04:14
Conditional Formatting Rules Manager
03:07

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jan Marc, The MS Office Trainer

Over 15 years of experience in Excel packaged in one online course.

I started using Excel in university when studying Business Statistics. While using MS Excel extensively I gained a deep understanding of the power of MS Excel.

After university I started working as a corporate trainer for a large automotive group in Germany where I taught Excel on a daily basis in a practical environment to controllers, sales people and business executives for over 5 years.

Training over 10.000 People in in-Person Workshops

After realizing how much I enjoyed teaching and truly understanding how to apply the right concepts in order for people to understand the essences of Excel, I set out and started my own business education company. After working with over 10.000 individuals on in-person workshops over the course of 7 years I am now bringing my knowledge online in order to reach and teach even more people.

Practical Approach to Teaching

My approach is always practical. The student needs to experience everything he learned firsthand in order to really grasp and understand the concepts taught to him. That's why all my courses include practical exercises which the student will solve throughout the course, interaction with me and a truly detailed look at all the topics that are covered.

Ready to start learning?
Take This Course