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.
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.
- 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.
Master Microsoft Excel Essentials is a useful qualification to possess and would be beneficial for any related profession or industry.
|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|
No Ratings found for this course.