The Complete Microsoft Excel Course (E-learning)
What is the Complete Microsoft Excel Course? This Complete Microsoft Excel course will provide learners with a core understanding of how to effectively operate and use the Excel sp readsheet software from beginner to an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel course is perfect. Who is the Complete Microsoft Excel Course Suitable For This online Complete Microsoft Excel course is suitable for anyone looking to develop their Microsoft Excel skills. The course is also suitable for anyone who manages their Microsoft Excel training, this MS training can be used for on-boarding new staff, or as part of a team training plan. What's Included in the Complete Microsoft Excel Course? Awarding Body MTA Course Duration 52 Hours This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session. Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period. 12 Months Unlimited Access Each student will have 12 months unlimited access to allow you to have access to the training anytime 24/7. Course Content In the Beginners course: The MS Excel beginner’s course will give you a full overview of all of the most common features of Excel and how to use them. Here are some of the highlights of the beginner’s course: Creating workbooks Entering text, numbers and working with dates Navigating workbooks Page setup and print options Working with rows, columns and cells Cut, Copy and Paste Introduction to functions and formulas Formatting in Excel, including formatting cells and numbers Creating charts and graphs Sorting and Filtering Introduction to PivotTables Logical and lookup formulas - the basics Exercises included, so you can practice what you learnt. In the Intermediate and Advanced courses: The MS Excel Intermediate and Advanced Courses will take what you learnt in the beginners course and expand upon it. Additionally, these courses will teach you more advanced concepts than those that were presented in the beginner’s course. Here are some of the highlights of the intermediate and advanced courses: The next step after completing Microsoft Excel for Beginners Learn how to import and export data to and from Excel Learn how to create various charts and graphs Effectively create and use functions and formulas Import and export data Create and effectively use Pivot Tables How to use Excel for data analysis Discover practical methods for financial & statistical functions Exercises included, so you can practice what you learnt. What courses are included? We have combined our Microsoft Excel Beginners, Intermediate and Advanced Courses to make the most in-depth Complete Excel Course on the market. Microsoft Excel 2016 - Beginners Course Microsoft Excel 2016 - Intermediate Course Microsoft Excel 2016 - Advanced Course Microsoft Excel 2019 - Beginners Course Microsoft Excel 2019 - Advanced Course These courses are based on the Microsoft 2016 and 2019 excel softwares and are taught by a Microsoft Office Specialist (MOS) instructor . In order to work along with the instructor, it is recommended that learners should have their own copy of Microsoft Excel 2016 or 2019. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2016 and 2019. Duration of each course: Microsoft Excel 2016 - Beginners Course - Course Duration: 9.5 hr Microsoft Excel 2016 - Intermediate Course - Course Duration: 4.5 hrs Microsoft Excel 2016 - Advanced Course - Course Duration: 9 hrs Microsoft Excel 2019 - Beginners Course - Course Duration: 7 hrs Microsoft Excel 2019 - Advanced Course - Course Duration: 9 hrs The Microsoft Excel 2016 - Beginners course is organised into the following modules: Chapter 1: Introduction Acquiring Excel 2016 Information on Installation and Upgrade Exercise Files Chapter 2: What's New New and Improved Features in Excel 2016 Chapter 3: Using Touch Overview of Principles of Using Touchscreen Chapter 4: Getting Started Creating and Saving a Workbook Opening a Workbook Chapter 5: Using Help Online Help and Contextual Help Chapter 6: Excel Options Personalizing your use of Excel Chapter 7: The Ribbon and Toolbars Basics of using the Ribbon Quick Access Toolbar Tell Me Feature Mini Toolbars and Contextual Menus Status Bar Chapter 8: Entering and Editing Data Basics of Entering and Editing Data in a Workbook Exercise 01 Formatting Dates Formatting Numbers Exercise 02 Chapter 9: Backup and Recovery AutoSave, Recover Unsaved Workbook, and Create a Backup Copy Chapter 10: Fill and Series Working with Fill and Series Flash Fill Chapter 11: Viewing and Printing Workbook Views, Zoom, and Freeze Printing Exercise 03 Chapter 12: Cut, Copy, and Paste Methods of Cutting, Copying, and Pasting Chapter 13: Formatting a Worksheet Delete and Clear Insert, Hide, Column Width and Row Height, and Merge Alignment Themes and Styles Exercise 04 Chapter 14: Formulas and Functions Basics of Formulas and Functions Complex Examples of Formulas Exercise 05 Chapter 15: Managing Worksheets Rename, Insert, Move, and Reference a Worksheet Chapter 16: Working with Multiple Workbooks Working with Multiple Workbooks Chapter 17: Saving Workbooks Saving in Different File Types Chapter 18: Proofing The Spell Checker Chapter 19: Inserting Comments Inserting Comments Exercise 06 Chapter 20: Basic Functions in Excel The VLOOKUP Function Text Functions Date and Time Functions Logical Functions Chapter 21: Graphs and Charts Creating Graphs and Charts Customizing a Cluster Column Chart Customizing a Pie Chart New Chart Types in Excel 2016 Exercise 7 Chapter 22: Sorting and Filtering Data Managing Data by Sorting Managing Date by Filtering Customizing Tables Chapter 23: Shapes and Pictures Inserting Shapes and Pictures Exercise 08 Chapter 24: Formatting Cells Based on Content Conditional Formatting Chapter 25: Protection and Security Protecting Worksheets Protecting Workbooks Chapter 26: Naming Items Giving Items Names Exercise 09 Chapter 27: Finding and Replacing Words Find and Replace Chapter 28: Borders Adding Borders Chapter 29: Workbook Inspection Inspecting a Workbook Chapter 30: Privacy Options Trust Center Privacy Options Chapter 31: Sharing Options Sharing a Workbook Chapter 32: Conclusion Conclusion and Close Microsoft Excel 2016 - Advanced The course is arranged in the following modules: Chapter 1: Introduction to Excel 2016 Advanced Course Prerequisites of the Course and Version of Excel Course Structure Chapter 2: Functions Functions - Part 1 Functions - Part 2 Autosum Chapter 3: Date and Time Functions How Date and Time Works Basic Date and Time Functions Complex Date and Time Functions Chapter 4: Text Functions Using Text Functions - Part 1 Using Text Functions - Part 2 Chapter 5: Logical Functions Using Logical Functions Exercise 01 Chapter 6: Lookup Functions HLOOKUP Function VLOOKUP Function Exercise 02 Chapter 7: Financial Functions Financial Functions and Terminology Personal Financial Functions Professional Financial Functions Depreciation Exercise 03 Chapter 8: Statistical Functions Statistical Functions for Description - Part 1 Statistical Functions for Description - Part 2 Statistical Functions for Forecasting - Part 1 Statistical Functions for Forecasting - Part 2 Exercise 04 One Click Forecasting Statistical Functions for Inference Chapter 9: Connecting to External Data Connecting to Other Workbooks Connecting to Access Databases Connecting to Web Data Sources Get and Transform Exercise 05 Chapter 10: Tables Introduction to Tables Working with Tables Table References Table Styles Exercise 06 Chapter 11: Pivot Tables Introduction to Pivot Tables Working with Pivot Tables Filters and Slicers Pivot Charts Exercise 07 Chapter 12: Data Analysis What If Analysis Scenario Manager Goal Seek Solver Exercise 08 Chapter 13: Graphs and Charts Area Charts Surface Charts Radar Charts Bubble Charts Sparklines Stock Charts Exercise 09 Chapter 14: Excel Web App Introduction to Excel Web App Using the Excel Web App Chapter 15: Course Conclusion Closing Message The Microsoft Excel 2019 - Beginners course is organised into the following modules: 1: Introduction to Excel Intro to Excel What's New In Excel 2019? Course Overview Overview of the Excel Window Mouse Features Back Stage View Creating Workbooks Entering Text and Numbers Creating Basic Formulas Relative References Order of Operations Working with Ranges Module 2 - Practice Exercise Saving Workbooks Working with the Save and Save As Commands File Extensions, Share, Export, and Publish Files Module 3 - Practice Exercise Navigating Workbooks Opening a File Working with Larger Files Freeze Panes Option Split Screen Option Module 4 - Practice Exercise Page Setup and Print Options Headers and Footers Print Titles Comments Page Setup Options Fit to Print on One Page Printing Workbooks Module 5 - Practice Exercise Working with Rows, Columns, and Cells Adding and deleting rows columns and cells Changing Column and Row Widths Module 6 - Practice Exercise Moving Data Cut, Copy, and Paste Copying Formulas Module 7 - Practice Exercise Formulas and Functions Overview of Formulas Create Formulas Using Functions - part 1 Create Formulas Using Functions - part 2 Absolute Values Module 8 - Practice Exercise Working with Sheets Adding, Deleting, and Renaming Sheets Additional Sheet Tab Options 3 Dimensional Formulas Module 9 - Practice Exercise Formatting Worksheets Formatting Cells - part 1 Formatting Cells - part 2 Formatting Numbers Borders and Shading Format as Table Using Styles Using Format Painter Protecting Sheets Fill Handle and Custom Lists Module 10 - Practice Exercise Charts Creating Charts Types of Charts Editing Charts - Part 1 Editing Charts - Part 2 Using Graphics to Enhance Charts Linking Chart Titles Module 11 - Practice Exercise Working with Names Creating Range Names Managing Names Using Names in Formulas Module 12 - Practice Exercise Sorting and Filtering Remove Duplicates Sort Data Filter Data Advanced Filters Module 13 - Practice Exercise Outlining and Subtotaling Creating an Outline Subtotals Module 14 - Practice Exercise Working with Views Arranging Files New Window Option Custom Views Module 15 - Practice Exercise Linking Files Creating Formulas between Files Working with Links Consolidating Data Module 16 - Practice Exercise Advanced Formula Creation If Statements VLookups Data Validation Formula Auditing Module 17 - Practice Exercise PivotTables PivotTables Pivot Charts Module 18 - Practice Exercise Additional Excel Features Slicers Goal Seeker Text to Columns Watch Window Customizing Ribbons and Tabs Module 19 - Practice Exercise Shortcuts Excel Shortcuts Every User Should Know Closing Closing Video The Microsoft Excel 2019 - Advanced course is organised into the following modules: Chapter 1: Introduction to Excel 2019 Advanced Course Prerequisites of the Course and Version of Excel Course Structure Chapter 2: Functions Functions - Part 1 Functions - Part 2 Autosum Chapter 3: Date and Time Functions How Date and Time Works Basic Date and Time Functions Complex Date and Time Functions Chapter 4: Text Functions Using Text Functions - Part 1 Using Text Functions - Part 2 Chapter 5: Logical Functions Using Logical Functions Exercise 01 Chapter 6: Lookup Functions HLOOKUP Function VLOOKUP Function Exercise 02 Chapter 7: Financial Functions Financial Functions and Terminology Personal Financial Functions Professional Financial Functions Depreciation Exercise 03 Chapter 8: Statistical Functions Statistical Functions for Description - Part 1 Statistical Functions for Description - Part 2 Statistical Functions for Forecasting - Part 1 Statistical Functions for Forecasting - Part 2 Exercise 04 One Click Forecasting Statistical Functions for Inference Chapter 9: Connecting to External Data Connecting to Other Workbooks Connecting to Access Databases Connecting to Web Data Sources Get and Transform Exercise 05 Chapter 10: Tables Introduction to Tables Working with Tables Table References Table Styles Exercise 06 Chapter 11: Pivot Tables Introduction to Pivot Tables Working with Pivot Tables Filters and Slicers Pivot Charts Exercise 07 Chapter 12: Data Analysis What If Analysis Scenario Manager Goal Seek Solver Exercise 08 Chapter 13: Graphs and Charts Area Charts Surface Charts Radar Charts Bubble Charts Sparklines Stock Charts Exercise 09 Chapter 14: Excel Web App Introduction to Excel Web App Using the Excel Web App Chapter 15: Course Conclusion Closing Message Assessment / Exam There are no formal assessments for any of the courses within this training bundle. Prerequisites Microsoft Excel installed on your device. Preferably Excel 2016 &2019. You don't need any prior experience of using Microsoft Excel, our Microsoft Excel 2016 training covers beginners level training to help you develop the skills you need to progress in your career. Career Path We've put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience): Office Administrator Business Administrator Personal Assistant, Clerical Assistant Receptionist Secretary Customer Service Representative Project Officer, Project Manager Business Manager Sales Executive, Sales Manager, Sales Director Human Resource Officer Finance Assistant. Book-keeper, Accountant Healthcare Assistant, Nurse Database Administrator Career Advice Once you have achieved your certification, you'll have full access to our recruitment package for a wide range of information and advice - including: How to put together a killer CV, Covering Letters and Thank You emails. How to gain relevant work experience. How to prepare for interviews. How to understand Job adverts. How to choose the right recruitment agency. How to look for work on LinkedIn. Information on dealing with redundancy. Related Content Microsoft Powerpoint course Ultimate Microsoft Office 2019 Bundle course Microsoft Teams Microsoft courses Secretarial, PA & Office Skills courses Business, Management & Legal courses
