Microsoft Excel Level 2
Course
In St Helens
Description
-
Type
Course
-
Level
Intermediate
-
Location
St helens
-
Duration
Flexible
-
Start date
September
Microsoft Excel level 2 (Intermediate) - using more advanced formulae and functions, process and analyse data, present information, formatting, pivot tables, modification, themes, dynamic linking and updates, etc. - users looking to further develop skills and confidence.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- Microsoft Excel
- Microsoft excel training
- MS Excel
- Worksheets
- Calculate Data
- Chart
- Format Charts
- Excel Environment
- Customise Workbooks
Course programme
This is just a 'flavour' of the content - as we will tailor the course to meet your individual requirements.
- Create more advanced formulae including logic statements
- Use Specialized Functions
- Apply Cell and Range Names
- Data validation
- Sheet protection
- Calculate Data across Worksheets
- Analyse Data with Logical and Lookup Functions.
- Create basic macros
- Use form controls
- Sort or Filter Data
- Use Functions to Calculate Data
- Create a Chart, modify Charts, format Charts
- Create a PivotTable
- Customise the Excel Environment
- Customise Workbooks
- Manage Themes
- Create and Use Templates
Microsoft Excel Level 2