Excel Level 1
Training available for Excel 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE.
Getting Started with Excel 2019
Understanding spreadsheet concepts, getting started, creating and saving workbooks, opening and closing workbooks.
Working with columns and rows, working with cell contents.
Using Formulas and Functions
Creating and using formulas, creating and using functions, using absolute cell references, inserting functions.
Formatting and Viewing Worksheets
Formatting worksheets, viewing worksheets.
Using workbook views, changing the page setup, previewing and printing workbooks.
Excel Level 2
Managing range names, creating and using workbook templates, applying worksheet security, creating and using outlines.
Using the IF function, using the IFS function, linking formulas, modifying and restoring links.
Using Multiple Workbooks and Worksheets
Working with multiple workbooks, working with multiple worksheets, consolidating data.
Working with Charts
Creating charts, changing chart data, modifying chart elements, creating custom charts.
Working with styles, annotating worksheets, using sparklines.
Excel Level 3 Data Management
Data list and excel table concepts, using data forms, using lookup tables.
Sorting concepts, sorting lists, custom sort orders.
Filtering concepts, using AutoFilter, using advanced filter, working with filtered data.
Automatic subtotals, working with subtotalled lists ; using functions to summarize data.
Working with PivotTables
PivotTable concepts, creating PivotTables, modifying PivotTable layouts, working with PivotTables, PivotCharts, slicers.
Working with External Data
External data concepts, importing query data from Access, importing query data from web pages, importing query data from text files, importing text files using the import wizard.
Excel Level 3 Spreadsheet Analysis
Function concepts, absolute and mixed references, financial functions.
Goal Seek, data tables.
Performing What-If Scenarios
Scenario concepts, creating scenarios, managing scenarios ; scenario reports.
Solver concepts, defining the problem, solving the problem, Solver reports, Solver options.
Tracing a worksheet, evaluating formulas, locating and correcting errors in formulas, tracking cells in a workbook.
Microsoft Excel is a registered trademark of Microsoft Corporation. onsite‑training.com provides Excel training but is not affiliated with Microsoft.