We offer classes for beginning, intermediate and advanced Excel users.
The class described below is the most common and ends up with an introduction to macros and writing code.
The objective of this course is to optimize an employee’s average eight-hour day. An employee with less monotonous tasking is not only a more productive employee but a more challenged employee than one who is consistently performing the same motions each day. The computer and its applications are a resource to task, another entity to delegate. The employee and senior leadership alike can then focus on more meaningful contributions to a company. Analyzing data and predicting trends provides better information for decision makers to propel a company.
The course provides a level of knowledge that allows an individual or company employee to store information and report on it without having to lookup definitions or to discover the best way to accomplish a task. The goal is for the student to review a task, ask the right questions and provide a basic solution. From here, the student will be able to discover simple solutions to complex challenges.
If the students have a project from their work or personal business, they are encouraged to bring it to class and the instruction can be built around their project. If not, the students will build out a rudimentary inventory system from scratch that will utilize most of the common functionality of Excel. Learning the common functionality will provide the student with the ability to create any other type of system centered around information important to any business.
The course is given over a 24-hour period with the most common arrangements being either three consecutive eight-hour days or four consecutive six-hour days. We can also accommodate other customer schedules in breaking up the 24-hour period. Breaks within the day are issued between topics or as agreed upon by the class.
Understand how Excel is organized; how it relates to other Office products; how it relates to other databases
Use groups of data rather than individual cells when the opportunity presents itself
Organize data within a workbook, worksheet, table and range
Develop macros used to define functions not currently part of Excel
Discover answers to tasks to be accomplished
Connect with outside data sources
Understand the pros and cons of tables
Use the most common Excel functions, learning how to search for all other
Use the most common Excel functions, learning how to search for all other functions, creating functions from scratch
Lesson I : Understanding Excel Objects
Data Tables, Pivot Tables, Charts
Functions, Formulas. Menu Items
Lesson II : Understanding Data and how to organize it
Link Data tables – use Vlookups/Match-Index
Create Setup Tables (dropdowns) – use precise lists making for accurate reports
Clean/Scrub Data – remove or replace data inconsistent with the main body
Lesson III : Ensuring User inputs valid information
Lesson IV : Shortcuts and Maneuvering
Insert/delete columns, cells, ranges
Paste Special, Transpose
Lesson V : Most Important Excel Functions, Functionality
Creating test data
Text to Columns
Lesson VI : Accessibility
Hide worksheets, ‘Very Hide’ worksheets
Lesson VII : Importing/Exporting information from other sources
Export to SharePoint list
Lesson VIII : Connecting to information outside current workbook
Connecting to other workbooks
Connecting to Access
Connecting to SQL server
Lesson IX : Database Management
Lesson X : Appearance
Removing rows, columns, grid-lines
Lesson XI : Printing
Lesson XII : Automation
Automatic pivot tables/charts refresh
Select from listbox
Create Buttons to run code
During the course, the student will be periodically tested before moving on to the next lesson to ensure the student understands what has been taught. A quiz of what was taught in the lesson will be given and graded on the spot.