Microsoft Excel - Level 2
Upcoming Microsoft Excel Level 2 courses:
Microsoft Excel - Level 2
1 dayMicrosoft Excel - Level 2
1 dayMicrosoft Excel - Level 2
1 dayMicrosoft Excel - Level 2
1 dayMicrosoft Excel - Level 2
1 dayMicrosoft Excel Level 2
Course Aim
To introduce additional features of Excel and to develop 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.
Who Should Attend?
Users with a good working knowledge of Excel who want to develop their knowledge further. Can set a simple spreadsheet up from the start and should already be able to perform basic calculations using formulae and functions.
Prerequisites
Attended the Level 1 Excel course or been using Excel for quite some time.
Course Content
Revision from L1
- Properties of the screen
- Setting Excel options
- Customising the Quick Access Toolbar
- Setting up a spreadsheet
- Converting Excel spreadsheets to PDF
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
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