This Intermediate to Advanced Excel training course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform advanced analysis using functions, statistics, macros and validation at advanced level and formulas to pull and analyze data.
Upon the successful completion of this course, each participant will be able to:
Work faster in Excel by learning Shortcuts; Understand and use formula cell referencing to create more complex formulas; Able to like logical test with IF Condition; Formatting data on the based on Criteria’s with Conditional Formatting; Creating data validation (Drop downs) and Write Formulas like SUMIF & COUNTIF
