Level 3 Diploma in MS Office Excel 2010 - CPD Certified

Course

Online

Save 90%

Special Emagister price

£ 27 £ 279 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Excel 2010 is the spreadsheet application in the Microsoft Office 2010 suite. It has become an essential component of every business. Microsoft Excel 2010 includes more specific statistical and additional functions.

This Level 3 Diploma in MS Office Excel 2010 course will help you to learn all the related skills, knowledge, and information about the Microsoft Excel 2010. Besides, you’ll be able to create forecast charts based on historical data and predict future trends. Throughout this course, you will encounter every single detail of this spreadsheet program.

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one.

On successful completion of this course, you have the potential to achieve an estimated salary of £17,100.

The sky really is the limit.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Office IT
  • Microsoft Excel
  • Spreadsheet
  • Ms Office
  • Microsoft excel training
  • MS Excel
  • Your First Worksheet
  • Building Formulas
  • Using Time Saving Tools

Teachers and trainers (1)

Alpha Academy

Alpha Academy

Instructor

Course programme

COURSE CURRICULUM

Microsoft Excel 2010 for Beginners

  • Module One – Getting Started
  • Module Two – Opening and Closing Excel
  • Module Three – Your First Worksheet
  • Module Four – Working with Excel Files
  • Module Five – Viewing Excel Data
  • Module Six – Printing Excel Data
  • Module Seven – Building Formulas
  • Module Eight – Using Excel Functions
  • Module Nine – Using Time Saving Tools
  • Module Ten – Formatting Your Data
  • Module Eleven – Advanced Formatting Tools
  • Module Twelve – Wrapping Up
  • Activities-Microsoft Excel 2010 for Beginners

Microsoft Excel 2010 Intermediate Level

  • Module One – Getting Started
  • Module Two – Working with Permissions and Options
  • Module Three – Sharing Workbooks
  • Module Four – Performing Advanced Formula and Function Tasks
  • Module Five – Working with Array Formulas
  • Module Six – Working with Functions
  • Module Seven – Working with Macros
  • Module Eight – Working with Forms
  • Module Nine – Applying Advanced Chart Features
  • Module Ten – Working with PivotTables and PivotCharts
  • Module Eleven – Using the Automated Analysis Tools Add -In
  • Module Twelve – Wrapping Up
  • Activities – Microsoft Excel 2010 Intermediate Training Diploma

Microsoft Excel 2010 Advanced Level

  • Module One – Getting Started
  • Module Two – SmartArt and Objects
  • Module Three – Auditing
  • Module Four – Creating Charts
  • Module Five – Creating Pivot Tables
  • Module Six – Working with PivotTables and PivotCharts
  • Module Seven – Macros
  • Module Eight – Solving Formula Errors
  • Module Nine – Using What If Analysis
  • Module Ten – Managing Your Data
  • Module Eleven – Grouping and Outlining Data
  • Module Twelve – Wrapping Up
  • Activities-Microsoft Excel 2010 Advanced Level
Mock Exam
  • Mock Exam- Level 3 Diploma in MS Office Excel 2010
Final Exam
  • Final Exam- Level 3 Diploma in MS Office Excel 2010

Assessment and Certification

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.

Level 3 Diploma in MS Office Excel 2010 - CPD Certified

Special Emagister price

£ 27 £ 279 VAT inc.