Microsoft Excel

Excel definition: a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.

​

Excel is typically used to organize data and perform financial analysis.  It is used across all business functions and at companies from small to large.

The main that I teach in my Excel Classes include:

• Saving a Workbook Properly

• Saving in Different Versions

• Name – Rename – Move a Worksheet

• Quick Access Toolbar

• Three Ways in Edit Mode

• AutoCorrect Options

• Fill Color Certain Cells

• Aligning Text and Numbers

• AutoSum * MAX * MIN* AVERAGE

• Using the Handler to Calculate

• Adding Cells at Random

• Task Bar Checking Totals

• Freeze Panes

• Select All to Copy Worksheet

• Find and Replace

• Name a Range

• Titles at Top Multiple Sheets

• Creating a Chart

• Inserting a Hyperlink

• Inserting a Comment

• Setting Filters

• Format Cells

• Filters More Finite

• Hide a Column Properly

• Insert Header of Footer

• Move Data

• Sort Alphabetically

• Using the Range to Calculate

• Using the “Go To” Feature

• Inserting Symbols

• Rename and Color Code Tabs

• Create a Formula Manually

• Splitting the Panes

• Fill Series

• Absolute Reference

• IF Functions

• Commands Using the “Ctrl” button

• Adding Totals Between Two Workbooks

• Print Gridlines or Not

• Format a Table of Data

• Paste Special

• Trace the Dependents and Precedents

• Wrapping the Text

• Set Printing to Landscape Orientation

• ZOOM Mode to Enlarge Font

• Set Print Area to Print

• Build a Macro

• Track Changes That are Made

• Wrap Text

• Flash Fill for the Names

• Speak Cells

• Count Names of Employees

• Cumulative Sum

• SUMIF Conditional Formula

• SUMIFS Certain Criteria

• SUMIFS Multiple Criteria

• SUMIFS Negative Values

• XLOOKUP

• Circular Reference

• Array Formula

• Array Formula for Percent

• Multiple Criteria Formula

• Counting Formulas

• Counting Differences in Range

• Calculate Workdays (Network)

• Time Sheet

• Conditional SUMS

• Array SUM with Errors

• Array that Finds all Errors in Range

• Array Summary of Largest in Range

• Array that would Add the Largest

• Average Excluding Zeros

• Array Finds Difference in 2 Ranges

• Array to Find Value in Range

• Array to Find Location of MAX data

• Array to Find Round Totals

• Calculating Total Wages Array

• Copy and Paste in One Step

• Adding Background to Worksheet

• Cell Address Find

• Table Totals One Click

• Separate First, Middle, Last Name

• Counting Different Criteria

• Pivot Tables

• Pivot Tables Different Criteria

• Conditional Formatting

• Formula to Calculate Grades

• Charts Using Pie Charts

• Charts Using Stock Charts

• Conditional Formatting

• Creating a Custom Style

• Password Protection

• Edit Formulas in Formula Bar

The Excel software program includes many functions, formulas, and shortcuts that can be used to enhance its functionality.

​

Excel is a very powerful and yet simple Application to learn! Once you do take our Class and have access to our "Micro Training Videos" it will become second nature!