Free Online Microsoft Excel Advanced Training Course

This free online Microsoft Excel 2013 advanced training course will teach you how to use advanced functions and formulas in Excel, and supercharge your Excel skills. You will learn how to use functions and do statistical analysis of data in Excel. This course is aimed at learners with an existing understanding of Excel looking to multiply their spreadsheet productivity. Start this course today to take your spreadsheeting skills to the next level.

What You Will Learn In This Free Course

Introduction to Advanced Excel 2013

This module introduces you to Advanced Excel 2013 and outlines what you can expect to learn in this free online course.; Module

Functions

This module teaches you about the workings and concepts of functions in Excel 2013. It outlines a list of functions, common types of Arguments and various advanced aspects of functions.; Module

Personal and Professional Financial Functions

This module provides a comprehensive exploration of some of the personal and professional financial functions available through Excel 2013. A series of case studies and practical exercises enable the learner to gain a thorough understanding of Excel 2013.

Date and Time Functions

This module guides you through the uses of Date and Time Functions in Excel 2013. It outlines how dates and times are stored, explores the calculation of dates and times and provides exercises on date and time functions so that you can test your knowledge in a practical setting.

Statistical Functions for Description, Prediction and Inference

This module outlines different types of statistical functions in Excel 2013. It also explores averages, percentiles, regression and the LINEST function.; Module

Text Functions

This module teaches you about the functions of manipulating text in Excel 2013. It guides you through the ways in which you can separate pieces of text into separate cells, shows you how to convert text into a numerical format and explains how to remove leading and trailing spaces from text strings.

Lookup and Logical Functions

This module outlines the various uses of the lookup functions in Excel 2013. It shows you how to set up and use both VLOOKUP and HLOOKUP functions as well as how to create an IFNA and an IF statement in a function.

Connecting to External Data

Learn about the ways in which Excel can be connected to external data, including connecting to Access data, connecting to web data and connecting to other workbooks.; Module

Tables

In this final module, you will learn about creating, designing, manipulating and organizing tables in Excel 2013. This module includes a look at removing duplicates, resizing tables and examines table styles and selection.

Course assessment