Microsoft Excel 2019

(5 customer reviews)
Sale!

Leading the way

Microsoft Excel 2019

(5 customer reviews)

| Total Course Video Hours: 5 Hrs 37 Min
|  Videos: 58
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute

Course Fee:

R1600,00

Current Special Ends in:

  • 00Days
  • 00Hours
  • 00Min
  • 00Sec

Overview

Microsoft Excel is the most popular spreadsheet application for both personal and professional use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2019 training course because it covers basic, intermediate and advanced topics.

Our Microsoft Excel 2019 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built-in structure and functions of Microsoft Excel.

Claim your FREE R500 Gift Voucher

FREE R500 gift voucher, especially for you 🎁

Join our mailing list and get your free exclusive R500 discount voucher.

This Voucher can be used for any of our Bundle Courses.

Curriculum

Module 1: Beginner
1. Intro
2. The Ribbon
3. Saving Files
4. Entering and Formatting Data
5. Printing from Excel & Using Page Layout View
6. Formulas Explained
7. Working with Formulas and Absolute References
8. Specifying and Using Named Range
9. Correct a Formula Error
10. What is a Function
11. Insert Function & Formula Builder
12. How to Use a Function – AUTOSUM, COUNT, AVERAGE
13. Create and Customize Charts

 

Module 2: Intermediate
1. Recap
2. Navigating and editing in two or more worksheets
3. View Options – Split Screen, View Multiple Windows
4. Moving or Copying Worksheets to Another Workbook
5. Create a Link Between Two Worksheets and Workbooks
6. Creating Summary Worksheets
7. Freezing Cells
8. Add a Hyperlink to Another Document
9. Filters
10. Grouping ad Ungrouping Data
11. Creating and Customizing All Different Kinds of Charts
12. Adding Graphics and Using Page Layout to Create Visually Appealing Pages
13. Using Sparkline Formatting
14. Converting Tabular Data to an Excel Table
15. Using Structured References
16. Applying Data Validation to Cells
17. Comments – Add, Review, Edit
18. Locating Errors

Module 3: Advanced
1. Recap
2. Conditional (IF) Functions
3. Nested Condition Formulas
4. Date and Time Functions
5. Logical Functions
6. Informational Functions
7. VLOOKUP & HLOOKUP
8. Custom Drop Down Lists
9. Create Outline of Data
10. Convert Text to Columns
11. Protecting the Integrity of the Data
12. What is it, how we use it and how to create a new rule
13. Clear Conditional Formatting & Themes
14. What is a Pivot Table and Why Do We Want One
15. Create and Modify Data in a Pivot Table
16. Formatting and Deleting a Pivot Table
17. Create and Modify Pivot Charts
18. Customize Pivot Charts
19. Pivot Charts and Data Analysis
20. What Is It and What Do We Use It For
21. Scenarios
22. Goal Seek
23. Running Preinstalled Macros
24. Recording and Assigning a New Macro
25. Save a Workbook to be Macro Enabled
26. Create a d Simple Macro with Visual Basics for Applications (VBA)
27. Outro

5 reviews for Microsoft Excel 2019

  1. Zahara

    The course was flexible, allowing me to access the materials anytime and from any device.

  2. Nontobeko

    Your course is top-notch. Thank you for the outstanding learning experience!

  3. Elijah

    The course had a logical progression, building on previous concepts and gradually increasing difficulty.

  4. Sanaa

    The course helped me develop a solid foundation in the subject matter, even as a beginner.

  5. Charlotte

    Best course I have ever done!

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.