CPD-accredited courses from £39 · Instant e-certificates · 2,700+ courses
CPD-accredited certificates 020 4618 6402 Team training
Home / Courses / Microsoft Office / Microsoft Excel 2019 for Beginner
CPD course All Levels

Microsoft Excel 2019 for Beginner

5.0 (10 ratings) 3 enrolled 10h 50m of learning Updated Nov 2026
CertificateOn completion
10h 50mSelf-paced
71 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 71 lessons 10h 50m total
01 Microsoft Excel 2019 for Beginner 71 lessons
  1. Introduction to Microsoft Excel 2019 New Features
  2. CONCAT
  3. IFS
  4. MAXIFS
  5. MINIFS
  6. SWITCH
  7. TEXTJOIN
  8. Map Chart
  9. Funnel Chart
  10. Better Visuals
  11. Pivot Table Enhancements
  12. Power Pivot Updates
  13. Navigate the Excel User Interface
  14. Use Excel Commands
  15. Create and Save a Basic Workbook
  16. Enter Cell Data
  17. Use Excel Help
  18. Create Worksheet Formulas
  19. Insert Functions
  20. Reuse Formulas and Functions
  21. Insert, Delete, and Adjust Cells, Columns, and Rows
  22. Search for and Replace Data
  23. Use Proofing and Research Tools
  24. Apply Text Formats
  25. Apply Number Format
  26. Align Cell Contents
  27. Apply Styles and Themes
  28. Apply Basic Conditional Formatting
  29. Create and Use Templates
  30. Preview and Print a Workbook
  31. Set Up the Page Layout
  32. Configure Headers and Footers
  33. Manage Worksheets
  34. Manage Workbook and Worksheet Views
  35. Manage Workbook Properties
  36. Work with Ranges
  37. Use Specialized Functions
  38. Work with Logical Functions
  39. Work with Date & Time Functions
  40. Work with Text Functions
  41. Sort Data
  42. Filter Data
  43. Query Data with Database Functions
  44. Outline and Subtotal Data
  45. Apply Intermediate Conditional Formatting
  46. Apply Advanced Conditional Formatting
  47. Create Charts
  48. Modify and Format Charts
  49. Use Advanced Chart Features
  50. Create a PivotTable
  51. Analyze PivotTable Data
  52. Present Data with PivotCharts
  53. Filter Data by Using Timelines and Slicers
  54. Use Links and External References
  55. Use 3-D References
  56. Consolidate Data
  57. Use Lookup Functions
  58. Trace Cells
  59. Watch and Evaluate Formulas
  60. Collaborate on a Workbook
  61. Protect Worksheets and Workbooks
  62. Apply Data Validation
  63. Search for Invalid Data and Formulas with Errors
  64. Work with Macros
  65. Create Sparklines
  66. MapData
  67. Determine Potential Outcomes Using Data Tables
  68. Determine Potential Outcomes Using Scenarios
  69. Use the Goal Seek Feature
  70. Forecasting Data Trends
  71. Excel Templates

About this course

Microsoft Excel 2019 for Beginner teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Microsoft Excel 2019 for Beginner is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.

To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.

The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.

  • Accredited by CPD
  • Instant e-certificate
  • Fully online, interactive course with audio voiceover
  • Self-paced learning and laptop, tablet, smartphone-friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Who should take the course

Anyone with a knack for learning new skills can take this Microsoft Excel 2019 for Beginner. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this Microsoft Excel 2019 for Beginner, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Course Curriculum

The detailed curriculum outline of our Microsoft Excel 2019 for Beginner is as follows:

Microsoft Excel 2019 for Beginner

  • Microsoft Excel 2019 New Features
  • Getting Started with Microsoft Office Excel
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbooks
  • Managing Workbooks
  • Working with Functions
  • Working with Lists
  • Analyzing Data
  • Visualizing Data with Charts
  • Using PivotTables and PivotCharts
  • Working with Multiple Worksheets and Workbooks
  • Using Lookup Functions and Formula Auditing
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data
  • Forecasting Data
  • Excel Templates

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Learner ratings

5.0

Rated by 10 learners on the UISC learning portal · 3 enrolled

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

Keep learning

Related courses

More in Microsoft Office
Data Analysis In Excel
Save 86%
31 lessons
Microsoft Office 4h 51m

Data Analysis In Excel

16 others bought this course in the last 24 hours! Data Analysis In Excel teaches you everything on the topic thoroughly from scratch so you can achieve a profe...

4.7 (7) 4 enrolled
£39.00 £279.00
Enrol now
Microsoft Excel
Save 86%
23 lessons
Microsoft Office 4h 17m

Microsoft Excel

Microsoft Excel Training Course is designed for data coordinators, accounts assistants, administrative professionals or any individual who wants to brush up the...

4.9 (9) 4 enrolled
£39.00 £279.00
Enrol now
£39.00 10h 50m · All Levels
Enrol now