About This Course
Course Curriculum
-
Excel from A-Z Course Intro00:03:00
-
Excel Job Opportunities00:03:00
-
Excel Job Types00:04:00
-
Microsoft Excel Marketplace00:04:00
-
What is Microsoft Excel?00:04:00
-
Who is This Course For?00:03:00
-
Finding & Opening Excel00:01:00
-
Excel’s Start Screen00:03:00
-
Explaining the Excel Interface00:03:00
-
Excel Interface Continued00:01:00
-
Excel Workbook vs. Excel Worksheet00:02:00
-
Saving an Excel Document00:04:00
-
Customizing the Quick Access Toolbar00:02:00
-
Customizing the Excel Ribbon00:03:00
-
Excel Shortcut Keys00:02:00
-
Creating Excel Labels00:03:00
-
Entering Numeric Values in Excel00:03:00
-
Formatting Date Values in Excel00:05:00
-
Building Basic Formulas in Excel00:05:00
-
Order of Operations00:06:00
-
Relative vs. Absolute Cell References00:07:00
-
Excel Functions Explained00:03:00
-
The SUM() Function00:08:00
-
The MIN() & MAX() Function00:04:00
-
The AVERAGE() Function00:02:00
-
COUNT() Functions00:05:00
-
Moving & Copying Data00:07:00
-
Insert & Delete Rows and Columns00:05:00
-
Adjusting the Width and Height of Cells00:05:00
-
Hiding and Unhiding Excel Rows and Columns00:04:00
-
Renaming, Moving & Deleting Excel Worksheets00:05:00
-
Adding Protection to Specific Cells00:04:00
-
Protecting the Structure of a Workbook00:02:00
-
Adding a Workbook Password to Open File00:02:00
-
Formatting Fonts and Cell Background Color00:05:00
-
Adding Cell Borders00:05:00
-
Formatting Data Appropriately00:05:00
-
The Magic behind Excel’s Format Painter00:03:00
-
Creating Styles for Formatting Efficiency00:06:00
-
Merging Cells for a Cleaner Look00:03:00
-
The Power of Conditional Formatting00:06:00
-
Grab User’s Attention using Illustrations00:09:00
-
Customizing Icons00:05:00
-
Create Compelling Graphics with SmartArt00:06:00
-
The Commonly Used Column Chart00:03:00
-
Changing the Chart Design.mp400:02:00
-
Formatting Elements of a Chart00:06:00
-
Modifying the Data, Type & Location of a Chart00:06:00
-
Print Preview Options00:04:00
-
Excel’s Page Layout View00:07:00
-
Printing a Specific Range of Cells00:03:00
-
Converting Spreadsheets to PDF Files00:02:00
-
Why Create an Excel Template00:01:00
-
How to Create an Excel Template00:05:00
-
How to Prepare Data for Analysis00:04:00
-
How to Sort Data in Excel00:03:00
-
Multi-Level Sorting00:03:00
-
Custom Sorting Datasets in Excel00:02:00
-
Applying Filters to Datasets00:05:00
-
Creating Subtotals within a Dataset00:06:00
-
Converting Datasets into Tables00:06:00
-
Little Slice of Pie Charts00:05:00
-
Finding & Removing Duplicate Values00:07:00
-
The SUMIF() Function00:09:00
-
The DSUM() Function00:08:00
-
The DSUM() Function Cont.00:07:00
-
The SUBTOTAL() Function00:06:00
-
What is Excel Data Validation?00:02:00
-
Creating a Drop Down List with Data Validation00:07:00
-
Different Types of Excel Data Validation00:06:00
-
Adding Custom Alerts to Data Validation00:07:00
-
Creating a Dynamic Drop Down List00:03:00
-
Complex Validation: Dependent Drop Down List!00:09:00
-
Creating an Excel Pivot Table00:06:00
-
Modifying Excel PivotTables00:06:00
-
Grouping & Filtering PivotTable Data00:06:00
-
Drilling Down into PivotTable Data00:02:00
-
Creating Pivot Charts & Utilizing Slicers00:08:00
-
What is PowerPivot?00:04:00
-
Activating the Excel PowerPivot Add-In00:02:00
-
Creating Relationships between Data Tables.mp400:06:00
-
Using Data Models to Create PivotTables00:05:00
-
How to Create PowerPivot KPI’s00:08:00
-
Excels IF Function00:05:00
-
IF() Function with AND() Criteria00:05:00
-
IF() Function with OR() Criteria00:05:00
-
Nesting Multiple IF() Functions00:07:00
-
The COUNTIF() Function00:04:00
-
Key Benefits of Named Ranges00:04:00
-
VLOOKUP() Function00:09:00
-
The Beauty of Excel’s IFERROR() Function00:04:00
-
HLOOKUP() Function00:06:00
-
The INDEX Function00:05:00
-
MATCH() Function00:05:00
-
INDEX() and MATCH() Combined00:05:00
-
Two-Way Lookup with INDEX() and MATCH()00:04:00
-
LEFT(), RIGHT() and MID() Function00:07:00
-
Extracting Specific Text using LEN() & SEARCH()00:13:00
-
Combining Text with CONCATENATE()00:06:00
-
Quick Tips & Other Text Based Functions00:06:00
-
Tracing Precedents & Dependents in Formulas00:04:00
-
Showing Formulas00:02:00
-
Grouping Data00:03:00
-
3D Referencing in Formulas00:05:00
-
Utilizing the Watch Window in Excel00:03:00
-
How to Freeze Panes in Excel00:03:00
-
Excel’s Scenario Manager Tool00:06:00
-
Goal Seek in Excel00:06:00
-
Compare Results with Excel Data Tables00:04:00
-
Solver Tool00:11:00
-
The Power Behind Excel VBA00:03:00
-
A Look Inside the Visual Basic Editor (VBE)00:04:00
-
Recording a Macro00:09:00
-
Saving & Opening a Macro-Enabled Workbook00:02:00
-
Modules and Procedures00:07:00
-
Objects, Methods and Properties00:06:00
-
Excel VBA Variables00:05:00
-
Referencing a Range00:13:00
-
InputBox & MsgBox00:06:00
-
Using Variables in VBA Code00:05:00
-
If Then Else Statement00:10:00
-
Worksheet Functions inside VBA00:08:00
-
Creating User Defined Functions00:09:00
-
User Defined Functions within VBA Scripts00:06:00
-
Find Last Row of Data00:06:00
-
Find Last Column of Data00:03:00
-
With Statement00:05:00
-
Debugging & Error Handling00:07:00
-
Debugging & Error Handling Cont.00:07:00
-
For Next Loop00:09:00
-
Do Until Loop00:06:00
-
For Each Loop00:04:00
-
Assigning Macros to Shapes00:04:00
-
Form Controls vs ActiveX Controls00:08:00
-
Worksheet Events00:04:00
-
Workbook Events00:03:00
-
Fun with VBA Events!00:07:00
-
Creating an Excel UserForm00:03:00
-
Adding Controls to UserForms00:10:00
-
How to Show an UserForm00:03:00
-
Passing TextBox Values to Desired Cells00:07:00
-
Passing Option Buttons to Desired Cells00:07:00
-
UserForm ComboBoxes00:08:00
-
Clearing Values from UserForm Controls00:03:00
-
How to Close an UserForm00:02:00
-
UserForms and Protected Sheets00:05:00
-
Creating an Excel Resume00:05:00
-
Getting Started with Freelancing00:06:00
-
How to Become an Excel Freelancer00:05:00
-
Top Freelance Websites00:05:00
-
How to Get Your First Client00:08:00
-
Personal Branding00:07:00
-
Networking Do’s and Don’ts00:04:00
-
Importance of Having a Website00:04:00
-
Resources – Advanced Diploma in Microsoft Excel
-
Assignment – Advanced Diploma in Microsoft Excel03:12:00
-
Order Your Certificate