• LOGIN
  • No products in the basket.

Complete Microsoft Excel Course - Beginner to Advanced

5( 2 REVIEWS )
865 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

MS Excel 2019 New Features
Introduction to MS Excel 2019 New Features 00:06:00
Concat with Excel 2019 00:01:00
IFS with Excel 2019 00:01:00
Maxifs with Excel 2019 00:01:00
Minifs with Excel 2019 00:01:00
Switch with Excel 2019 00:02:00
Textjoin with Excel 2019 00:01:00
Map Chart with Excel 2019 00:01:00
Funnel Chart with Excel 2019 00:01:00
Better Visuals with Excel 2019 00:06:00
Pivot Table Enhancements with Excel 2019 00:01:00
Power Pivot Updates with Excel 2019 00:01:00
Microsoft Excel Beginners
Introducing with Microsoft Office Excel 2016
Navigate the Excel User Interface 00:28:00
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Performing Calculations
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
How To Modify a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
How To Format a Worksheet
Apply Text Formats 00:17:00
Apply Number Format 00:08:00
Align Cell Contents 00:09:00
Apply Styles and Themes 00:12:00
Apply Basic Conditional Formatting 00:11:00
Create and Use Templates 00:07:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:08:00
Configure Headers and Footers 00:07:00
How To Manage Workbooks
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:05:00
Supplementary Resources - Microsoft Excel 2016 for Beginners
Supplementary Resources – Microsoft Excel 2016 for Beginners 00:00:00
Microsoft Excel Intermediate
How To Work with Functions
Work with Ranges 00:18:00
Use Specialized Functions 00:11:00
Work with Logical Functions 00:23:00
Work with Date & Time Functions 00:08:00
Work with Text Functions 00:11:00
How To Work with Lists
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
How To Analyse Data
Create and Modify Tables 00:15:00
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
How To Visualise Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
How To Use PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Supplementary Resources - Microsoft Excel 2016 Intermediate
Supplementary Resources – Microsoft Excel 2016 Intermediate 00:00:00
Microsoft Excel Advanced
How To Work with Multiple Worksheets and Workbooks
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
How To Use Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
How To Share and Protect Workbooks
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
How To Automate Workbook Functionality
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
How To Create Sparklines and Mapping Data
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables 00:08:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:05:00
Supplementary Resources - Microsoft Excel 2016 Advanced
Supplementary Resources – Microsoft Excel 2016 Advanced 00:00: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

865 STUDENTS ENROLLED

14 Days Money Back Guarantee

© Lead Academy 2020 | All Right Reserved