Excel Functions (Formulas)


 
Course Length: 3hrs (1/2 Day)
Excel functions are the key to providing financial results from data. There are hundreds of Excel functions, each with their own purpose and usefulness yet with common elements that make learning new functions easier.

The purpose of this course is to learn how to create and apply Excel functions to generate mathematical results from data.

Learning Objectives:
After completing this course, students will be able to:
  • Identify which function to use to generate results
  • Employ a number of strategies for creating functions
  • Build their own functions using the fx tool
  • Add multiple worksheets together
  • Utilize array formulas
Target Student:
This course is designed for Excel users with some knowledge of entering financial data but would like to explore more mathematical functions.

Course Outline:
Section 1: Copying column formulas instantly

Section 2: 3D formulas to gather data from multiple sheets

Section 3: Updating values without formulas

Section 4: Displaying and highlighting formulas

Section 5: Enhancing readability with range names

Section 6: Extracting Data With LEFT, RIGHT and MID

Section 7: Locating Data With FIND, SEARCH, EXACT

Section 8: Combine Data From Different Cells

Section 9: Changing The Case Of Text Using PROPER, UPPER, and LOWER

Section 10: IF logical tests and using operators

Section 11: Nested IF statements

Section 12: Using the AND, OR, and NOT functions with IF

Section 13: Tabulating information on a single criterion - COUNTIF, SUMIF, and AVERAGEIF

Section 14: Tabulating information on multiple criteria - COUNTIFS, SUMIFS, and AVERAGEIFS

Section 15: Looking up information - VLOOKUP and HLOOKUP

Section 16: Locating data - MATCH

Section 17: Retrieving information by location – INDEX

Section 18: Excel date/time capabilities in formulas

Section 19: Identifying the day of the week - WEEKDAY

Section 20: Counting working days - NETWORKDAYS

Section 21: Determining a completion date - WORKDAY

Section 22: Tabulating date/time differences - DATEDIF

Section 23: Finding the middle value - MEDIAN

Section 24: Ranking data without sorting - RANK

Section 25: Tabulating blank cells – COUNTBLANK

Section 26: Using database functions – DSUM, DCOUNT, DAVERAGE

Section 27: Working with rounding functions

Section 28: Learn about array formulas
Excel Functions (Formulas)

Register for this class

This Course Comes With


PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed

Video Library

Sign up to our video library subscription and review an extensive selection of training videos to refresh your memory
Register for this class here
Learn more about each course here
Contact us for more information here