Add-ins
Add additional functionality to your applications.
Best Practices
Suggestions to make your workbooks easier to maintain.
Cells & Ranges
A range is a group of cells on a worksheet.
Charts
Produce visual representations of your data for maximum impact.
Conditional Formatting
Highlight cells automatically to identify certain values.
Data Analysis
Manipulate, analyze and interpret your data.
Data Validation
Restrict the type of data that can be entered.
Dates & Times
Format and manipulate all your dates and times.
Formatting
Themes, styles and custom number formats.
Finance
Introduction into financial markets and derivatives.
Formulas
Cell entries that perform calculations and return a result.
Functions
A complete list of all the built-in worksheet functions.
Illustrations
Includes shapes, textboxes, smartart and wordart.
Importing & Exporting
Work with text files, databases and web queries.
Layout
Modify the margins and print area of a worksheet.
Macros
Record your steps and analyze the generated code.
Named Ranges
Lets you to refer to a cell address using a name.
Options
Understand all the different options available in Excel.
Pivot Tables
Quickly aggregate, filter and summarise your data.
Power Query
Create data sources, connections and then transform.
Protection
Prevent changes and even hide important worksheets.
Reviewing
Add comments and notes when collaborating with others.
Ribbon
Customize the ribbon interface of the application.
Rows & Columns
Every worksheet is a grid of rows and columns.
Shortcut Keys
A complete list of all the keys available in Excel.
Tables
Manage and analyze a collection of related data.
Templates
Reuse pre-formatted worksheets and workbooks.
Track Changes
Easily see all the changes, insertions and deletions.
User Defined Functions
Create your own functions for custom calculations.
Workbooks
Save your information in one or more worksheets.
Worksheets
Collection of cells organised in rows and columns.
XML
A markup language and file format for saving data.
Add-ins
Add additional functionality to your applications.
Best Practices
Suggestions to make your workbooks easier to maintain.
Cells & Ranges
A range is a group of cells on a worksheet.
Charts
Produce visual representations of your data for maximum impact.
Conditional Formatting
Highlight cells automatically to identify certain values.
Data Analysis
Manipulate, analyze and interpret your data.
Data Validation
Restrict the type of data that can be entered.
Dates & Times
Format and manipulate all your dates and times.
Formatting
Themes, styles and custom number formats.
Finance
Introduction into financial markets and derivatives.
Formulas
Cell entries that perform calculations and return a result.
Functions
A complete list of all the built-in worksheet functions.
Illustrations
Includes shapes, textboxes, smartart and wordart.
Importing & Exporting
Work with text files, databases and web queries.
Layout
Modify the margins and print area of a worksheet.
Macros
Record your steps and analyze the generated code.
Named Ranges
Lets you to refer to a cell address using a name.
Options
Understand all the different options available in Excel.
Pivot Tables
Quickly aggregate, filter and summarise your data.
Power Query
Create data sources, connections and then transform.
Protection
Prevent changes and even hide important worksheets.
Reviewing
Add comments and notes when collaborating with others.
Ribbon
Customize the ribbon interface of the application.
Rows & Columns
Every worksheet is a grid of rows and columns.
Shortcut Keys
A complete list of all the keys available in Excel.
Tables
Manage and analyze a collection of related data.
Templates
Reuse pre-formatted worksheets and workbooks.
Track Changes
Easily see all the changes, insertions and deletions.
User Defined Functions
Create your own functions for custom calculations.
Workbooks
Save your information in one or more worksheets.
Worksheets
Collection of cells organised in rows and columns.
XML
A markup language and file format for saving data.