Booking options
£10.99
Course Images
Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7
By Studyhub UK
(3)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
22 hours 49 minutes
All levels
Description
Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you.
Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities.
Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential.
Learning Outcomes of our Microsoft Excel course:
Master Microsoft Excel 2019's latest features.
Perform complex calculations with ease.
Create visually appealing and well-formatted worksheets.
Analyze and visualize data effectively using charts and PivotTables.
Automate workbook tasks with Excel VBA.
Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7?
Digital 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
Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for?
Individuals new to Microsoft Excel looking to build a strong foundation.
Students and job seekers aiming to enhance their employability.
Business professionals wanting to improve data management and analysis skills.
Entrepreneurs seeking to streamline their business processes.
Anyone interested in harnessing the power of Excel for personal or professional growth.
Prerequisites
This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 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.
Career path
Data Analyst: £25,000 - £40,000 per year
Financial Analyst: £30,000 - £50,000 per year
Business Intelligence Analyst: £30,000 - £55,000 per year
Operations Manager: £35,000 - £70,000 per year
Project Manager: £40,000 - £70,000 per year
Excel VBA Developer: £35,000 - £60,000 per year
Certification
After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 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 £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8.
Endorsed Certificate of Achievement from the Quality Licence Scheme
Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10.
Endorsement
The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards.
Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.
Course Curriculum
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 | ||
Excel Templates | |||
Excel Templates | 00:00:00 | ||
Resources | |||
Resources - Microsoft Excel - Beginner Course - Cpd Accredited | 00:00:00 | ||
Mock Exam | |||
Mock Exam - Microsoft Excel Complete Course 2019 | 00:20:00 | ||
Final Exam | |||
Final Exam - Microsoft Excel Complete Course 2019 | 00:20:00 | ||
Order your QLS Endorsed Certificate | |||
Order your QLS Endorsed Certificate | 00:00:00 |
About The Provider
Studyhub UK
London, England
(3)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...
Reviews
There are no reviews for Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 yet.Why not be the first one to review this course?