Level 4: Microsoft Excel
-
Heather's way to deal with educating was ideal for my style of learning. Without saying I was uncertain, Heather could perceive this without talking with me. I learnt an extraordinary arrangement from this course and would prescribe to all. Heather was an extraordinary teacher.
← | →
-
At the end of the day, Heather's energy shone through. She generally has the response to any inquiries straight away. Learnt some extremely helpful tips and in addition an exceptionally welcome recap of the Introduction course. I feel a great deal more certain about applying calculations/formulae/functions to a spreadsheet.
← | →
Course
In Royal Leamington Spa
Expand your knowledge in Microsoft Excel!
-
Type
Course
-
Location
Royal leamington spa
-
Duration
2 Days
-
Start date
Different dates available
The course will provide the delegates with the opportunity to explore the more specialised and advanced features and facilities of Excel.
It will show how repetitive tasks can be automated and, using pivot tables, show how data can be further summarised and analysed.
Facilities
Location
Start date
Start date
About this course
Everyday users with an extremely good working knowledge of Excel who want to develop their knowledge further. Should be competent
at creating formulae and functions covered in the previous levels of training.
Attended the Level 3 Excel course or been using Excel for a long period of time.
Reviews
-
Heather's way to deal with educating was ideal for my style of learning. Without saying I was uncertain, Heather could perceive this without talking with me. I learnt an extraordinary arrangement from this course and would prescribe to all. Heather was an extraordinary teacher.
← | →
-
At the end of the day, Heather's energy shone through. She generally has the response to any inquiries straight away. Learnt some extremely helpful tips and in addition an exceptionally welcome recap of the Introduction course. I feel a great deal more certain about applying calculations/formulae/functions to a spreadsheet.
← | →
Course rating
Recommended
Centre rating
N.
Brize Norton
Subjects
- Microsoft Project
- Excel
- Word
- Powerpoint
- Microsoft Excel
- Spreadsheet
- Microsoft Word
- Microsoft Powerpoint
- Computer Engineering
- IT Security
- Microsoft excel training
- MS Excel
- IT Systems
- Computer Science
- Office systems
- IT
- Computering
- Microsoft
- Mirosoft Access
Course programme
Customising the Ribbon
• Creating new custom tabs and groups
• Renaming a tab, group or command button
• Adding a command button to a custom group
• Changing the symbol for a command button
• Removing a tab, group or command button
Formulae and Functions
• Text functions
• Date and time functions
Auditing Tools
• Displaying more than one formula at the same time
• Identifying the structure of calculations
• Tracing precedents and dependents
• Removing tracing arrows
Data Management
• Advanced filtering and filtering using slicers
• Performing database statistical functions
• SUMIF and COUNTIF functions
• COUNT and COUNTA functions
Analysing and consolidating information
• Using the data consolidation feature
• Consolidating data by position
• Consolidating data by category
Subtotalling Data
• Setting up outlines for rows and columns
• Creating subtotals
• Subtotal outlines
• Displaying or hiding outline symbols
• Creating nested subtotals
• Creating multiple summary functions
• SUBTOTAL function
Working with Data
• Pick from list
• Data Validation
Conditional Formatting
• Setting up simple conditional formatting
• Using predefined conditional formatting
• Conditional formatting based on the cell content
• Conditional formatting using a calculation
• Deleting conditional formatting
Charting Worksheet Data
• Revising creating, formatting and modifying charts
• Adding additional data to a chart
• Creating combination charts
• Incorporating a secondary axis
• Adding trendlines to a chart
• Marking high and low points on a chart
• Creating sparklines
Analysing and Consolidating Data using Pivot Tables
• Creating and working with pivot tables
• Naming a pivot table database
• Adding, moving and deleting fields
• Refreshing a pivot table
• Displaying sub and grand totals
• Showing pivot tables in compact, outline or tabular format
• Grouping date fields to show other time intervals
• Changing number formats
• Using functions in a pivot table
• Showing data as a percentage of other data
• Filtering data with a slicer
• Pivot table options
• GETPIVOTDATA function
Macros
• Macro security
• Enabling macros
• Using macros to automate repetitive tasks
• Recording and running a macro
• Assigning a macro to the toolbar, menu or keyboard
• Deleting macros
Level 4: Microsoft Excel