Intermediate Excel: Formulas & Functions

The Intermediate Excel: Formula and Functions workshop is designed for participants who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. Given that there lacks an enforceable , the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions and basic reference functions, to ensure that all participants have the basic knowledge needed for the advance topics. Participants will learn specialized functions and how to combine functions to achieve more advance tasks. Additionally, the workshop covers some more advance options in charts. Participants that benefit the most are those looking to be more efficient with Excel
Agenda (Not necessarily taught in the order below):
Review of conditional math functions and basic reference function
Auditing tools
Functions
Text Functions
Advance Reference Functions
Logical Functions
Dynamic Name Ranges
Advance Charts Topics
Trendline
Secondary Axis
Nigel Caldon
Co-Founder,
BALLSTAR
Nigel was born and raised in Brooklyn, NY. Awarded a Presidential Scholarship to study economics at Hampton University. He then returned to NYC to complete his Bachelors in Economics at New York University. He worked in credit derivative markets at Goldman Sachs and Old Lane before founding The Street Academy for Financial Literacy, a non-profit serving over 1000 NYC youth annually. Today, Nigel is the Co-Founder and COO at BALLSTAR, a social database for global basketball statistics.
Official Website