Booking options
£10.99
£10.99
On-Demand course
22 hours 49 minutes
All levels
The course 'Microsoft Excel' covers the latest features of Microsoft Excel 2019, introducing learners to CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN, Map Chart, Funnel Chart, and other enhancements. It also covers fundamental Excel skills, data analysis, visualization, pivot tables, workbook management, and automation using VBA.
Familiarize with the new features in Microsoft Excel 2019, including CONCAT, IFS, MAXIFS, MINIFS, SWITCH, and more.
Gain proficiency in basic Excel tasks like navigating the user interface, entering data, and using Excel commands.
Perform calculations, create formulas, and use functions to analyze and manipulate data effectively.
Format worksheets, apply conditional formatting, and utilize templates to present data professionally.
Understand data visualization using charts, sparklines, and mapping techniques in Excel.
Work with PivotTables and PivotCharts for in-depth data analysis and presentation.
Learn advanced Excel features such as data validation, scenarios, and Goal Seek.
Automate workbook functionality using macros and Visual Basic for Applications (VBA).
Collaborate on workbooks, protect data, and apply security measures in Excel.
Create and work with Excel templates to streamline repetitive tasks and optimize workflow.
Unlimited access to the course for forever
PDF Certificate, Transcript, student ID all included in the price
Absolutely no hidden fees
Directly receive CPD accredited qualifications after course completion
Receive one to one assistance on every weekday from professionals
Immediately receive the PDF certificate after passing
Receive the original copies of your certificate and transcript on the next working day
Easily learn the skills and knowledge from the comfort of your home
After studying the course materials of the Microsoft Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.
This Microsoft Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.
This Microsoft Excel was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel is a great way for you to gain multiple skills from the comfort of your home.
Microsoft Excel 2019 New Features | |||
Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
CONCAT | 00:02:00 | ||
IFS | 00:01:00 | ||
MAXIFS | 00:01:00 | ||
MINIFS | 00:01:00 | ||
SWITCH | 00:02:00 | ||
TEXTJOIN | 00:01:00 | ||
Map Chart | 00:02:00 | ||
Funnel Chart | 00:01:00 | ||
Better Visuals | 00:06:00 | ||
Pivot Table Enhancements | 00:02:00 | ||
Power Pivot Updates | 00:01:00 | ||
Getting Started with Microsoft Office Excel | |||
Navigate the Excel User Interface | 00:28:00 | ||
Use Excel Commands | 00:10:00 | ||
Create and Save a Basic Workbook | 00:19:00 | ||
Enter Cell Data | 00:12:00 | ||
Use Excel Help | 00:05:00 | ||
Performing Calculations | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Modifying a Worksheet | |||
Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
Search for and Replace Data | 00:09:00 | ||
Use Proofing and Research Tools | 00:07:00 | ||
Formatting a Worksheet | |||
Apply Text Formats | 00:16:00 | ||
Apply Number Format | 00:08:00 | ||
Align Cell Contents | 00:09:00 | ||
Apply Styles and Themes | 00:12:00 | ||
Apply Basic Conditional Formatting | 00:11:00 | ||
Create and Use Templates | 00:08:00 | ||
Printing Workbooks | |||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:09:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Managing Workbooks | |||
Manage Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:06:00 | ||
Working with Functions | |||
Work with Ranges | 00:18:00 | ||
Use Specialized Functions | 00:11:00 | ||
Work with Logical Functions | 00:23:00 | ||
Work with Date & Time Functions | 00:08:00 | ||
Work with Text Functions | 00:11:00 | ||
Working with Lists | |||
Sort Data | 00:10:00 | ||
Filter Data | 00:10:00 | ||
Query Data with Database Functions | 00:09:00 | ||
Outline and Subtotal Data | 00:09:00 | ||
Analyzing Data | |||
Apply Intermediate Conditional Formatting | 00:07:00 | ||
Apply Advanced Conditional Formatting | 00:05:00 | ||
Visualizing Data with Charts | |||
Create Charts | 00:13:00 | ||
Modify and Format Charts | 00:12:00 | ||
Use Advanced Chart Features | 00:12:00 | ||
Using PivotTables and PivotCharts | |||
Create a PivotTable | 00:13:00 | ||
Analyze PivotTable Data | 00:12:00 | ||
Present Data with PivotCharts | 00:07:00 | ||
Filter Data by Using Timelines and Slicers | 00:11:00 | ||
Working with Multiple Worksheets and Workbooks | |||
Use Links and External References | 00:12:00 | ||
Use 3-D References | 00:06:00 | ||
Consolidate Data | 00:05:00 | ||
Using Lookup Functions and Formula Auditing | |||
Use Lookup Functions | 00:12:00 | ||
Trace Cells | 00:09:00 | ||
Watch and Evaluate Formulas | 00:08:00 | ||
Sharing and Protecting Workbooks | |||
Collaborate on a Workbook | 00:19:00 | ||
Protect Worksheets and Workbooks | 00:08:00 | ||
Automating Workbook Functionality | |||
Apply Data Validation | 00:13:00 | ||
Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
Work with Macros | 00:18:00 | ||
Creating Sparklines and Mapping Data | |||
Create Sparklines | 00:07:00 | ||
MapData | 00:07:00 | ||
Forecasting Data | |||
Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
Use the Goal Seek Feature | 00:04:00 | ||
Forecasting Data Trends | 00:05:00 | ||
Excel VBA Data Management | |||
Create a Macro Using the Macro Recorder | 01:00:00 | ||
Edit a Macro | 01:00:00 | ||
Debug a Macro | 00:30:00 | ||
Customize the Quick Access Toolbar and Hotkeys | 00:30:00 | ||
Set Macro Security | 01:00:00 | ||
Insert Text | 00:30:00 | ||
Format Text | 00:30:00 | ||
Sort Data | 00:30:00 | ||
Duplicate Data | 01:00:00 | ||
Generate a Report | 01:00:00 | ||
Determine the Dialog Box Type | 00:15:00 | ||
Capture User Input | 01:00:00 | ||
Insert, Copy, and Delete Worksheets | 00:30:00 | ||
Rename Worksheets | 00:30:00 | ||
Modify the Order of Worksheets | 00:15:00 | ||
Print Worksheets | 00:30:00 | ||
Create User-Defined Functions | 00:30:00 | ||
Automate SUM Functions | 00:30:00 | ||
Activities and Exercise Files - Microsoft Excel 2016 and VBA | 00:00:00 | ||
Excel Templates | |||
Excel Templates | 00:00:00 | ||
Mock Exam | |||
Mock Exam - Microsoft Excel | 00:20:00 | ||
Final Exam | |||
Final Exam - Microsoft Excel | 00:20:00 |
Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...