Excel Bootcamp: Functions & Formulas

About this workshop

Sky rocket your Excel expertise with this comprehensive hands-on workshop exploring financial functions, date functions, sum formulas, string-manipulation functions, and other useful topics, such as: VLOOKUP, logical operators, and Goal Seek Tool.

Takeaways

• Differentiate between Excel formulas and functions
• Use relative and absolute cell references
• Parse and concatenate text strings
• Utilize Text To Columns and Goal Seek tools
• Incorporate built-in Excel math, financial, statistical, logical, and date functions in their worksheets
• Handle Excel errors
• Master the VLOOKUP function

Prereqs & Preparation

Beginner to intermediate level MS Excel program knowledge and proficiency.