Level 3 diploma in microsoft excel 2010
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Microsoft Excel 2010 is the spreadsheet application in the MS Office 2010 suite. You will begin with the fundamentals, assembling a strong foundation that will give you further knowledge as you advance into intermediate and advanced level topics. By the end of this course, you will have mastered the most important Excel 2010 tools and come out with confidence to finish any Excel assignments with proficiency and grace.
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- Excel
- Office IT
- Microsoft Excel
- Spreadsheet
- IT Auditing
- Ms Office
- Confidence Training
- Microsoft excel training
- Using excel
- MS Excel
Course programme
Course Curriculum
Microsoft Excel 2010 for Beginners
Module One – Getting Started
01:00:00
Module Two – Opening and Closing Excel
02:00:00
Module Three – Your First Worksheet
02:00:00
Module Four – Working with Excel Files
02:00:00
Module Five – Viewing Excel Data
02:00:00
Module Six – Printing Excel Data
02:00:00
Module Seven – Building Formulas
02:00:00
Module Eight – Using Excel Functions
02:00:00
Module Nine – Using Time Saving Tools
02:00:00
Module Ten – Formatting Your Data
02:00:00
Module Eleven – Advanced Formatting Tools
02:00:00
Module Twelve – Wrapping Up
01:00:00
Microsoft Excel 2010 Intermediate Level
Module One – Getting Started
01:00:00
Module Two – Working with Permissions and Options
02:00:00
Module Three – Sharing Workbooks
02:00:00
Module Four – Performing Advanced Formula and Function Tasks
02:00:00
Module Five – Working with Array Formulas
02:00:00
Module Six – Working with Functions
02:00:00
Module Seven – Working with Macros
02:00:00
Module Eight – Working with Forms
02:00:00
Module Nine – Applying Advanced Chart Features
02:00:00
Module Ten – Working with PivotTables and PivotCharts
02:00:00
Module Eleven – Using the Automated Analysis Tools Add -In
02:00:00
Module Twelve – Wrapping Up
01:00:00
Microsoft Excel 2010 Advanced Level
Module One – Getting Started
01:00:00
Module Two – SmartArt and Objects
02:00:00
Module Three – Auditing
02:00:00
Module Four – Creating Charts
02:00:00
Module Five – Creating Pivot Tables
02:00:00
Module Six – Working with PivotTables and PivotCharts
02:00:00
Module Seven – Macros
02:00:00
Module Eight – Solving Formula Errors
02:00:00
Module Nine – Using What If Analysis
02:00:00
Module Ten – Managing Your Data
02:00:00
Module Eleven – Grouping and Outlining Data
02:00:00
Module Twelve – Wrapping Up
01:00:00
Activities
Activities-Microsoft Excel 2010 for Beginners
00:00:00
Activities-Microsoft Excel 2010 Intermediate Level
00:00:00
Activities-Microsoft Excel 2010 Advanced Level
00:00:00
Mock Exam
Final Exam
Level 3 diploma in microsoft excel 2010