1 / 6

Welcome To: Excel Day 3

Class will start at approximately 8:05 AM. Please sign in and pick up a handout. Welcome To: Excel Day 3. Instructor: Lissy Robie. Resources. Handouts: www.learnit.com/handouts Manuals : www.learnit.com/manuals Username: manuals Password: password Files: www.learnit.com/files

kacia
Télécharger la présentation

Welcome To: Excel Day 3

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. Class will start at approximately 8:05 AM. Please sign in and pick up a handout. Welcome To:Excel Day 3 Instructor: Lissy Robie

  2. Resources • Handouts: www.learnit.com/handouts • Manuals: www.learnit.com/manuals Username: manuals Password: password • Files: www.learnit.com/files • My email: erobie@learnit.com

  3. Social Media http://www.youtube.com/learnittraining https://www.facebook.com/Learn.iT.anywhere https://twitter.com/learnitanywhere http://www.linkedin.com/company/learn-it

  4. *Use www.learnitanytime.com/lissyfor 60% discount.

  5. Module 5:Advanced Functions • Formulas v. Functions • Named Ranges • Advanced Functions • IF(; IF(AND( • COUNTIF(; SUMIFS( • VLOOKUP( • IFERROR( • Other Functions • TODAY() • NOW() • LEFT(; MID(; RIGHT(; CONCATENATE(

  6. Module 6:What-If Analyses and Macros *2010 and 2013 only • Consolidate Data • What-If Analyses • Goal Seek • Create Data Table (1 and 2 variables) • Solver (Add-in) • Customize Your Ribbon* and QAT (2007) • Macros • Relative v. Absolute • Q&A

More Related