• LOGIN
  • No products in the basket.

Course Overview

Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you’ve come to the right place!

Our easy-to-follow Master Microsoft Excel Essentials will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept – from the fundamental to the more advanced aspects of the course. 

Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future.  

Learning Outcomes

Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge.

Entry Requirement

    • This course is available to all learners of all academic backgrounds.
    • Learners should be aged 16 or over to undertake the qualification.
    • Some basic understanding of the English language and numeracy.

Why choose us?

    • Affordable, engaging & high-quality e-learning study materials;
    • Tutorial videos/materials from the industry-leading experts;
    • Study in a user-friendly, advanced online learning platform;
    • Efficient exam systems for the assessment and instant result;
    • The UK & internationally recognized accredited qualification;
    • Access to course content on mobile, tablet, or desktop from anywhere, anytime;
    • The benefit of career advancement opportunities;
    • 24/7 student support via email.

Will I receive a certificate of completion?

After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19.

    • PDF certificate’s turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.  

Career path

Master Microsoft Excel Essentials is a useful qualification to possess and would be beneficial for any related profession or industry.   

Master Microsoft Excel Essentials
$415.94 $24.85 ex Vat TAKE THIS COURSE

Course Curriculum

Section 01: Getting Started with Microsoft Excel
How to Use the Menu System 00:03:00
How to Use the Quick Access Tool bar 00:03:00
Understanding Workbooks And Worksheets 00:02:00
How to Use the Formula Bar 00:02:00
How to Use the Status Bar 00:02:00
How to Use the Navigation Tools 00:02:00
How to Use the Short Cut Menus & the Mini Toolbar 00:02:00
How to Create New Workbook 00:02:00
How to use the Excel help 00:02:00
Section 02: Manipulating Data Entry in Excel
Exploring Data Entry and Editing Methods 00:03:00
AutoFill Data Entry Methods 00:02:00
How To Use Undo And Redo 00:02:00
How to Add Comments 00:02:00
Using the Save and Save us Command 00:02:00
Section 03: Understanding and Using Formulas & Functions
How to Create Simple Functions 00:03:00
How To Copy A Formula In To Adjacent Cells 00:02:00
How To Create Year To Date Totals 00:02:00
How To Create A Percentage Change Formula 00:02:00
Understanding Absolute and Relative Reference 00:03:00
How To Use SUM And AVERAGE Function 00:02:00
How To Use Other Excel Functions 00:03:00
Section 04: Understanding and Using Formatting Methods
How To Style And Effect Fonts 00:02:00
How To Adjust Column Width And Row Hights 00:02:00
How To Use The Alignment And Wrap Text 00:03:00
How To Design and Use Borders 00:02:00
How To Use Special Formatting Methods 00:03:00
How To Format Dates And Numbers 00:03:00
How To Use Conditional Formatting 00:03:00
How To Create And Use Tables 00:03:00
How To Insert Shapes And Others Visual Elements 00:05:00
Section 05: Exploring Worksheet Layout and Data
How to Insert and Delete Columns and Rows 00:03:00
How To Hide and Unhide Rows And Columns 00:03:00
How to Move, Copy and Insert Data 00:03:00
How to Find and Replace Data 00:03:00
Section 06: Page Setup and Printing
Exploring Page Layout Methods 00:03:00
How to Preview Page Breaks 00:03:00
Page Setup and Printing Controls 00:03:00
Section 07: Understanding and Using Excel Charts
How to Create Charts 00:04:00
Exploring Chart Types 00:04:00
How to Format Chart 00:03:00
Axes, Titles and Other Chart Elements 00:03:00
Exploring New 2016 Charts 00:05:00
Section 08: Exploring Worksheet Views
Freezing and Unfreezing Pans 00:02:00
How to Split Screen Horizontally and Vertically 00:02:00
How to Collapse and Expand Data Views 00:02:00
Section 09: Exploring Workbooks and Multiple Worksheets
How to Display Workbooks and Multiple Worksheets 00:03:00
How to Rename, Insert And Delete Worksheet 00:02:00
How to Move, Copy and Group Worksheet 00:03:00
Linking Worksheets and Workbooks by Formulas 00:04:00
How to Locate and Maintain Links 00:02:00
Section 10: Vlookup, CountIF and IF Functions
How to Use IF Functions and Relational Operators 00:05:00
Using The Vlookup Function for Approximate Match type 00:03:00
Using The Vlookup Function for Exact Match type 00:03:00
How to Use CountIF, SumIF and AverageIF Functions 00:04:00
Section 11: Working with Security and File Sharing
How to Protect Worksheets 00:02:00
How to Protect Workbooks 00:02:00
How to Assign Passwords Workbooks 00:01:00
Section 12: Essential Data Management Tools
How to sort Data in Excel 00:03:00
How to Insert Subtotals in A Sorted Data 00:03:00
How to Use Filters 00:03:00
How to Split Data in to Multiple Columns 00:02:00
How Use Flashfill for Splitting and Combining Data 00:03:00
How to Remove Duplicate Data 00:01:00
Using Validation Tools to The Best 00:04:00
Section 13: Essential Data Analysis Tools
How to Use Goal Seek 00:04:00
How To Use Solver 00:04:00
How to Use Scenario Manager 00:05:00
How to Use Data Tables 00:04:00
Section 14: Pivot Tables and Pivot Charts
How to Create PivotTables 00:03:00
Manipulating PivotTable Data 00:03:00
Date and Time Grouping 00:03:00
Extended Grouping Analysis 00:02:00
How to Use Slicers 00:03:00
How to Use Pivot Charts 00:03:00

Course Reviews

N.A

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

No Reviews found for this course.

© Alpha Academy is a part of Adams Academy Inc. Ltd.