Ultimate Microsoft Excel Course - Beginner to Expert in 5h
4.4 (158 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,949 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ultimate Microsoft Excel Course - Beginner to Expert in 5h to your Wishlist.

Add to Wishlist

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.4 (158 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,949 students enrolled
Created by Jan Marc
Last updated 2/2016
Current price: $10 Original price: $90 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • No requirments needed. Course material starts with the basiscs. If you are an advanced user, just start at the apropriate lessons

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.

Who is the target audience?
  • Excel Beginner
  • Excel Intermediate User
  • Students
  • Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
78 Lectures
Introduction to MS Excel 2013
2 Lectures 02:32
Lesson Files (Download these first)

Navigation and Basic Tasks in Excel
5 Lectures 15:39
Excel File Formats and Extensions

Excel Navigation Tabs

Excel Contextual Tabs

The Developer Tab

7 Lectures 28:41
Creating a new Workbook

Saving a Workbook

Opening an existing Workbook

Navigating a Workbook

Navigating a Workbook with your Keyboard

Navigating a Workbook with your Mouse

Navigating a Workbook with the Scroll Bar
Arranging and Formatting Worksheets
6 Lectures 24:50
Adding and Deleting Worksheets

Rearranging Worksheets and moving between Workbooks

Copying Worksheets

Hiding- and Unhiding Worksheets

Viewing Multiple Worksheets on one Screen
Designing and Formatting Cells, Sheets and Workbooks
13 Lectures 44:28
Change the column width and row height

Adjusting the Fonttype of a cell, column or row

Adjusting the Default Fonttype

Adjusting the Fontsize of a cell, column or row

Adjusting the Fontcolour of a cell, column or row

Adjusting the Cell Contents Alignment

Adjusting the Cell Contents Indentation

Adjusting the Cell Contents Orientation

Adjusting the Number Format

Creating a Custom Number Format

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

Preview 03:59

Line break

Merging Cells
Data Entry in Excel
1 Lecture 02:59
Entering Texts and Numbers
Formulas and Basic Calculations
5 Lectures 22:22
Basic Calculations: Addition

Basic Calculations: Subtraction

Basic Calculations: Multiplication

Basic Calculations: Division

Order of Calculation
Creating Charts in Excel
4 Lectures 26:41
Introduction to Charts

How to create a Bar Chart with one Click

How to create a Pie Chart with one Click

How to create a Line Chart with one Click
Basic Functions
8 Lectures 38:29
Entering Data with AutoFill: Month series

Entering Data with AutoFill: Creating your Custom AutoFill List

The AutoSum Function

The AVERAGE Function

The MAX Function

The Min Function
Date and Time Functions
7 Lectures 31:51
The DATE Function - Combining Values into a Date Expression

The TODAY Function - Giving out the current Date

The DATEDIF Function - Calculating Time Intervals

The NOW Function - Giving out the current Date / Time Combination

The HOUR, DAY etc. Functions - Extracting Elements from Date and Time

The WEEKDAY Function - Accessing the Weekday as String

The NETWORKDAYS Function - Calculating Salaries
2 More Sections
About the Instructor
Jan Marc
4.4 Average rating
158 Reviews
3,949 Students
1 Course
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.