Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
- Overview
Gain excellence in Microsoft Excel. Step by step video lessons. Everything from Pivot tables, VLOOKUP, excel dashboards, and more. Plus you get access to 50+ exclusive excel templates, fully ready for you to use.
Launch the dynamic career you’ve always wanted! Take this high-quality Microsoft Excel Complete Course 2019 course worth to articulate your innovative goals and develop a simple approach for attaining them.
Whether you’re an aspirant looking to start your dream career, a professional looking to branch out, or somebody in between — this Microsoft Excel Complete Course 2019, QLS Endorsed Course will get you sorted. The rudimentary knowledge in this course will add tremendous value and enable you to establish the meaningful Microsoft Excel Complete Course 2019 career you’ve always craved.
Get £2495 worth of courses & certificates at only £150 (saving 94%) by enrolling now and become the person who would attract the results you seek. What you plant now, you will harvest later. So, grab this opportunity and start learning!
- Why Choose Imperial Academy?
What unique features you will be getting in this new class of Microsoft Excel Complete Course 2019 – you asked?
You will receive –
- Courses: 1 QLS Endorsed Course & 10 CPD accredited courses.
- Certificate:
- QLS Certificate: 1 Quality Licence Scheme certificate of achievement completely free of charge.
- CPD Certificate: 10 PDF certificates as complimentary gifts.
- Endorsed by: The Quality Licence Scheme (QLS).
- Accredited by: CPD QS.
- Available to: The UK and international learners.
- Tutor support: Unlimited support from experts.
- Post-course help? Yes – expert tutoring when you finish.
This Microsoft Excel Complete Course 2019, 11-in-1 Exclusive Bundle course will help you overcome any career obstacles and support you in establishing your own professional path by providing you with these phenomenal courses —
- Course 01: Microsoft Excel Complete Course 2019 at QLS Level 7
- Course 02: New Functions in Microsoft Excel 2021
- Course 03: Microsoft Excel: Excel Sheet Comparison with VBA
- Course 04: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
- Course 05: Microsoft Excel: Master Power Query in 120 Minutes!
- Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
- Course 07: Financial Modelling Using Excel
- Course 08: Diploma in Business Analysis
- Course 09: Touch Typing Essentials
- Course 10: GDPR Certificate
- Course 11: Office Management and Administration Diploma
This Microsoft Excel Complete Course 2019 training will help you become an expert in a relevant sector. Our world-class tutors will help you with every query throughout your learning journey and assist you in mastering Microsoft Excel Complete Course 2019. So, add this Microsoft Excel Complete Course 2019 course to your basket — harness the coveted skills and open the door to your next breakthrough!
- Learning Outcome
- Learn About The New Features Of Microsoft Excel 2019
- Learn How To Get Started With Ms Excel
- Know About Using Lookup Functions And Formula Auditing
- Learn How To Create Sparklines And Mapping Data
- Learn How To Manage Workbooks
- Learn How To Analyse Data
- Learn How To Work With Multiple Worksheets And Workbooks
- Learn How To Create Sparklines And Mapping Data
- Who Is This Course For?
Whether you're seeking to begin a new hobby, discover your speciality, or convert your passion into a career, this Microsoft Excel Complete Course 2019 course is the bundle for you. This training will keep you up to date on all the latest advancements and provide you with the necessary guidance in the Microsoft Excel Complete Course 2019 sector
- Specialised Assessment
To make the process of assessing and certifying learners easier in this Microsoft Excel Complete Course 2019 bundle, we provide an automated evaluation system.
- For each online module, you will take a tailored multiple-choice exam.
- After completing the assessment, your performance will be measured instantly, and a score will be shown for your review.
- The pass mark for each assessment is 60%.
- Once all assessments have been passed successfully, you will be able to collect your Quality Licence Scheme endorsed certificate.
- Course Design
Learn at your own pace from the comfort of your home, as the rich learning materials of this QLS Endorsed course is accessible from any place at any time. The advanced course curriculums are divided into tiny bite-sized audio-visual modules by industry specialists with years of experience behind them.
- Audio-visual Lessons
- Online Study Materials
Course Curriculum
| Microsoft Excel Complete Course 2019 | |||
| 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 | ||
| Resources | |||
| Resources – Microsoft Excel Complete Course 2019 | 4 days, 4 hours | ||
| Mock Exam | |||
| Mock Exam – Microsoft Excel Complete Course 2019 | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Microsoft Excel Complete Course 2019 | 00:20:00 | ||
| Assignment | |||
| Assignment – Microsoft Excel Complete Course 2019 | 4 days, 4 hours | ||
| Order Your Certificate | |||
| Order Your Certificate | 00:00:00 | ||
Certificate of Achievement
Learners will get an certificate of achievement directly at their doorstep after successfully completing the course!
It should also be noted that international students must pay £10 for shipping cost.
CPD Accredited Certification
Upon successfully completing the course, you will be qualified for CPD Accredited Certificate. Certification is available –
- PDF Certificate £7.99
- Hard Copy Certificate £14.99
Recent Courses
Sports Therapy and Coaching with Sports Psychology – 3 in 1 QLS Bundle
- Career Bundle
- Employability
- Quality Licence Scheme Endorsed
