1 / 13

Excel For Power Users (PART 1)

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.

gray-pena
Télécharger la présentation

Excel For Power Users (PART 1)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Agenda 1. Pre-Requisite Knowledge 3. Topic: 5 Keyboard Shortcuts 2. Learning Objectives

  3. Agenda 4. Topic: Pivot Tables & Pivot Charts 7. Topic: Nesting Formulas 5. Topic: Text Function 6. Topic: Index And Match

  4. Basic to intermediate Excel knowledge • Pivot tables • VLOOKUP • Nesting Formulas 1. Pre-Requisite Knowledge

  5. 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

  6. Inserting columns, inserting rows • Inserting a new sheet • Copying sheets • Selecting entire tables 3. Topic: 5 Keyboard Shortcuts

  7. Demonstration 4. Topic: Pivot Tables & Pivot Charts

  8. 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

  9. 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

  10. Nesting the Match, Index and Text Functions: Demonstration 7. Topic: Nesting Formulas

  11. 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

  12. 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.

  13. 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!

More Related