This hands-on course is for experienced Excel users to build on their knowledge and skills. Course will explore advanced formulas, functions, data validation, PivotTables, and PivotCharts, importing and exporting text files and XML data, Macros, and sharing data over the web. Class will also cover functions to make your work life more automated with custom functions, lookup, match, index, and other tools that will make Excel do part of your job for you.
Upon successful completion of this course you should be able to:

• Calculate data with logical and financial functions
• Analyze data with statistical functions
• Use advanced functions of Lookup, Match and Index to automate tasks
• Validate cell entries
• Create, rearrange and format Pivot Tables and Charts
• Export and import text files and XML data
• Query external databases
• Run and record a Macro
• Work with VBA code
• Create custom functions
• Use conditional formatting with graphics, including SmartArt