Excel Formulas: Basic
CLASS DATE(s):
7/27/2020
8/3/2020
9/3/2020
10/19/2020

COURSE LENGTH: 1 Day

COURSE COST: $295.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

Learn how to use formulas to do basic math in Excel, how to make formula results update automatically, and how to use predefined formulas called functions that do things like calculate the amount of monthly payments. Learn how to use functions in your formula's. You'll explore specific types of formulas that can help you on multiple levels, such as financial and array formulas.

You'll learn how to apply formulas to charts and pivot tables, troubleshoot your formulas, develop custom functions, and much more.

AUDIENCE AND PREREQUISITES

Anyone who is familiar with the basics of Excel, but would like to expand their knowledge.

Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:
Accountants
Clerical, Office professionals
Consultants
Executives/Managers
Help desk personnel
Instructors/Trainers
Program/Project Managers
Sales
Students
Other members of the general population
Charting
Create analytical, financial, etc. reports
Data entry
Family budget
Format numerical (financial, statistical, etc.) reports
Forms
Graphing
Process data
Reporting
Technical support
Trending
Familiarity with Excel basics.

  

*Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course subject to minimum enrollment.

COURSE TOPICS:


Part I Basic Information
Excel in a Nutshell
Basic Facts about Formulas
Working with Names

Part II Using Functions in Your Formulas
Introducing Worksheet Functions
Manipulating Text
Working with Dates and Times
Counting and Summing Techniques
Using Lookup Functions
Tables and Worksheet Databases
Miscellaneous Calculations

Part III Financial Formulas
Borrowing and Investing Formulas
Discounting and Depreciation Formulas
Financial Schedules

Part IV Array Formulas
Introducing Arrays
Performing Magic with Array Formulas

Part V Miscellaneous Formula Techniques
Intentional Circular
Charting Techniques
Pivot Tables
Conditional Formatting & Data Validation
Creating Megaformulas
Tools and Methods for Debugging Formulas

Part VI Developing Custom Worksheet Functions
Introducing VBA
Function Procedure Basic
VBA Programming Concepts
VBA Custom Function Examples