Microsoft Excel 2007 Intermediate Training Course in London and the UK
Our Excel 2007 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 2007 courses, as most users of Excel never need to use more complex functions or advanced data manipulation. The Excel 2007 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 2007 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 2007 intermediate course onsite and provide all the training equipment too!
Excel 2007 Intermediate Training Course Info
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 2007 Intermediate Course. Course starts at 09:30 and runs until 16:30
Excel 2007 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
Requirements: 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 2007 Intermediate Course. Course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This course can be run Onsite, at our London Excel 2007 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.
Excel 2007 Intermediate Training Course Contents
Range Names
- Concept and Purpose
- Naming individual or range cells's
- Deleting and amending named ranges
- Using named cells/ranges in formulae
Conditional Functions & Formats and Date Calculations
- Benefits and purpose
- If Statements , Nested If
- And, Or, Not
- Combining If, And, Or, Not
- Sumif , Countif
- Conditional Formatting
- Entering Dates and Times
- Different date/time formats
- How dates are stored
- Calculating working days
- Using the DAY(),MONTH(),YEAR() functions
- Time calculations
Formulae Auditing
- Formula Auditing Tools
- Revealing Formulae
- Tracing Precedents/Dependents
- Goto Special
Worksheet Management & Linking
- Linking sheets in the same file
- Linking different Excel files
- Using Edit, Links
- Viewing different files at once
- Saving a workspace
- Viewing different sheets at once
- Window Split
- Data consolidation
Basic List Management
- Sorting Data
- Adding Subtotals
- AutoFilter
- Freeze Panes
- Group and Outline
- Data Form
Excel Charts / Graphs
- Using the Chart Wizard
- Editing and Formatting charts
- Saving custom chart types
- Setting a default chart type
**All the Excel 2007 intermediate course content above can be tailored by adding more basic or advanced functionality**
Excel 2007 Courses
