Kilroy's College

Kilroy's College

Online & Home Study Courses

Microsoft Excel course

Course Contents

Remember, you can complete this Microsoft Excel course within 12 months of enrolling. So take your first step by contacting us today !

VBA Examples


Detailed Content

Introducing Excel

  • Identifying What Excel Is Good For
  • Seeing What's New in Excel
  • Understanding Workbooks and Worksheets
  • Moving Around a Worksheet
  • Using the Ribbon
  • Using Shortcut Menus
  • Customizing Your Quick Access Toolbar
  • Working with Dialog Boxes
  • Using Task Panes

Back to top >>


Entering and Editing Worksheet Data

  • Exploring Data Types
  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting

Back to top >>


Essential Worksheet Operations

  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns

Back to top >>


Working with Cells and Ranges

  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells

Back to top >>


Introducing Tables

  • What Is a Table?
  • Creating a Table
  • Changing the Look of a Table
  • Working with Tables

Back to top >>


Worksheet Formatting

  • Getting to Know the Formatting Tools
  • Using Different Fonts to Format Your Worksheet
  • Changing Text Alignment
  • Using Colors and Shading
  • Adding Borders and Lines
  • Adding a Background Image to a Worksheet
  • Using Named Styles for Easier Formatting
  • Understanding Document Themes

Back to top >>


Understanding Excel Files

  • Creating a New Workbook
  • Opening an Existing Workbook
  • Saving a Workbook
  • Using AutoRecover
  • Password-Protecting a Workbook
  • Organizing Your Files
  • Other Workbook Info Options
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility

Back to top >>


Using and Creating Templates

  • Exploring Excel Templates
  • Understanding Custom Excel Templates

Back to top >>


Printing Your Work

  • Basic Printing
  • Changing Your Page View
  • Adjusting Common Page Setup Settings
  • Adding a Header or Footer to Your Reports
  • Copying Page Setup Settings across Sheets
  • Preventing Certain Cells from Being Printed
  • Preventing Objects from Being Printed
  • Creating Custom Views of Your Worksheet

Back to top >>


Introducing Formulas and Functions

  • Understanding Formula Basics
  • Entering Formulas into Your Worksheets
  • Editing Formulas
  • Using Cell References in Formulas
  • Using Formulas in Tables
  • Correcting Common Formula Errors
  • Using Advanced Naming Techniques
  • Working with Formulas

Back to top >>


Creating Formulas That Manipulate Text

  • A Few Words about Text
  • Text Functions
  • Advanced Text Formulas

Back to top >>


Working with Dates and Times

  • How Excel Handles Dates and Times
  • Date-Related Worksheet Functions
  • Time-Related Functions

Back to top >>


Creating Formulas That Count and Sum

  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Advanced Counting Formulas
  • Summing Formulas
  • Conditional Sums Using a Single Criterion
  • Conditional Sums Using Multiple Criteria

Back to top >>


Creating Formulas That Look Up Values

  • Introducing Lookup Formulas
  • Functions Relevant to Lookups
  • Basic Lookup Formulas
  • Specialized Lookup Formulas

Back to top >>


Creating Formulas for Financial Applications

  • The Time Value of Money
  • Loan Calculations
  • Investment Calculations
  • Depreciation Calculations

Back to top >>


Miscellaneous Calculations

  • Unit Conversions
  • Solving Right Triangles
  • Area, Surface, Circumference, and Volume Calculations
  • Rounding Numbers

Back to top >>


Introducing Array Formulas

  • Understanding Array Formulas
  • Creating an Array Constant
  • Understanding the Dimensions of an Array
  • Naming Array Constants
  • Working with Array Formulas
  • Using Multicell Array Formulas
  • Using Single-Cell Array Formulas

Back to top >>


Performing Magic with Array Formulas

  • Working with Single-Cell Array Formulas
  • Working with Multicell Array Formulas

Back to top >>


Getting Started Making Charts

  • What Is a Chart?
  • Understanding How Excel Handles Charts
  • Creating a Chart
  • Hands On: Creating and Customizing a Chart
  • Working with Charts
  • Understanding Chart Types
  • Learning More

Back to top >>


Learning Advanced Charting

  • Selecting Chart Elements
  • User Interface Choices for Modifying Chart Elements
  • Modifying the Chart Area
  • Modifying the Plot Area
  • Working with Titles in a Chart
  • Working with a Legend
  • Working with Gridlines
  • Modifying the Axes
  • Working with Data Series
  • Creating Chart Templates
  • Learning Some Chart-Making Tricks

Back to top >>


Visualizing Data Using Conditional Formatting

  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Conditional Formats That Use Graphics
  • Creating Formula-Based Rules
  • Working with Conditional Formats

Back to top >>


Creating Sparkline Graphics

  • Sparkline Types
  • Creating Sparklines
  • Customizing Sparklines
  • Specifying a Date Axis
  • Auto-Updating Sparklines
  • Displaying a Sparkline for a Dynamic Range

Back to top >>


Enhancing Your Work with Pictures and Drawings

  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Using the Equation Editor

Back to top >>


Customizing the Excel User Interface

  • Customizing the Quick Access Toolbar
  • Customizing the Ribbon

Back to top >>


Using Custom Number Formats

  • About Number Formatting
  • Creating a Custom Number Format
  • Custom Number Format Examples

Back to top >>


Using Data Validation

  • About Data Validation
  • Specifying Validation Criteria
  • Types of ValidationCriteria You Can Apply
  • Creating a Drop-Down List
  • Using Formulas for Data Validation Rules
  • Understanding Cell References
  • Data Validation Formula Examples

Back to top >>


Creating and Using Worksheet Outlines

  • Introducing Worksheet Outlines
  • Creating an Outline
  • Working with Outlines

Back to top >>


Linking and Consolidating Worksheets

  • Linking Workbooks
  • Creating External Reference Formulas
  • Working with External Reference Formulas
  • Avoiding Potential Problems with External Reference Formulas
  • Consolidating Worksheets

Back to top >>


Excel and the Internet

  • Saving a Workbook on the Internet
  • Saving Workbooks in HTML Format
  • Opening an HTML File
  • Working with Hyperlinks
  • Using Web Queries
  • E-Mail Features

Back to top >>


Protecting Your Work

  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • VB Project Protection
  • Related Topics

Back to top >>


Making Your Worksheets Error Free

  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect

Back to top >>


Importing and Cleaning Data

  • Importing Data
  • Data Clean-up Techniques
  • A Data Cleaning Checklist
  • Exporting Data

Back to top >>


Introducing Pivot Tables

  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Learning More

Back to top >>


Analyzing Data with Pivot Tables

  • Working with Non-Numeric Data
  • Grouping Pivot Table Items
  • Creating a Frequency Distribution
  • Creating a Calculated Field or Calculated Item
  • Filtering Pivot Tables with Slicers
  • Filtering Pivot Tables with a Timeline
  • Referencing Cells within a Pivot Table
  • Creating Pivot Charts
  • Another Pivot Table Example
  • Producing a Report with a Pivot Table
  • Using the Data Model
  • Learning More about Pivot Tables

Back to top >>


Performing Spreadsheet What-If Analysis

  • A What-If Example
  • Types of What-If Analyses

Back to top >>


Analyzing Data Using Goal Seeking and Solver

  • What-If Analysis, in Reverse
  • Single-Cell Goal Seeking
  • Introducing Solver
  • Solver Examples

Back to top >>


Analyzing Data with the Analysis ToolPak

  • The Analysis ToolPak: An Overview
  • Installing the Analysis ToolPak Add-in
  • Using the Analysis Tools
  • Introducing the Analysis ToolPak Tools

Back to top >>


Introducing Visual Basic for Applications

  • Introducing VBA Macros
  • Displaying the Developer Tab
  • About Macro Security
  • Saving Workbooks That Contain Macros
  • Two Types of VBA Macros
  • Creating VBA Macros

Back to top >>


Creating Custom Worksheet Functions

  • Overview of VBA Functions
  • An Introductory Example
  • About Function Procedures
  • Executing Function Procedures
  • Function Procedure Arguments
  • Debugging Custom Functions
  • Inserting Custom Functions

Back to top >>


Creating UserForms

  • Why Create UserForms?
  • UserForm Alternatives
  • Creating UserForms: An Overview
  • A UserForm Example
  • Another UserForm Example
  • More on Creating UserForms

Back to top >>


Using UserForm Controls in a Worksheet

  • Why Use Controls on a Worksheet?
  • Using Controls
  • Reviewing the Available ActiveX Controls

Back to top >>


Working with Excel Events

  • Understanding Events
  • Entering Event-Handler VBA Code
  • Using Workbook-Level Events
  • Working with Worksheet Events
  • Using Non-Object Events

Back to top >>


VBA Examples

  • Working with Ranges
  • Working with Workbooks
  • Working with Charts
  • VBA Speed Tips

Back to top >>


Creating Custom Excel Add-Ins

  • What Is an Add-In?
  • Working with Add-Ins
  • Why Create Add-Ins?
  • Creating Add-Ins
  • An Add-In Example

Back to top >>



Get a FREE Microsoft Excel brochure