*** Mastering Microsoft Excel Basics **
Course Content
Getting Started
The introductory part covers an overview of MS Excel basics, navigating the interface, selecting data, using commands, creating a new workbook, and entering cell data. You’ll also know about using auto and flash fill expand to Excel help.
Performing Calculations
This section demonstrates creating formulas, inserting functions, copying formulas, functions and using absolute reference.
Modifying Worksheets
You’ll be able to insert and delete cells, search and replace, using proofing and research tools.
Formatting Worksheets
Module four extensively demonstrates applying text, number format, customisation, aligning cell contents, and applying cell styles and themes. You’ll also be able to use inserting hyperlinks, conditional formatting to text and dates, comparative analysis, formatting, and templates.
Printing Workbooks
Printingworkbook knowledge will enhance your skills. You’ll feel more confident setting the page layout, inserting page breaks, and configuring headers and footers with parts 1 and 2.
Managing Workbooks
This module introduces managing worksheet parts 1 and 2, creating a custom view for the worksheet, and the work view expands to managing workbook properties.
Customising options
You’ll familiarise yourself with customising general options, ribbon, and the quick access toolbar.
*** Mastering Microsoft Excel Intermediate **
Working with Functions
This module covers an overview of MS excel intermediate, using named ranges from parts 1 to 3, working with date functions from parts 1 to 3, time, logic, conditional, multiple criteria and using nested functions. You’ll also be able to skill in using IFS and SWITCH, working with text functions extensively with 1 to 4 parts, and finally, working with math.
Working with Lists
Module two demonstrates sorting data from parts 1 to 2, filtering data from parts 1 to 3,querying with database functions, and expanding to using the subtotal function to feature.
Analysing Data
This module will enable you to create tables, modify styles, summarise data, use the quick analysis shortcut, expand to customising conditional formatting, and use formulas.
Visualising Data with Charts
Module four introduces creating charts, using chart types, changing chart data sources, adding chart elements and formatting a chart. You’ll also feel confident using advanced chart features, applying trendlines and creating a chart template.
Inserting Graphics
This section will enhance your skill in Inserting Graphics and modifying Graphics in parts 1 and 2
Using PivotTables and PivotCharts
Module six will sharpen your skill in creating a pivot table, summarising and grouping data, formatting, selecting and moving pivot tables. You’ll also be able to use changing options, add calculated fields, present data with pivot charts, using slicers and timelines.
*** Mastering Microsoft Excel 2019 Advanced **
Linking and Consolidating
This introductory module covers an overview of mastering Excel advanced level, like creating internal and external links, using paste special, group modes, 3D references and consolidating data.
Sharing and Protecting
You’ll introduce adding comments, tracking changes, co-authoring parts 1 and 2, using compare and merge and preparing to share. You’ll also be able to use adding digital signatures, protect worksheets, workbook structure and a workbook file.
Automating
Module three will enable you to apply data validation, add a dropdown list, customise data validation, record, run, and edit a macro.
Using Lookup Functions
Using VLOOKUP parts 1 and 2, more functions and array formulas will sharpen your excel skill.
Auditing Formulas
Module five will feel more confident in using tracing formulas, addressing errors, watching and evaluating, expanding to adding error handling knowledge and working with information functions.
Forecasting Data
This module will guide you to using goal seeking, forecasting with data tables, and using solver. You’ll also be able to forecast with scenarios and data trends.
More Features
Module seven demonstrates extensively inserting symbols and characters, creating sparklines, a map chart, 3D maps and Custom lists. You’ll also be able to skill in importing and exporting data, creating a web query, working with forms, and using ActiveX controls and ideas in office 365.
Certificates
Course Central is proud to offer a Certificate of Completion to all who complete courses successfully. Course Central tracks the learner’s course progress. However, the learner is responsible for validating the completion and understanding of the course. All Certificates of Completion can be validated from the Course Central website using the validation code.
Transcripts
A Transcript for the course with completed module details can be requested for as little as £4.99. Please note that all course Certificates and Transcripts will be titled as published on the Course Central platform.
