Microsoft Excel
Microsoft Excel is the backbone of many offices, but too many users have never learned how to do more than enter data. Get up and running quickly with quick navigation tips and learn formulas beyond AutoSum. Attendees will learn how to build a better picture of their data and gain insights into it.
Microsoft Excel – Behind the Spreadsheet (Level 1)
Peek behind the spreadsheet and learn Microsoft Excel the right way. Because so many adult learners are self-taught, there are often basic skills that we fail to pick up. This class assumes you have opened the program, but aren’t secure that you know all the basics.
Some of the topics covered include:
- Understanding the Ribbon
- Keyboard Shortcuts
- How to Personalize your Workspace
- Creating New Documents from Scratch and from a Template
- Saving Documents
- New Printing Techniques
- Printing Titles
- Navigating a Worksheet
- Simple Formatting
- Auto Fill and Flash Fill
- Formulas and Functions (Introductory)
- Orders of Operation and Cell Addressing
- Cut, Copy and Paste Techniques
- Managing Worksheets
- Hiding and Freezing Worksheets
- Spell Check
Microsoft Excel – Excel Formulas and Functions (Level 2)
Formulas and Functions are the meat and potatoes of Microsoft Excel. They are the tools that give the program power to achieve our goals. We’ll review the basics of Formulas and Functions in this class before diving headlong into more advanced Functions. This class also takes a look at special techniques for writing formulas and formula auditing tools.
Some of the topics covered include:
- Keyboard Shortcuts
- Review of Orders of Operation
- Relative Cell References
- Absolute Cell References
- Effects of AutoFill and Copying/Pasting Formulas
- Writing Simple Formulas
- Writing Complex Formulas
- Cross-Worksheet Formulas
- 3-D Formulas (across workbooks)
- The Function Insertion Button
- The Function Library
- Using Simple Functions
- Using Compound Functions
- Auto Calculation and Manual Calculation
- Displaying and Tracing Formulas
- Error Messages and What They Mean
- Using the Error Checker
- Using the Watch Window
- Creating your own Functions
Microsoft Excel – Visual Communication (Level 3)
Collecting data and storing it is just one part of the Microsoft Excel toolkit. In fact, all those columns of numbers wouldn’t be worth much if we couldn’t communicate them to other people. This class will explore the impressive array of tools built in to the program that will help you get your message across.
Some of the topics covered include:
- Column, Row and Cell Sizing
- Merging Cells
- Conditional Formatting
- Cell Styles
- Document Themes
- Sorting (Simple and Complex)
- Filtering
- Advanced Filters
- Creating Tables
- Table Styles
- Total Row and Table Formatting
- Table Design Tab
- Slicers for Tables
- Creating and Using Custom Lists
- AutoFill a Custom List
- Creating Charts
- Data Selection for Charts
- Editing Chart Data
- Resizing a Chart
- Chart Layouts
- Chart Scales
- Changing Chart Type
- Sparklines
Microsoft Excel- Data Analysis (Level 4)
Now that you’ve got all of that information, what are you going to do with it? Senior managers and entry-level personnel all benefit from taking this class, where you’ll learn the ins and outs of Pivot Tables and Charts, as well as how to import data from databases.
Some of the topics covered include:
- Creating Pivot Tables
- Changing Pivot Table Data
- Filtering and Sorting with Pivot Tables
- Grouping Data
- Slicers
- Pivot Table Layout
- Creating Pivot Charts
- Scenarios and Goal Seek
- The Solver Add In
- Cleaning up Data
- Hyperlinks
- Importing Data
- Data Connections
Microsoft Excel – Macros (Level 5)
Long thought to be the province of supergeeks, macros will come alive in this exciting class. You will learn how to record macros, be introduced to the Visual Basic programming language, and write simple code statements
Some of the topics covered include:
- The Developer tab on the Ribbon
- Recording Macros
- Playing back Macros with Keystrokes
- Adding Macros to the Quick Access Toolbar
- Attaching Macros to Buttons
- How Cell References operate in Macros
- Where does the Macro Live?
- Macro-enabled File Formats
- Exploring the VBA Editor
- VBA Modules
- Methods to build Complex Macros
- Variables and Remarks
- If… Then… Loops
- Do While… Loops
- Controlling the Computer with Macros