130 likes | 217 Views
Excel For Power Users (PART 1). After participating in this session, you will be able to: Use new keyboard shortcuts to increase productivity approach report building with new skills and methods and apply new metrics to business intelligence reporting. Agenda.
E N D
Excel For Power Users (PART 1) • After participating in this session, you will be able to: • Use new keyboard shortcuts to increase productivity • approach report building with new skills and methods and • apply new metrics to business intelligence reporting
Agenda 1. Pre-Requisite Knowledge 3. Topic: 5 Keyboard Shortcuts 2. Learning Objectives
Agenda 4. Topic: Pivot Tables & Pivot Charts 7. Topic: Nesting Formulas 5. Topic: Text Function 6. Topic: Index And Match
Basic to intermediate Excel knowledge • Pivot tables • VLOOKUP • Nesting Formulas 1. Pre-Requisite Knowledge
After participating in this session, you will be able to: • Use new keyboard shortcuts to increase productivity • Approach report building with new skills and methods • Apply new metrics to business intelligence reporting 2. Learning Objectives
Inserting columns, inserting rows • Inserting a new sheet • Copying sheets • Selecting entire tables 3. Topic: 5 Keyboard Shortcuts
Demonstration 4. Topic: Pivot Tables & Pivot Charts
Create new groupings with Text Functions • Converts numeric values into easy to read formats • e.g. dates to named days, months or years • e.g. hours, minutes and seconds groupings • e.g. currencies, percentages and other text formats 5. Topic: Text Function
Better than VLOOKUP… • Resolves faster than VLOOKUP, less memory • Two separate functions • Can reference any column, not just first position 6. Topic: Index And Match
Nesting the Match, Index and Text Functions: Demonstration 7. Topic: Nesting Formulas
Excel on Steroids is a specialized training program focusing on key Excel functionality for business reporting and decision-making! www.alchemex.com www.alchemexacademy.com
ALCHEMEX Contact Information You can also find our knowledgebase, free trial software download and customer references, and sign up for free Tips & Tricks e-newsletters at www.alchemex.com.
If you have found this presentation useful, see our Webinar Schedule at www.alchemex.com and register for more. Thank you for your time and have a great day!