|
Excel Intermediate Course - Level 2 Excel Course
Our Excel intermediate course will build on your basic Excel skills and show you more complex formalae, how to build formalae accross worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.
After the course, you will be able to:
- Use Logical Functions, Financial and Statistical Functions
- Nest Functions
- Multiple Worksheet Management and Formulae
- Build Charts
- Protect Worksheets & Workbooks
Audience - To get the most from this course, you must be at a basic Excel level, equivelant of our introduction course content
Course Duration - This is a 1 day Excel intermediate course
Course Dates - This course can run on any date you request
Course Versions - All versions from 97 to 2007
|
|
|
 Excel Intermediate Course Content
Range Names
- Learn how to create, edit and use range names on your spreadsheets to enhance and clarify formulae writing and navigation
Formulae
- Logical Functions - If, And, Or, Not
- List Functions - Sumif, Countif
- Conditional formatting
- Date & Time Functions - Today, Now, Day, Month, Year
- Full Formulae Auditing
Worksheet Management & Linking
- Linking Data - Between sheets and workbooks, Managing Links
- Managing Windows - Splits, Freeze Panes, Arranging and Workspaces
- Data Consolidation
Advanced List Filters
- Review of AutoFilter
- Using Advanced Filters
Excel Charts
- Learn how to create and edit various chart types in Excel
- Managing and Editing Charts
Worksheet Protection and Reviewing
- Using Data Validation options and Comments
- Worksheet Protection -entire and partial sheets
- Workbook Protection
- File Protection
|
|
|
More Excel Courses
Training Formats and Locations
- Onsite Training - We come to you
- Our London city based training center
- One to One - Dedicated to your needs
- Classroom - for groups up to 8
- All our courses are instructor led, and closed to you.
read more
Course Cost
- This course is charged at £595 per group of 8 per day
- One to One is charged at £450 per day
- All prices exxclude VAT
- No travel cost except outside M25
Why choose us?
- Experienced trainers
- Best rates for groups and One to One courses
- Most flexible cancellation terms
- Easy payment terms
- Simple pricing structure
- After course support by your trainer
- Free Training Needs Analysis
read more |
