WHAT IS THE AIM OF THE COURSE?
Excel Training - Level 1
You have basic computer skills such as using a mouse, navigating through windows and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to transfer that data to an electronic format. In this course, you will use Microsoft Office Excel to manage, edit, and print data.
Excel Training - Level 2
In level 1 of the Microsoft Office Excel certification course you created, edited, formatted and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Excel Training - Level 3
In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
WHO WILL BENEFIT?
Anyone using the Microsoft Office system to prepare spreadsheets or tables.
WHAT ARE THE TRAINING OPTIONS AVAILABLE?
- You can come to us for Instructor Led Training,
- You could even do it Part Time with MyChoice!
- We can come to you for Onsite Training
- Distance Learning with Online ANYTIME
- Day or evening training provided
EXAMINATIONS AND ASSESSMENTS
This interesting and informative Excel training course and certification is supported by a range of reinforcement tools, all aimed at assisting in remembering course material with ease, and helping learners integrate their new skills into their daily working lives.
Learners have the option of writing the International Microsoft examinations at New Horizons' Authorised Prometric Testing Centre. However, the costs for international exams are not included in the course fees.
LEARNING MATERIALS
All standard learning materials(like manuals) are included in the course fee!
WHAT DOES THE COURSE CONSIST OF?
MICROSOFT EXCEL 2010
Excel 2010 - Level 1
- Creating a Basic Excel Worksheet
- Performing Calculations in an Excel Worksheet
- Modifying an Excel Worksheet
- Formatting an Excel Worksheet
- Printing Excel Workbooks
- Managing an Excel Workbook
Excel 2010 - Level 2
- Calculating Data with Advanced Formulas
- Organizing Worksheet and Table Data
- Presenting Data Using Charts
- Analyzing Data Using PivotTables, Slicers, and PivotCharts
- Inserting Graphic Objects
- Customizing and Enhancing Workbooks and the Excel Environment
Excel 2010 Level 3
- Streamlining Workflow
- Collaborating with Others
- Auditing Worksheets
- Analysing Data
- Working with Multiple Workbooks
- Importing and Exporting Data
- Structuring XML Workbooks
MICROSOFT EXCEL 2007
Excel 2007 - Level 1
- Creating a Basic Worksheet
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbook Contents
- Managing Large Workbooks
Excel 2007 - Level 2
- Calculating Data with Advanced
Formulas
- Organizing Worksheet and Table
Data
- Presenting Data Using Charts
- Analyzing Data Using PivotTables
and PivotCharts
- Inserting Graphic Objects
- Customizing and Enhancing
Workbooks and the Excel Environment
Excel 2007 - Level 3
- Streamlining Workflow
- Collaborating with Others
- Auditing Worksheets
- Analyzing Data
- Working with Multiple Workbooks
- Importing and Exporting Data
- Using Excel with the Web
- Structuring XML Workbooks
Excel 2007 - Level 4
- Manipulating Data Using Statistical and Lookup Functions
- Analyzing Data Using Data Analysis Tools
- Working with Data Using Financial Functions
- Examining Data Using Math Functions
- Manipulating Data Using Text and Information Functions
- Working with Templates and Charts
- Managing Data in Workbooks
|
| Duration
Level 1
1 day
Level 2
1 day
Level 3
1 day
Prerequisites
|
Next recommended course:
or
|
What others have to say!
"Very informative - Excel is a great course to start off with. I like the neat classrooms & personal attention!"
René Leandro Borges |
Vendor :
Microsoft
|

|