Description: This course is the combination of two half-day split sessions. The first half is designed for those who have a general aptitude with Excel functionality when it comes to working with data lists and tables. There will be a brief review of the basic concepts of sorting and filtering data along with subtotaling data […]
Course Description: This course involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to multiple data sources […]
Description: This course is designed for individuals with a high level of aptitude in using Excel functions and formulas. The function categories range from Math and Trig, Date and Time, Text, Lookup and Reference, Statistical, Financial, Logical, and Information. Power users will create several business profitability formulas and will also be presented with data analysis […]