What’s included in the Excel training courses?
Tailored Training: Covering intermediate or advanced training, bespoke to your business.
Time: 6 hour courses, delivered through four 90 minute sessions.
Excel; you either love it or you hate it. It’s loved because it allows you to store and track large amounts of data, perform calculations, analyse and interpret data and is ideal for things like budgeting and accounting. It’s hated, for the plain and simple fact, people don’t know how to use it. Excel’s capabilities are far more wide-reaching than performing basic sums or storing basic lists; it’s an incredibly powerful tool for analysis, if you have the right skills to use it.
Our Excel courses are tailored to meet your specific needs, taking you through all the features of Excel you require, often focussing on a specific business requirement.
Course content includes:
Excel Fundamentals
- Introduction to spreadsheets including familiarisation with the screen elements of Excel and understanding workbooks, worksheets and pages
- Gain a better understanding of navigating and working with data, with things like formatting spreadsheets, copying and moving data, formatting numeric and text data, working with Sheets, saving and sharing etc.
- Learn how to use formula and functions, such as basic formulae, entering formulas to perform calculations, using Sum Function to total numeric data, applying Excel functions to calculate the total, minimum, maximum and average of data and linking cells between worksheets
- Other helpful tips like working with Excel lists and tables, creating columns, bar, pie and line charts with spreadsheet data, Excel views, how to prepare a spreadsheet for printing/pdf with page breaks, headers and footers, scale of print and printing/PDF workbook information
Excel Intermediate
- A detailed look at the use of Excel formula and visual representation of data
- More detailed learning of workbooks and worksheets, including navigation and selection techniques, grouping, copying and moving worksheets, linking them, applying data validation to areas of spreadsheet to ensure consistent input and protection of sheets and workbooks
- A focus on formula and functions, covering absolute and relative referencing in formula, 3D link formula and functions, creating nested formula, working with text formula and working with logical formula including IF
- Creating and modifying tables, formats, sorting and filtering and an overview of PivotTables
- Graphical Data Analysis, how to apply conditional formatting to cells and apply style
Excel Advanced
- A detailed look at formula and functions, including auditing tools and analyse formula, array formula, using named ranges, further functions including nested functions, the lookup and reference functions, using date and time functions and linking spreadsheets to external data
- A focus on formatting, conditional formatting with formulas and how to use and create cell styles
- A detailed look at PivotTables, such as how to create and modify PivotTables, using slicers and timelines, working with formula in a PivotTable, PivotTable charts and introduction to PowerPivot
- As well as “what if” analysis, using goal seek, data tables and scenarios and further functionality, such as annotating and hiding data, excel options and customising the ribbon and how to create a simple recorded macro