• LOGIN
  • No products in the cart.

You must be logged in to take this course  →   LOGIN | REGISTER NOW

The [course_title] covers the advanced tools in Excel. You’ll learn how to create custom cell formats. You’ll start to learn about Pivot Tables, the slicer tool, Macros and how to record steps to common tasks. You’ll learn how to trace and watch changes with cells and formulae. This course introduces the power of Pivot Tables and Recording Macros. Pivot tables let us report and manipulate huge amounts of data quickly and easily. Learning the foundations of Macros can save you huge amounts of time by automating repetitive tasks.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

 

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Edukite

 

Course Curriculum

Microsoft Excel 2010 Advanced Level
Module One – Getting Started 00:30:00
Module Two – SmartArt and Objects 01:00:00
Module Three – Auditing 01:00:00
Module Four – Creating Charts 01:00:00
Module Five – Creating Pivot Tables 01:00:00
Module Six – Working with PivotTables and PivotCharts 01:00:00
Module Seven – Macros 01:00:00
Module Eight – Solving Formula Errors 01:00:00
Module Nine – Using What If Analysis 01:00:00
Module Ten – Managing Your Data 00:30:00
Module Eleven – Grouping and Outlining Data 00:30:00
Module Twelve – Wrapping Up 00:30:00
Activities
Activities-Microsoft Excel 2010 Advanced Level 00:00:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.8

4.8
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

487 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841