Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to MS Excel 2013|
Lesson Files (Download these first)
What is Microsoft Excel?
|Section 2: Navigation and Basic Tasks in Excel|
Excel File Formats and Extensions
Excel Navigation Tabs
Excel Contextual Tabs
The Developer Tab
The Quick Access Toolbar - Overview and Configuration
|Section 3: Workbook|
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
|Section 4: Arranging and Formatting Worksheets|
Adding and Deleting Worksheets
Renaming and Formatting Worksheet Tabs
Rearranging Worksheets and moving between Workbooks
Hiding- and Unhiding Worksheets
Viewing Multiple Worksheets on one Screen
|Section 5: Designing and Formatting Cells, Sheets and Workbooks|
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
|Section 6: Data Entry in Excel|
Entering Texts and Numbers
|Section 7: Formulas and Basic Calculations|
Basic Calculations: Addition
Basic Calculations: Subtraction
Basic Calculations: Multiplication
Basic Calculations: Division
Order of Calculation
|Section 8: Creating Charts in Excel|
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
|Section 9: Basic Functions|
Entering Data with AutoFill: Month series
Entering Data with AutoFill: Creating your Custom AutoFill List
The SUM Function
The AutoSum Function
The SUMIF Function
The AVERAGE Function
The MAX Function
The Min Function
|Section 10: Date and Time Functions|
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
|Section 11: Data and Text Functions|
The CONCATENATE Function - Building Text Strings from Cell Values
The DOLLAR Function - Converting Numbers to Currency Strings
The EXACT Function - Comparing Text Strings
The LEFT(); MID(); RIGHT() Function - Extracting Text Parts
THE LOWER UPPER Function - Converting to Uppercase and Lowercase Letters
THE PROPER Function - Converting First Letter to Uppercase
|Section 12: Conditional Formatting|
What is Conditional Formatting?
Own Value Conditional Formatting
Between Own Value Conditional Formating
Equal to Own Value Conditional Formatting
Text that contains Own Value Conditional Formatting
Date occuring Own Value Conditional Formatting
Duplicate Own Value Conditional Formatting
TopBottom 10 - Relative Conditional Formatting
TopBottom 10percent - Relative Conditional Formatting
Average - Relative Conditional Formatting
Trend - Relative Conditional Formatting
Custom Conditional Formatting Rules
Formula Conditional Formatting Rules
Conditional Formatting Rules Manager
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.