preloader
0
  • LOGIN
  • No products in the basket.

Complete Microsoft Excel Course - Beginner to Advanced

Trust Pilot Micro Combo
Highly Rated BUY NOW PAY LATER

Get Extra 20% off for all courses! Use code: MONDAY at Checkout

Course Fee (Excl. VAT)

BUY NOW
  • £25.00 (Ex. VAT)
  • Self-Paced Online Learning
  • Course Duration: 7 Hours
  • High-Quality Study Materials
  • CPD Approved Member
  • Recommended by 96% of Students
  • Instant Access 24/7
  • 367 Students Enrolled

Instructors

649 STUDENTS ENROLLED
reviews image

APPROVED MEMBER

APPROVED MEMBER

14 Days Money Back Guarantee

Promise Guaranteed

new year career development bundle

Booking Options

Choose Your Exam Board

(Ex. VAT)

(Ex. VAT)

(Ex. VAT)

Recommended

(Ex. VAT)

(Ex. VAT)

(Ex. VAT)

(Ex. VAT)

(Ex. VAT)

Recommended

(Ex. VAT)

(Ex. VAT)

GET ACCESS TO OUR ENTIRE COURSE LIBRARY FOR ONLY £99.00 PER YEAR. LEARN MORE

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 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 is easy to follow.
  • Save money and time by studying at 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
  • Learn the most in-demand skills
  • 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

After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. This means that you/your employer can verify your certificate through our website. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.


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 new skills 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
Supplementary Resources
Supplementary Resources – Complete Microsoft Excel Course – Beginner to Advanced 01:00:00
Assessment
Assessment – Complete Microsoft Excel Course – Beginner to Advanced 00:10:00
Order Your Certificate Now
Order Your Certificate Now 00:00:00
Get Your Insurance Now
Get Your Insurance Now 00:00:00
Feedback
Feedback 00:00:00

REVIEWS


Course Fee (Excl. VAT)

  • £25.00 (Ex. VAT)
  • Self-Paced Online Learning
  • Course Duration: 7 Hours
  • High-Quality Study Materials
  • CPD Approved Member
  • Recommended by 96% of Students
  • Instant Access 24/7
  • 367 Students Enrolled

Instructors

649 STUDENTS ENROLLED
reviews image

APPROVED MEMBER

APPROVED MEMBER

14 Days Money Back Guarantee

Promise Guaranteed

new year career development bundle
  • £25.00 (Ex. VAT)
©Lead Academy 2022 | All Right Reserved
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £99.00 per year

    Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.
    Generic selectors
    Exact matches only
    Search in title
    Search in content
    Post Type Selectors