Microsoft Excel Complete Course 2019
Excel Efficiency Unleashed
Microsoft Excel Complete Course 2019 is an all-encompassing training program designed to make learners experts in Excel 2019, from basic functionalities to advanced data management techniques. This course equips you with the skills to create, analyse, and visualise data efficiently, mastering everything from formulas and functions to PivotTables, charts, and VBA automation. Whether you’re a student, professional, or business owner, this course enables you to optimise workflow, improve decision-making, and gain a competitive edge in data-driven environments. By completing this course, you’ll be ready to handle complex data tasks with confidence and precision.
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.
Real-World Benefits
This course empowers you to manage, analyse, and present data efficiently, making you indispensable in professional settings. Graduates can work in finance, administration, data analysis, marketing, and operations, using Excel to streamline processes, automate repetitive tasks, and generate actionable insights. Mastery of Excel 2019 enhances productivity, supports data-driven decision-making, and improves your ability to visualise and communicate complex information clearly in any UK business environment.
Course Description
Microsoft Excel Complete Course 2019 guides learners through all essential and advanced Excel features. Modules cover new features in Excel 2019, getting started with Microsoft Office Excel, performing calculations, and modifying worksheets. You’ll learn formatting, printing, managing workbooks, using functions, working with lists, and analysing data. Advanced topics include visualising data with charts, using PivotTables and PivotCharts, multiple worksheets, lookup functions, formula auditing, workbook protection, and automation. Learners also explore creating sparklines, mapping data, forecasting, Excel VBA, and using templates. A mock exam and resource materials consolidate knowledge, ensuring learners can apply Excel skills effectively in real-world scenarios.
Master Excel 2019 features, functions, and formulas
Create and manage worksheets and workbooks effectively
Analyse and visualise data using charts, PivotTables, and PivotCharts
Apply lookup functions, formula auditing, and automation techniques
Protect and share workbooks securely
Use Excel VBA for data management and process automation
Aspiring data analysts, accountants, and office professionals
Students and graduates seeking practical Excel skills for career readiness
Business owners and managers wanting to optimise workflows
Professionals aiming to improve data analysis and reporting efficiency
Anyone seeking advanced Excel knowledge including PivotTables, charts, and VBA
Comprehensive coverage of basic to advanced Excel 2019 functionalities
Hands-on practical training for real-world business applications
Expert instruction on data analysis, visualisation, and automation
Flexible learning for students, professionals, and career changers
Focus on career-ready skills and employable Excel proficiency
Trusted institution offering high-quality, industry-relevant Excel training
Office Administrator / Data Entry Clerk – £18,000 to £25,000 per year
Accounts / Finance Assistant – £20,000 to £28,000 per year
Data Analyst / Business Analyst – £28,000 to £40,000 per year
Operations / Project Coordinator – £25,000 to £35,000 per year
Excel Specialist / VBA Developer – £30,000 to £45,000 per year
Senior Analyst / Team Lead – £40,000 to £55,000 per year
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 | 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 | ||
| Assignment | |||
| Assignment – Microsoft Excel Complete Course 2019 | 01:20:00 | ||
Certificate of Achievement
Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:
Pdf Certificate & Transcript £7.99
Hardcopy Certificate & Transcript £17.99
This certification validates your knowledge and skills, boosting your employability in healthcare.
Access
Level
Number of Units
Duration