Microsoft Excel
Description
Microsoft Excel
Master Microsoft Excel 2019 with practical, hands-on training designed for beginners and professionals alike. Learn how to organize data, create powerful formulas, build professional spreadsheets, and analyze information with confidence.
In this course, you’ll discover how to work with tables, functions, charts, PivotTables, conditional formatting, data validation, and workbook management to improve productivity and make better business decisions.
What You’ll Learn
- Navigate the Excel interface
- Create and format professional worksheets
- Build formulas and use essential functions
- Organize data with tables and sorting tools
- Analyze information using PivotTables and charts
- Apply conditional formatting and data validation
- Work across multiple worksheets and workbooks
- Automate repetitive tasks with basic macros
Who Should Take This Course?
This course is perfect for:
- Beginners learning Excel
- Administrative professionals
- Office workers
- Business and data analysts
- Finance professionals
- Students
- Small business owners
No previous Excel experience is required—just basic computer skills and a willingness to learn.
Microsoft® and Excel® are registered trademarks of Microsoft Corporation. This course is for educational purposes only and is not affiliated with or endorsed by Microsoft.
Curriculum
- 3 Sections
- 58 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- Module 1: Beginner13
- 1.11. Intro
- 1.22. The Ribbon
- 1.33. Saving Files
- 1.44. Entering and Formatting Data
- 1.55. Printing from Excel & Using Page Layout View
- 1.66. Formulas Explained
- 1.79. Correct a Formula Error
- 1.88. Specifying and Using Named Range
- 1.97. Working with Formulas and Absolute References
- 1.1011. Insert Function & Formula Builder
- 1.1112. How to Use a Function – AUTOSUM, COUNT, AVERAGE
- 1.1210. What is a Function
- 1.1313. Create and Customize Charts
- Module 2: Intermediate18
- 2.11. Recap
- 2.22. Navigating and editing in two or more worksheets
- 2.33. View Options – Split Screen, View Multiple Windows
- 2.44. Moving or Copying Worksheets to Another Workbook
- 2.55. Create a Link Between Two Worksheets and Workbooks
- 2.66. Creating Summary Worksheets
- 2.77. Freezing Cells
- 2.88. Add a Hyperlink to Another Document
- 2.99. Filters
- 2.1010. Grouping ad Ungrouping Data
- 2.1111. Creating and Customizing All Different Kinds of Charts
- 2.1212. Adding Graphics and Using Page Layout to Create Visually Appealing Page
- 2.1313. Using Sparkline Formatting
- 2.1414. Converting Tabular Data to an Excel Table
- 2.1516. Applying Data Validation to Cells
- 2.1615. Using Structured References
- 2.1717. Comments – Add, Review, Edit
- 2.1818. Locating Errors
- Module 3: Advanced27
- 3.11. Recap
- 3.22. Conditional (IF) Functions
- 3.33. Nested Condition Formulas
- 3.44. Date and Time Functions
- 3.55. Logical Functions
- 3.66. Informational Functions
- 3.77. VLOOKUP & HLOOKUP
- 3.88. Custom Drop Down Lists
- 3.99. Create Outline of Data
- 3.1010. Convert Text to Columns
- 3.1111. Protecting the Integrity of the Data
- 3.1212. What is it, how we use it and how to create a new rule
- 3.1313. Clear Conditional Formatting & Themes
- 3.1414. What is a Pivot Table and Why Do We Want One
- 3.1515. Create and Modify Data in a Pivot Table
- 3.1616. Formatting and Deleting a Pivot Table
- 3.1717. Create and Modify Pivot Charts
- 3.1818. Customize Pivot Charts
- 3.1919. Pivot Charts and Data Analysis
- 3.2020. What Is It and What Do We Use It For
- 3.2121. Scenarios
- 3.2222. Goal Seek
- 3.2323. Running Preinstalled Macros
- 3.2424. Recording and Assigning a New Macro
- 3.2525. Save a Workbook to be Macro Enabled
- 3.2626. Create a d Simple Macro with Visual Basics for Applications (VBA)
- 3.2727. Outro
Instructor
0 Students100 Courses
Reviews
Big Sale
Buy this course in package
You might be interested in
-
Intermediate
R5,999.00
-
243 Students
-
0 Lessons
-
4 Weeks
-
Intermediate
-
Intermediate
-
All levels
R5,999.00