Microsoft Excel 2019 Online Course with 100 Excel Templates
Microsoft Excel course UK covering Excel training course UK, Excel online course UK and certification pathway for UK job-ready spreadsheet skills.
274 Students
Overview
The Microsoft Excel course UK offers structured learning designed around modern spreadsheet tasks, reporting, and data handling using Excel 2019 features. Through the Excel online course UK, learners explore new functions such as CONCAT, IFS, SWITCH, and TEXTJOIN, alongside visual tools like Map and Funnel charts. Moreover, the Microsoft Excel training UK approach supports navigation, formulas, formatting, and worksheet management. In addition, the Excel course UK builds confidence in handling templates, PivotTables, and data analysis methods for varied professional environments across the UK job market.
Course Description
This Microsoft Excel course UK opens the door to structured spreadsheet expertise, where every lesson strengthens your ability to work with organised data. The Excel online course UK introduces updated Excel 2019 features, while also supporting smoother workbook creation and formatting workflows. Furthermore, the Microsoft Excel training UK pathway introduces advanced chart visuals and PivotTable enhancements that reshape how information is presented.
Additionally, the Excel training course UK guides you through formulas, logical functions, and data tools that improve decision-making clarity. Meanwhile, the advanced Excel course UK focuses on analytical tools such as forecasting, scenarios, and Goal Seek for structured business planning. Consequently, the Excel skills course UK strengthens accuracy in reporting, filtering, and validation techniques.
Finally, the Excel certification course UK integrates templates and real-world datasets, while the Excel for beginners UK pathway ensures accessibility for new learners. Overall, the learn Excel online UK journey equips you for confident progression within professional data environments.
Learning Outcomes
- Apply spreadsheet navigation techniques using Microsoft Excel course UK
- Build structured reports through Excel online course UK
- Use formula-based calculations within Microsoft Excel training UK
- Organise datasets using Excel training course UK
- Present analytical results using advanced Excel course UK
Who Is This Course For?
- Individuals starting with Excel for beginners UK
- Office staff improving with Excel skills course UK
- Learners pursuing learn Excel online UK
- Candidates preparing for Excel certification course UK
- Professionals upgrading via Excel course UK
Career Path
Data Analyst – Works with datasets to produce reports, trends, and insights for business decision-making.
Salary: £42,000 – £65,000 per year
Finance Analyst – Examines financial records, budgets, and forecasts using Excel-based models for accurate reporting.
Salary: £45,000 – £70,000 per year
Business Analyst – Reviews organisational performance data and supports strategic planning through structured spreadsheets.
Salary: £50,000 – £75,000 per year
Operations Manager – Oversees workflow systems, resource tracking, and performance reporting using Excel tools.
Salary: £48,000 – £80,000 per year
Reporting Analyst – Produces detailed reports, dashboards, and summaries for management review and decision support.
Salary: £43,000 – £68,000 per year
Management Information (MI) Analyst – Develops structured data reports and performance metrics for organisational planning.
Salary: £46,000 – £72,000 per year
Schema Markup
Frequently Asked Questions (FAQs)
You will learn formulas, functions, data tools, PivotTables, charts, and template usage through the Microsoft Excel training UK pathway, helping you build strong Excel capability for office and business tasks.
Yes, the Excel for beginners UK structure starts from basic worksheet handling and gradually moves towards advanced analysis features in a clear progression.
Yes, the Excel certification course UK supports career progression by improving spreadsheet, reporting, and analytical abilities required in many UK workplaces.
Yes, the learn Excel online UK format allows flexible study, making it easier to balance learning with work or personal commitments.
The advanced Excel course UK focuses on forecasting tools, scenario building, Goal Seek, and data analysis techniques for more complex decision-making tasks.
Microsoft Excel 2019 Online Course with 100 Excel Templates Course Reviews
An outstanding online course with clear explanations and practical examples. I could study at my own pace and still feel fully supported throughout. It’s truly boosted my confidence and career prospects
The course was well-structured, engaging, and easy to follow. The flexibility made it perfect alongside my full-time job. I’ve gained valuable, real-world skills that I can apply immediately.
Excellent learning experience from start to finish. The content was professional, up-to-date, and highly relevant. I would highly recommend it to anyone looking to upskill online.
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 | |||
| Welcome to the Course | FREE | 00:03:00 | |
| 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 Templates | |||
| Excel Templates | 00:00:00 | ||
Frequently Asked Questions
Yes, Discover Training provides accredited and CPD-certified courses, ensuring learners receive recognised qualifications that support career progression and professional compliance.
Anyone can enrol, including students, professionals, job seekers, career changers, and organisations. Most courses do not require previous experience, making them accessible to learners at all levels.
Discover Training offers courses across multiple sectors, including business, health and safety, compliance, leadership, IT, personal development, and professional skills training.
You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.
Yes, learners receive a downloadable digital certificate upon successful completion, suitable for CPD records, CVs, and professional portfolios.
-
Number of Units:
72 -
Access:
1 Year -
Duration:
10 hours, 42 minutes -
PDF Certificate
Included
