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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Updated: 08 October 2024 08 October 2024