Course Curriculum
*** Microsoft Excel ***
Microsoft Excel from A-Z Course Introduction
- Excel from A-Z Course Section Overview
- What is Microsoft Excel?
- Who This Course is For
- Marketplace
- Microsoft Excel Job Opportunities
- Microsoft Excel Job Types
Getting Started with Microsoft Excel
- Finding & Opening Microsoft Excel
- Excel’s Start Screen
- Explaining the Excel Interface
- Excel Interface Continued
- Excel Workbook vs Excel Worksheet
- Saving & Opening Excel Documents
- Customizing the Excel Quick Access Toolbar
- Customizing the Excel Ribbon
- Excel Shortcut Keys
Values, Referencing and Formulas
- Creating Excel Labels
- Entering Numeric Values in Excel
- Formatting Date Values in Excel
- Building Basic Formulas in Excel
- Order of Operations
- Relative vs Absolute Cell References
Intro to Microsoft Excel Functions
- Excel Functions Explained
- The SUM() Function
- The MIN() & MAX() Function
- The AVERAGE() Function
- COUNT() Functions
Adjusting Microsoft Excel Worksheets
- Moving & Copying Data
- Insert & Delete Rows/Columns
- Adjusting the Width & Height of Cells
- Hiding and Unhiding Excel Rows and Columns
- Renaming, Moving & Deleting Excel Worksheets
- Adding Protection to Specific Cells
- Protecting the Structure of a Workbook
- Adding a Workbook Password to Open File
Visually Pleasing Cell Formatting
- Formatting Fonts and Cell Background Color
- Adding Cell Borders
- Formatting Data Appropriately
- The Magic behind Excel’s Format Painter
- Creating Styles for Formatting Efficiency
- Merging Cells for a Cleaner Look
- The Power of Conditional Formatting
How to Insert Images and Shapes!
- Grab User’s Attention using Illustrations
- Customizing Icons
- Create Compelling Graphics with SmartArt
Visualize Data with Charts
- The Commonly used Column Chart
- Changing the Chart Design
- Formatting Elements of a Chart
- Modifying the Data, Type & Location of a Chart
- Little Slice of Pie Charts
Microsoft Excel's Printing Options
- Print Preview Options
- Excel’s Page Layout View
- Printing a Specific Range of Cells
- Converting Spreadsheets to PDF Files
Benefits of Using Microsoft Excel Templates
- Why Create an Excel Template
- How to Create an Excel Template
Working with Microsoft Excel Datasets
- How to Prepare Data for Analysis
- How to Sort Data in Excel
- Multi-Level Sorting
- Custom Sorting Datasets in Excel
- Applying Filters to Datasets
- Creating Subtotals within a Dataset
- Converting Datasets into Tables
- Finding & Removing Duplicate Values
Microsoft Excel Database Functions
- The SUMIF() Function
- The DSUM() Function
- DSUM() Function Cont.
- The SUBTOTAL() Function
Microsoft Excel Data Validation
- What is Excel Data Validation?
- Creating a Drop Down List with Data Validation
- Different Types of Excel Data Validation
- Adding Custom Alerts to Data Validation
- Creating a Dynamic Drop Down List
Microsoft Excel PivotTables
- Creating an Excel Pivot Table
- Modifying Excel PivotTables
- Grouping & Filtering PivotTable Data
- Drilling Down into PivotTable Data
Microsoft Excel's PowerPivot Add-In
- What is PowerPivot?
- Activating the Excel PowerPivot Add-In
- Creating Relationships between Data Tables
Microsoft Excel's Conditional Functions
- Excel’s IF() Function
- IF() Function with AND() Criteria
- IF() Function with OR() Criteria
Microsoft Excel's Lookup Functions
- VLOOKUP() Function
- The Beauty of Excel’s IFERROR() Function
- HLOOKUP() Function
Text Based Functions in Microsoft Excel
- LEFT(), RIGHT() and MID() Function
- Extracting Specific Text using LEN() & SEARCH()
- Combining Text with CONCATENATE()
Auditing Formulas & Custom Views in Microsoft Excel
- Tracing Precedents & Dependents in Formulas
- Showing Formulas
- Grouping Data
Microsoft Excel’s “What If?” Tools
- Excel’s Scenario Manager Tool
- Goal Seek in Excel
- Compare Results with Excel Data Tables
Welcome to Microsoft Excel VBA!
- The Power Behind Excel VBA
- A Look Inside the Visual Basic Editor (VBE)
- Recording a Macro
The VBA Language
- Modules and Procedures
- Objects, Methods and Properties
- Excel VBA Variables
Writing VBA Code
- Referencing a Range
- InputBox & MsgBox
- Using Variables in VBA Code
Important VBA Tools and Logic
- Find Last Row of Data
- Find Last Column of Data
- With Statement
Excel VBA Loops
- For Next Loop
- Do Until Loop
- For Each Loop
Triggering Macros
- Assigning Macros to Shapes
- Form Controls vs ActiveX Controls
- Worksheet Events
Microsoft Excel User Forms
- Creating an Excel User Form
- Adding Controls to User Forms
- How to Show an User Form
- Passing Text Box Values to Desired Cells
Starting a Career in Microsoft Excel
- Creating an Excel Resume
- Getting Started with Freelancing
- How to Become an Excel Freelancer
- Top Freelance Websites
- How to Get Your First Client
- Personal Branding
- Networking Do’s and Don’ts
- Importance of Having a Website
Certificates
Course Central is proud to offer a Certificate of Completion to all who complete courses successfully. Course Central tracks the learner’s course progress. However, the learner is responsible for validating the completion and understanding of the course. All Certificates of Completion can be validated from the Course Central website using the validation code.
Transcripts
A Transcript for the course with completed module details can be requested for as little as £4.99. Please note that all course Certificates and Transcripts will be titled as published on the Course Central platform.
