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