Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Excel Essential Formulas & Functions
(
2.5 hrs
)
This hands-on, intensive course will teach you the fundamentals of working with formulas and functions in Excel. You'll learn what to do, and what not to do, when creating your own formulas. You'll discover many of the "bread 'n butter" functions that business professionals use on a daily basis. You'll discover shortcuts, and tips and tricks that will take your productivity to a new level. Plus, you'll gain the competence you need to be confident when working with Excel spreadsheets. Take this course today to start building your professional skills!
Performance-Based Objectives
The difference between formulas and functions
How to write your own formulas
Handy tip for checking your work
Follow the rules of math: PEMDAS
Enter Excel functions using the category menu, or typing them in directly
SUM, AVERAGE, MAX, MIN, COUNT, IF
Shortcuts to entering formulas
Get Help
Next Steps
Course Outline*
Module 1: Introduction
How to Enter Formulas
How to Enter Functions
The Difference Between Formulas and Functions
Edit Formulas the "safe" way
When to use each
Module 4: Essential Tips & Tricks
Keyboard shortcut for AutoSum
Instantly add calculations to all of your columns at once
Shortcuts to copying formulas & functions
Module 2: Follow the Math Rules
Use the algebraic rules of operation (PEMDAS)
Check your work
Use Numbers and Cell References in formulas and functions
Check your work
Module 5: Absolute References
What is an absolute reference?
Use absolute references to streamline your spreadsheets
Add an Absolute Reference from the keyboard
Module 3: Essential Functions
SUM
AVERAGE
COUNT
COUNTA
MIN
MAX
LARGE
SMALL
Module 6: Make a Budget
Enter data for a Budget
Add totals and replicate many months instantly
Create a Pie Chart to see where your money is going
Register
Dates Offered
Email
Print Friendly
Show All
*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.
Dates Offered
Email Me
this Outline
Print Friendly
Version
Tuition
Live, In-Person:
$147.00
Live, Webinar:
$147.00
Special Features:
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips