Microsoft Excel Power Functions Seminar
Excel training Customized to Focus on the Functions You Use
We know you don’t need to know or use all 250 plus Excel functions. So, this Excel training is customized to focus on the functions that help you the most.
Microsoft Excel has over 250 functions and many are never used even by Excel professionals. Many of these overlooked functions are powerful time-savers and frequently eliminate the need for complex macros and other techniques. The key is to learn to use the Excel functions that make you most effective.
Don’t overlook the many valuable functions Excel users often miss.
This training is customized to include topics of special concern to your group, department, division or organization. We can even adapt this course to incorporate your data files.
This seminar explores many different functions and associated commands and techniques - all with examples. The course is tailored to the version of Excel you are using.
Who Should Attend
Anyone who could save time and improve efficiency by learning overlooked functions in Excel.
Overview of Concepts and Deliverables Provided
IF, VLOOKUP; other table functions
- Advanced uses of the IF Function – nested IFs, compound IFs with AND and OR
- VLOOKUP – lets you look up information in tables in current or other worksheets
- MATCH – locate data by row
- INDEX – retrieve by location
- Using MATCH and INDEX together
- Range names - create and use with formulas and functions
- Absolute, Relative and Mixed references
Math Functions
- Rounding Functions – change calculations
- ROUND, ROUNDUP, ROUNDDOWN, INT, CEILING, FLOOR, MROUND, TRUNC
- ODD and EVEN – adjust to nearest odd or even value
- FACT – factorial; MOD – find remainder
- RAND and RANDBETWEEN – random number generators
Statistical Functions
- MEDIAN – find the middle value
- RANK – rank data without sorting
- LARGE – find 2nd, 3rd, 4th, etc. largest
- COUNTBLANK – tabulate blank cells
Array Functions
- FREQUENCY-for frequency distributions
- TRANSPOSE – flip row/column orientation
- Write your own array formulas
Analysis ToolPak
- How to access even more functions
Text Functions
- FIND and MID – locate and extract data from text cells
- LEFT and RIGHT
- TRIM – remove spaces from text cells
- Using concatenation with functions
- UPPER, LOWER and PROPER – adjust case
- REPLACE and SUBSTITUTE
Date Functions
- WEEKDAY – day of week identifier
- NETWORKDAYS – count working days between two dates
Other Functions
- SUMIF and COUNTIF – functions that tabulate data based on conditions
Information Functions
- ISBLANK and ISERR
- ISTEXT and ISNUMBER
To receive more information about this training call toll free at 877-385-5515.
You may also email us at This email address is being protected from spambots. You need JavaScript enabled to view it. .
