• LOGIN
  • No products in the basket.

Complete Microsoft Excel Course - Beginner to Advanced

5( 2 REVIEWS )
950 STUDENTS

Overview

Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Complete Microsoft Excel Course – Beginner to Advanced course will set you up with a solid foundation to become a confident office admin and develop more advanced skills.

This comprehensive course is the perfect way to kickstart your career in the field of Microsoft Excel. This accredited course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.

As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience.


How Will I Benefit?

  • Boost your career in Microsoft Excel
  • Deepen your knowledge and skills in your chosen field just in hours not years!
  • Study a course that has been designed by industry professionals.
  • Save money and time by studying your convenient time
  • Have access to a tutor whenever you are in need

So, what are you thinking about! Start getting the benefits by enrolling today!


Why Choose Lead Academy:

  • Lifetime Access
  • High-quality e-learning study materials
  • The UK and globally recognised qualification
  • Self-paced, no fixed schedules
  • 24/7 customer support through email
  • Available to students anywhere in the world
  • No hidden fee
  • Study in a user-friendly, advanced online learning platform

Who is this course for?

This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Excel.


Entry Requirement

  • There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. 
  • As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.

Certification

On successful completion of the course, you will be eligible to obtain a verifiable certification as proof of your new qualification. This means that you/your employer can verify your qualification through our website. Certificate can be obtained in PDF version at a cost of £10, and there is an additional fee to obtain a printed copy certificate which is £24.


Career path

This course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV, enhance your career and become more competitive in your chosen industry.

 

Course Curriculum

Introduction
Introduction 00:02:00
Excel Basics
Basics 00:08:00
Worksheet Basics 00:16:00
Entering values and Formulas 00:07:00
Data Formats 00:08:00
Data Handling Basics – Cut, Copy and Paste 00:14:00
Saving and Printing – Basics 00:09:00
Essential Formulas
Basic Formula Operations 00:13:00
Mathematical Functions 00:19:00
Textual Functions 00:17:00
Logical Functions 00:11:00
Date-Time Functions 00:07:00
Lookup Functions ( V Lookup, Hlookup, Index-Match ) 00:08:00
Data Tools
Data Tools 00:19:00
Formatting Data and Tabels
Formatting Data and Tables 00:18:00
Pivot Tables
Pivot Tables 00:08:00
Excel Charts
Excel Charts – Categories of messages that can be conveyed 00:04:00
Elements of charts 00:05:00
The Easy way of creating charts 00:03:00
Bar and column charts 00:12:00
Formating charts 00:15:00
Line Charts 00:09:00
Area Charts 00:06:00
Pie and Doughnut Charts 00:01:00
Why we should avoid Pie charts 00:04:00
Scatter plot or XY chart 00:16:00
Frequency Distribution and Histograms 00:13:00
Waterfall Charts 00:12:00
Sparklines 00:05:00
Pivot Charts
Pivot Charts 00:07:00
Named Ranges
Named Ranges 00:10:00
Indirect Function 00:05:00
Excel Shortcuts
Shortcuts 00:12:00
Macros
Macros 00:10:00
Advanced Excel
Advanced Excel: Analytics in Excel 00:15:00
Order Your Certificate Now
Order Your Certificate Now 00:00:00

Course Reviews

5

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

No Reviews found for this course.

Complete Microsoft Excel Course - Beginner to Advanced
TAKE THIS COURSE

Instructors

950 STUDENTS ENROLLED

14 Days Money Back Guarantee

©Lead Academy 2020 | All Right Reserved
Select your currency
GBPPound sterling
EUR Euro