We offer a wide range of high-quality and affordable training and events to help you develop and succeed at Carrowbreck House - our spacious and comfortable training centre in Hellesdon.
We can also ...
Advanced Excel
Practical details
Training for organisations • One-off
Contact person
Matt Beckett
#126318
Scan me or visit www.getinvolvedskills.org.uk/o/Carrowbreck-Courses/Trainings/Advanced-Excel/126318 to join
This course develops many of the most useful aspects of Excel such as formulas and functions, list management, and more advanced features including Pivot Tables
and summarising data across multiple sheets or books.
Trainees will have completed the introduction course or have a similar knowledge and experience of using Excel in the workplace.
Review
Brief review of general Excel principles:
Formulas, Functions, Absolutes, Formatting, AutoFill
Functions
Using Paste Function
The IF Function
Nested IF Functions
The VLOOKUP Function
Nesting other Functions
Linking Multiple Sheets and Workbooks
Summarising data from multiple sheets
Working with 3D Formulae
Linking workbooks
Workspaces
List Management (Databases)
Sorting
Subtotals
Filtering
Good Working Practice
Pivot Tables
Creating pivot tables with the Pivot Table Wizard
Formatting pivot tables
Manipulating pivot tables
Graphs/Charts
Creating a graph/chart
Formatting a graph/chart
Changing and editing your graph/chart
Using the Chart Wizard
Incorporating a chart into a Spreadsheet
Macros
Recording a simple macro
Assigning a macro to toolbar buttons
An explanation of different versions
Related to
About Carrowbreck Courses
We offer a wide range of high-quality and affordable training and events to help you develop and succeed at Carrowbreck House - our spacious and comfortable training centre in Hellesdon.
We can also look to offer bespoke training for your business either on-site, at Carrowbreck House or virtually to meet your needs on our whole range of available courses.
Room hire is also available on an hourly, half-day, full-day or multiple-day basis for meetings or training courses.
Applications closing in 5 days.