Microsoft Excel 2010 Intermediate Training course contents
Audience: This Excel intermediate course will build on your basic Excel skills and show you more complex formulae, how to build formulae across worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.
Course Duration
This is a 1 day Excel 2010 Intermediate Course. Course starts at 09:30 and runs until 16:30
Excel 2010 Intermediate Course Objectives: After the course, you will be able to:
- Use Logical Functions, Financial and Statistical Functions
- Nest Functions
- Multiple Worksheet Management and Formulae
- Create Charts
- Protect Worksheets & Workbooks
Course Prerequisite: To get the most from this course, you must be able to perform basic Excel actions and create formulae and functions.
Course Duration
This is a 1 day Excel 2010 Intermediate Course. Course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This course can be run at our London Excel 2010 training centre or any preferred location in the UK. The course can be held on a date that suits you. We do not run public scheduled courses.
Recapping Basics
- Absolute, Relative References Basic calculations
Recap Linking
- Inserting and deleting sheets
- Changing the default number of workbook sheets
Naming Cell Ranges
- Concept And Purpose
- Naming Individual Cells
- Naming Range Of Cells
- Deleting And Amending Named Ranges
- Using Name Ranges in Formulae/Functions
- Named Ranges As Navigation Aid
Linking Sheets and Files
- Changing the default number of workbook sheets
- 3D Calculations
- Linking sheets in the same file
- Linking different Excel files
- Using Edit, Links
- Viewing Different Files On One Screen
- Saving a workspace
- Window Split
- Freeze Panes
- Viewing Different Parts Of The Sheet On One Screen
- Watch Window
Conditional Functions
- Benefits And Purpose
- IF Statements
- Nested If
- SUMIF And SUMIFS
- AVERAGEIF And AVERAGEIFS
- COUNTIF and COUNTIFS
- ISERROR And IFERROR
- Nesting IF WITH AND, OR
Applying and Managing Conditional Formatting
- Data Bars
- Colour Scales
- Icon Sets
- Top/Bottom
Basic Lookup Functions
- Vertical Lookup (Vlookup)
- Horizontal Lookup (Hlookup)
Essential List Management
- Sorting Data (By Values, By Cell Colour, By Font Colour, By Cell Icons)
- Multi Column Sort
- Filter (By Values, By Cell Colour, By Font Colour, By Cell Icons)
- Multi Column Filter
- Advanced Filter
- Adding Subtotals
- Freeze Panes
- Group and Outline
- Data Form
- Format As Table Feature
- Data Consolidation
Formulae Auditing Formula View
- Tracing Precedents
- Tracing Dependents
- Using Watch Window
- Go To Special…
Charts/Graphs Advanced Techniques
- Creating Chart Using Shortcut Keys
- Saving Custom Chart as Templates
- Setting Chart as Default
- Applying Trendlines
- Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc...
- Using Sparklines (Line, Column, Win/Loss)
Our Excel 2010 Intermediate course will build on your current Excel skills. The course will focus more on Excel Functions, Worksheet Management, Working with Lists and Charting your data. Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.
This is one of our most popular Excel 2010 courses, as most users of Excel never need to use more complex functions or advanced data manipulation. The Excel 2010 intermediate course covers most uses of Excel, including functions, list management (Filters, Sorting etc), working across multiple sheets and charting your data.
If you are not quite sure if this is the correct level of course for you, please contact us. As part of our standard service offering, we do a free Training Needs Analysis and can also create a tailored or bespoke Excel 2010 intermediate course that could cover more of the basics or advanced topics as required.
Mouse Training is run by trainers, so our primary objective is to provide you with the tools you need, not others. We can also run your Excel 2010 intermediate course onsite and provide all the training equipment too!
Course Locations / Schedule
This course can be run Onsite, at our London Excel 2010 training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
**All the Excel 2010 intermediate course content above can be tailored by adding more basic or advanced functionality**
Course Locations / Schedule: This course can be run Onsite, at our Excel training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Our Excel 2010 Introduction course is designed for new users of Excel 2010, or those whom have been self taught. The course will cover all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing.
Our Excel 2010 Introduction or Basic course is run by qualified MOS trainers. We can also run your Excel 2010 basic course onsite, or at our London based training centre.
If you are not sure that the Excel 2010 introduction course is the right level for you, please contact us. As part of our service, we offer free Excel 2010 training needs analysis. This will help you get the most of your investment to ensure you get trained on area's of Excel 2010 that is most suited to your needs.
If you are upgrading from a previous version of Excel and only require upgrade training, please see our Excel 2010 Upgrade Training Course
We also offer a free course tailoring service. If you need to know specific functionality of Excel, please let us know. We will be more than happy to create a tailored or bespoke Excel 2010 introduction course for you.
**All our Excel 2010 training courses can be tailored to suit your needs**
Excel 2010 Courses
