Microsoft Excel Complete Course 2019 Online Course
Master Excel 2019 A-Z with advanced features, formulas, charts, PivotTables, and more.
Location
Online
Refund Policy
About this event
Unlock the full potential of Microsoft Excel 2019 through this all-in-one, in-depth training course designed for absolute beginners to advanced users. Whether you're a student, professional, entrepreneur, or someone eager to understand how Excel transforms data management, this course takes you from foundational concepts to expert-level insights.
This comprehensive course delves into every crucial Excel skill you need—covering everything from basic worksheet navigation to advanced data analysis tools, visualization techniques, automation features, and business forecasting. You'll learn practical applications, formulas, functions, formatting tips, templates, and more. The curriculum has been structured to provide seamless progression through the topics, ensuring every learner gains real-world proficiency.
Throughout this course, we will leverage over 30 essential keywords that will not only boost your Excel knowledge but help you confidently handle spreadsheets, design dashboards, manage data, and automate tasks using Excel 2019's powerful tools.
Learning Outcomes
- Understand Excel 2019 interface and navigate with confidence.
- Apply formulas and functions to perform complex calculations easily.
- Organize, format, and manage large datasets efficiently.
- Create visual data representations using charts and PivotTables.
- Automate repetitive tasks using Excel’s built-in tools.
- Analyze, forecast, and map data for informed decision-making.
Course Link: Microsoft Excel Complete Course 2019
Course Curriculum
1. Microsoft Excel 2019 New Features
Learn about the latest updates, interface enhancements, and improved tools introduced in Excel 2019. Understand how new functionalities improve speed, accuracy, and workflow efficiency.
2. Getting Started with Microsoft Office Excel
Understand Excel’s layout, ribbons, menus, and basic commands. Learn how to create, save, and open spreadsheets confidently.
3. Performing Calculations
Master arithmetic operations, use AutoSum, and apply operators within cells. Understand precedence and bracket usage in formulas.
4. Modifying a Worksheet
Insert, delete, move, or resize rows, columns, and cells. Use drag-fill, flash fill, and customize views.
5. Formatting a Worksheet
Use fonts, colors, borders, alignment, and conditional formatting to enhance worksheet readability and style.
6. Printing Workbooks
Set up print areas, apply headers/footers, adjust scaling, and preview before printing.
7. Managing Workbooks
Rename, copy, move, and delete worksheets. Learn workbook protection and recovery options.
8. Working with Functions
Explore essential functions like SUM, AVERAGE, IF, COUNT, and nested formulas.
9. Working with Lists
Sort, filter, use custom lists, and apply data validation to manage structured data efficiently.
10. Analyzing Data
Use built-in tools like Goal Seek, Data Tables, and Scenario Manager for effective analysis.
11. Visualizing Data with Charts
Create and customize bar charts, pie charts, line graphs, and combo charts for impactful data visuals.
12. Using PivotTables and PivotCharts
Build dynamic PivotTables to summarize data, and PivotCharts for quick insights.
13. Working with Multiple Worksheets and Workbooks
Link, consolidate, and reference data across multiple sheets and files for unified reports.
14. Using Lookup Functions and Formula Auditing
Master VLOOKUP, HLOOKUP, INDEX & MATCH, and use auditing tools to trace errors.
15. Sharing and Protecting Workbooks
Collaborate in real-time, protect sheets with passwords, and manage access controls.
16. Automating Workbook Functionality
Create and run macros, assign buttons, and use the Developer tab for automation.
17. Creating Sparklines and Mapping Data
Use sparklines for mini-charts and leverage map charts to visualize location-based data.
18. Forecasting Data
Predict trends using Excel's Forecast Sheet and built-in statistical tools.
19. Excel Templates
Utilize ready-to-use templates for budgets, calendars, invoices, and dashboards.
Lifetime Membership to 2500+ Courses
Our Prime Learners will Get:
- Instant, Unlimited & Lifetime Access to 2500+ Courses
- Unlimited Free Accredited Certificates
- Access to All Career Certificate Bundles
- Free Student ID card & Many More
Disclaimer:
This is an online course with pre-recorded lessons. You will get access to the course within 48 hours after your enrolment.
Frequently asked questions
No, this is a fully online self-paced course, allowing you to complete it at your convenience, anytime, anywhere.
Once you purchase the ticket, we will assign you to the course within 48 hours and send your login details via email.
This is a self-paced course, so you can work through the material at your own speed.
Yes, we provide both a digital and a hard copy certificate free of charge. However, Hardcopy Certificate shipping costs apply—£3.99 within the UK and £10 for international addresses.
Yes, you will have lifetime access to the course and can revisit it anytime.
Yes, this course is designed for beginners, and no prior knowledge is required.
You will receive 24/7 learning assistance throughout your course.
No, you don’t need any special equipment. The course is self-paced and accessible on a laptop, tablet, or smartphone.
Organized by
Training Express is a premier course provider in the UK, trusted by over 1,000,000 students and 10,000 business partners worldwide. Established by a dedicated team of experts, we specialise in delivering accredited certification and training designed to enhance organisational performance across various sectors and industries. Our comprehensive courses focus on promoting high standards of food hygiene, business wellbeing, and workplace safety.