Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Excel 2016 7 Essential Excel Formulas You Must Know to Be Productive
(
0.5 days
)
You may have been using Excel for a while, but have you discovered the sheer power available to you for saving time, eliminating errors, and simply getting things done? We've taken the absolute best functions from all of our courses and stuffed them into this jam-packed 3-hour session sure to take your Excel skills to new heights! You'll learn 7 of the most potent, sought-after and amazing functions Excel has to offer, as well as a smattering of some of the very best shortcuts we know for streamlining your workflow! If you're ready to unlock the potential of the mighty beast, sign up for this amazing course and become the guru you always knew you could be!
Performance-Based Objectives
Discover the incredible power of Absolute References
Expand your formula creation abilities with Named Ranges
Build Artificial Intelligence into your spreadsheets with the amazing IF function
Use VLOOKUP to instantly cross-reference values in other spreadsheets and eliminate errors
Discover the IFERROR formula and how to use it to catch problems before they start
Expand your understanding of Date/Time calculations
Use the power of the PMT function to create your own loan repayment calculator
Plus much more! See the outline below for complete details.
Course Outline*
Module 1: The Amazing Power of Absolute References & Named Ranges
Discover the difference between Absolute and Relative References
Use Absolute References to simplify your spreadsheets and give you greater control
Use Named Ranges to use friendly names in formulas
Module 5: Create a Loan Calculator: PMT
Create a custom loan calculator using PMT function
Calculate Interest paid, total paid, and use custom values in your calculator
Module 2: Build Artificial Intelligence into your Spreadsheets: IF
Use the IF function to make decisions for you
Discover the power of compound criteria and compound result IF statements, and how to create them
Leverage the IF function to give both textual and numeric results
Module 6: Add numbers only if they meet criteria: SUMIF
Discover the SUMIF function and how to use it to simplify data summation efforts
Use the COUNTIF function to ease counting in large data sets
Module 3: Find Errors Before they start: ISERROR
Harness the incredible and easy power of IFERROR to catch mistakes
Make your spreadsheets "bulletproof" and more user-friendly!
Module 7: Use Database Functions to Extract Easily Customizable Metrics
Learn about database functions and how flexible they are
Use database functions to extract metrics based on criteria you specify
Module 4: Understanding the Intricacies of Date & Time Functions
Discover the backbone of Date functions and how to use them
Use 2 functions to automatically generate the Date, or the Date and Time on your spreadsheets
Perform easy calculations using Date and Time functions to determine time intervals
Module 8: Incredible Cross-Referencing with VLOOKUP
Harness the power of VLOOKUP to instantly retrieve values from other parts of your spreadsheets
Eliminate the most common causes of errors with VLOOKUP
Learn about HLOOKUP
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:
$0.00
Live, Webinar:
$0.00
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips