Ultimate Microsoft Excel Course - Beginner to Expert in 5h
4.6 (154 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,941 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.6 (154 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,941 students enrolled
Created by Jan Marc
Last updated 2/2016
English
Current price: $10 Original price: $90 Discount: 89% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • No requirments needed. Course material starts with the basiscs. If you are an advanced user, just start at the apropriate lessons
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.

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

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

Excel Navigation Tabs
04:39

Excel Contextual Tabs
02:08

The Developer Tab
02:10

+
Workbook
7 Lectures 28:41
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
+
Arranging and Formatting Worksheets
6 Lectures 24:50
Adding and Deleting Worksheets
03:26


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
+
Designing and Formatting Cells, Sheets and Workbooks
13 Lectures 44:28
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

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
03:44

Merging Cells
02:06
+
Data Entry in Excel
1 Lecture 02:59
Entering Texts and Numbers
02:59
+
Formulas and Basic Calculations
5 Lectures 22:22
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
+
Creating Charts in Excel
4 Lectures 26:41
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
+
Basic Functions
8 Lectures 38:29
Entering Data with AutoFill: Month series
01:42

Entering Data with AutoFill: Creating your Custom AutoFill List
03:16


The AutoSum Function
04:41


The AVERAGE Function
06:13

The MAX Function
04:40

The Min Function
02:33
+
Date and Time Functions
7 Lectures 31:51
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
2 More Sections
About the Instructor
Jan Marc
4.6 Average rating
154 Reviews
3,941 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.