Microsoft Excel Intermediate
Intermediate Microsoft Excel 2010 Course
Instructor-led Excel 2010 Intermediate Training
Duration: |
Intended audience: |
1 day |
Regular Excel users who want to expand their knowledge through the use of Intermediate Excel Exercises |
Aims:
|
To expand on a basic understanding of Excel 2010 including the use of multiple sheets and workbooks, more advanced functions, working with lists and tables and adding charts |
Objectives: |
Delegates will gain Intermediate Excel Skills, and by the end of the session will:
|
Prerequisites: |
A working knowledge of Excel including the order of calculation and absolute references |
Refresher on Excel 2010 Basics
Calculations, BODMAS, absolute references
Working with Worksheets
Zooming
Freezing/unfreezing panes
Splitting and Removing Split panes
Hiding & Unhiding
Creating custom views
Working with multiple sheets
Adding/Removing sheets
Linking between sheets and books
Creating 3D formulas
Editing multiple sheets
Updating/Removing links
Date Functions
Understanding dates in Excel 2010
Formatting dates
=TODAY function
=NOW function
Naming Ranges
Creating and Defining Named Ranges
Using Named Ranges in Formulas
Logical Functions
=IF function
=AND function
=OR function
=SUMIF
=COUNTIF
Auditing
Formula Auditing Tools
Revealing Formulae
Tracing Precedents/Dependents
Working with Lists
Conditional formatting
Filtering options
Sorting and Sort Options
Custom Filters
Subtotalling
Tables
Introduction to Tables
Naming a table
Adding Totals
Filtering and Sorting
Structured References
Charts & Graphs
Creating Charts
Editing and Formatting charts
Creating custom chart
Moving a chart