Microsoft Excel Courses
Microsoft Excel 2016 Beginner, Intermediate and Advanced
Free
Designed to be both accessible and informative, the Microsoft Office Excel 2016 is delivered through video tutorials, online study materials and multiple-choice automated assessments that take you step-by-step through all the functions of Excel. The Microsoft Excel online training course includes modules on formatting worksheets, working with formulas and macros, visualising data with charts and PivotTables, as well as advanced techniques in data forecasting and validation. Course Curriculum This Microsoft Excel 2016 Beginner, Intermediate and Advanced Diploma is designed with the following modules: Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 1: Getting Started with Microsoft Office Excel 2016 - Navigate the Excel User Interface - Use Excel Commands - Create and Save a Basic Workbook - Enter Cell Data - Use Excel Help Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 2: Performing Calculations - Create Worksheet Formulas - Insert Functions - Reuse Formulas and Functions Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 3: Modifying a Worksheet - Insert, Delete, and Adjust Cells, Columns, and Rows - Search for and Replace Data - Use Proofing and Research Tools Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 4: Formatting a Worksheet - Apply Text Formats - Apply Number Format - Align Cell Contents - Apply Styles and Themes - Apply Basic Conditional Formatting - Create and Use Templates Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 5: Printing Workbooks - Preview and Print a Workbook - Set Up the Page Layout - Configure Headers and Footers Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 6: Managing Workbooks - Manage Worksheets - Manage Workbook and Worksheet Views - Manage Workbook Properties Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 7: Working with Functions - Work with Ranges - Use Specialized Functions - Work with Logical Functions - Work with Date & Time Functions - Work with Text Functions Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 8: Working with Lists - Sort Data - Filter Data - Query Data with Database Functions - Outline and Subtotal Data Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 9: Analyzing Data - Create and Modify Tables - Apply Intermediate Conditional Formatting - Apply Advanced Conditional Formatting Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 10: Visualizing Data with Charts - Create Charts - Modify and Format Charts - Use Advanced Chart Features Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 11: Using PivotTables and PivotCharts - Create a PivotTable - Analyze PivotTable Data - Present Data with PivotCharts - Filter Data by Using Timelines and Slicers Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 12: Working with Multiple Worksheets and Workbooks - Use Links and External References - Use 3-D References - Consolidate Data Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 13: Using Lookup Functions and Formula Auditing - Use Lookup Functions - Trace Cells - Watch and Evaluate Formulas Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 14: Sharing and Protecting Workbooks - Collaborate on a Workbook - Protect Worksheets and Workbooks Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 15: Automating Workbook Functionality - Apply Data Validation - Search for Invalid Data and Formulas with Errors - Work with Macros Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 16: Creating Sparklines and Mapping Data - Create Sparklines - MapData Office Productivity - Microsoft Excel 2016 Beginner, Intermediate and Advanced\ Module 17: Forecasting Data - Determine Potential Outcomes Using Data Tables - Determine Potential Outcomes Using Scenarios - Use the Goal Seek Feature - Forecasting Data Trends How is the Microsoft Excel 2016 Beginner, Intermediate and Advanced course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. # Certificate of Achievement ### Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
