Level 2: Microsoft Excel
-
I enjoyed learning shortcuts for everyday use to make it quick to use Excel. Course was very enjoyable and well structured. Heather is an excellent trainer and knows her stuff!
← | →
Short course
In Royal Leamington Spa
Gain an in depth knowledge of Microsoft Excel!
-
Type
Short course
-
Methodology
Inhouse
-
Location
Royal leamington spa
-
Duration
1 Day
-
Start date
Different dates available
To introduce additional features of Excel and to develop the topics covered in the previous course. The course will encourage user
confidence and will provide delegates with a comprehensive understanding of the commands and functions available in Excel at this level, enabling them to further manage spreadsheets, graphs and databases by the end of the course.
Facilities
Location
Start date
Start date
About this course
Users with a good working knowledge of Excel who want to develop their knowledge further. Should already be able to create a
simple spreadsheet from the beginning and should be able to perform basic calculations using formulae and functions.
Attended the Level 1 Excel course or been using Excel for quite some time.
Reviews
-
I enjoyed learning shortcuts for everyday use to make it quick to use Excel. Course was very enjoyable and well structured. Heather is an excellent trainer and knows her stuff!
← | →
Course rating
Recommended
Centre rating
Lilly
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
Multiple Worksheets• Switching between worksheets• Renaming worksheets• Inserting and deleting worksheets• Moving and copying worksheets• Grouping and ungrouping worksheets• Copying worksheets to other workbooks
Working with Formulae and Functions• Understanding the structure of calculations• Formula and function revision• Revising BODMAS• Keeping calculations updated• Performing calculations across worksheets• Relative and absolute cell referencing• IF function
Data Management - Sorting• Guidelines for creating a database• Setting up a database• Sorting records by text, numbers and dates• Sorting by more than one field• Sorting records using a customised list
Data Management – Filtering• Turning the filter on and off• Filtering records using the filter• Setting multiple filters• And and Or criteria• Copying filtered data• Clearing all filters
Charting Worksheet Data• Plotting worksheet data• Plotting non-adjacent ranges• Creating a chart• Moving and resizing an embedded chart• Printing charts• Changing the chart type, layout and style• Formatting the elements of a chart• Adding, removing and formatting data labels• Changing the font and size of text labels• Showing a data table• Changing the axis scale• Formatting numbers on the axis• Displaying and hiding gridlines• Positioning the legend• Formatting the plot area• Printing charts
Level 2: Microsoft Excel