Learn MS Excel Online for Free

Creating named range, using names in new formulae, working with the name box, selecting range, names from a selection, pasting names in formulae, selecting names and working with Name Manager.

Various logical functions in Excel, the If function for calculating values and displaying text, nested If functions, VLookUp and IFError functions.

Learning about conditional formatting, the options for formatting cells, various operations with icon sets, data bars and color scales, creating and modifying Sparklines.

Introduction to dynamic table in Excel, data conversion, table conversion, tables for charts and VLOOKUP.

Sorting in Excel, various types of sorting including, alphabetical, numerical, row, multiple column, working with paste special, hyperlinking and using subtotal.

The concept of data filtering, understanding compound filter and its creation, removing of filter, using custom filter and multiple value filters, working with wildcards.

Creation of Charts in Excel, performing operations in embedded charts, modifying, resizing, and dragging of charts.

Introduction to the various types of charting techniques, creating titles for charts, axes, learning about data labels, displaying data tables, modifying axes, displaying gridlines and inserting trendlines, textbox insertion in a chart, creating a 2-axis chart, creating combination chart.

The concept of Pivot tables in Excel, report filtering, shell creation, working with Pivot for calculations, formatting of reports, dynamic range assigning, the slicers and creating of slicers.

Data and file security in Excel, protecting row, column, and cell, the different safeguarding techniques.

Learning about VBA macros in Excel, executing macros in Excel, the macro shortcuts, applications, the concept of relative reference in macros.

Learning how the If condition works and knowing how to apply it in various scenarios, working with multiple Ifs in Macro.

Learning to create Dashboards, the various rules to follow while creating Dashboards, creation of dynamic dashboards, knowing what is data layout, introduction to thermometer chart and its creation, how to use alerts in the Dashboard setup.

Understanding data quality issues in Excel, linking of data, consolidating and merging data, working with dashboards for Excel Pivot Tables.