Diploma in Microsoft Excel

Do you want to be known as a Microsoft Excel master? With this free online Microsoft Excel training course, you will ace this program and all it has to offer. Learn about worksheets, cell formatting, images, charts, templates, and what exactly the Excel database is along with specific Excel functions, formula auditing, and much more so you can use your new Excel skills in the workplace no matter which line of business you are in.

What You Will Learn In This Free Course

Starting with Excel

This module introduces you to Microsoft Excel. It covers Excel as a powerful spreadsheet program, along with its interface. You will learn how to minimize the ribbon and customize the status bar, the ribbon and the quick access toolbar. You will be taught how to format date values in Excel and use formulas. Referencing will also be covered.

Function Worksheet and Cell Formatting

In this module, you will learn about Excel functions. We will cover statistical functions such as Min, Max, Average, and Sum. You will be taught how to insert and delete rows and columns. You will also be taught how to adjust the width and height of cells and protect the workbook. Finally, we will address cell formatting.

Images, Charts and Templates

In this module, you will be taught how to insert images, customise icons or convert these icons into shapes. You will learn how to use charts, change their design and format their elements. We will cover Excel?s printing options. You will also learn about the benefits of using Excel templates and how to create them.

Excel Database

In this module, you will learn how to sort data and prepare it for analysis. You will be taught multilevel and custom sorting. You will be introduced to Excel database functions and taught how to use these functions by specifying conditions or criteria. Excel data validation will be covered, along with the various types of data validation.

First Course Assessment

This First Course Assessment enables you to review your learning so you can determine your knowledge and understanding of Module 1 to 4 of the following course, Diploma in Microsoft Excel for Beginners and Experts.

Specific Excel Functions

This module covers specific Excel functions. Following the creation of Excel PivotTables, you will learn about Excel?s PowerPivot Add-In and how to activate it. In addition, learn to create relationships between data tables. You will also learn about Excel?s conditional functions, along with the COUNTIF Function and the LOOKUP Functions.

Functions, Tools and Formula Auditing

This module covers the text-based functions in Excel. You will be taught about the LEFT function, the RIGHT function and the MID function. You will learn about showing formulas, grouping data, and 3D referencing in formulas, along with utilizing the watch window and freezing panes. You will also be taught about Excel?s ?What If?? Tools.

Microsoft Excel VBA

This module covers Excel Visual Basic of Application (VBA). You will learn about the modules and procedures of the VBA language. You will be taught how to reference a range. You will also learn about InputBox and MsgBox. Looping is addressed and covers Excel VBA Loops, including ?For Next Loop?, ?Do Until Loop?, and ?For Each Loop?.

Macros, UserForms and Careers in Excel

This module will teach you how to assign macros to shapes, along with worksheet and workbook events. You will learn how to create Excel UserForms and add controls. You will also be taught how to start a career in Excel. You will discover how to create an Excel resume, personal branding, networking and freelancing.

Second Course Assessment

This Second Course Assessment enables you to review your learning so you can determine your knowledge and understanding of Module 5 to 8 of the following course, Diploma in Microsoft Excel for Beginners and Experts.

Course assessment