|
Excel formulas and functions are essential to using the program to its fullest potential. Every Excel class we offer covers some formulas and functions, but for specific training in this topic we recommend our Formulas & Functions class.
- Excel Basic
In Excel Basic, we introduce basic formulas and functions for users who have never or rarely used this feature.
- Subtraction, division, multiplication formulas
- Cell references
- Manually typing functions
- AutoSum and AutoCalculate
- Excel Intermediate
In the Intermediate class we review simple formulas and functions, then cover additional commonly used formulas
- Typing formulas and functions
- Cell references and reference formulas
- AutoSum
- The Functions Library
- Average, Date & Time functions
- If statements
- 3D references
- Showing Formulas and references
- Tracing Precedents and dependents
- Excel Advanced
Our Advanced Excel class Introduces complex formulas.
- Viewing available Excel functions
- Basic text functions
- Basic “IF”conditional formulas
- Nestings “IF” statements
- Concatenate and “IF” statements
- Arrays
- Using name ranges in formulas
- Lookups and Lookup functions
- HLookup
- VLookup
- Excel Formulas & Functions
We’ve designed this class specifically for users needing to learn more about formulas and Functions.
- Formula and Function Structures
- Formulas with Multiple Calculations
- 3-D Formulas
- Static Cell References
- Copying Formulas and Filling a series
- Number formatting
- Date & Time Functions
- Nesting IF statements
- Working with Time and IF Statements
- Ensuring dates don’t fall on weekends
- And & Blank functions
- Text Functions
- V & H Lookups
- Mathematical: Round up and Sum IF functions
- Statistical: Average & Mode functions
- Conditional Formatting formulas
- Managing Databases
Our Managing Databases class discusses formulas and functions that are useful when working with large amounts of data.
- Financial Functions and Data Tables
- Database Functions
- Reference Functions
For specific questions about Excel formulas and functions, a private virtual 1on1 class may be the best approach. Please contact us with any questions or for a recommendation.
|
|
|
