Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Microsoft Excel 365 Advanced : a QuickStudy Digital Reference Guide, PDF eBook

Microsoft Excel 365 Advanced : a QuickStudy Digital Reference Guide PDF

PDF

Please note: eBooks can only be purchased with a UK issued credit card and all our eBooks (ePub and PDF) are DRM protected.

Description

Quick and easy 6 page digital guide loaded with essential functions and how to perform them in Excel 365 (and Excel 2019). Beginners and experienced users, can find hundreds of the most popular and useful functions fast with clear succinct steps to get the task done. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. Look for Excel 365, Excel 365 ';Tips and Tricks', ';Formulas' and ';Pivot Tables' QuickStudy guides to have a complete power-user reference set.
6 page digital reference guide includes:

  • Conditional Formats
    • Highlighting Rules
    • Data Bar, Color Scale & Icon Set Formats
    • Managing Conditional Formats
  • Filer Data Using Slicers
  • What-If Analysis
    • Analyzing Data Using Scenarios
    • Calculating Alternatives Using Data Tables
    • Calculating Target Values Using Goal Seek
    • Finding Optimal Values Using Solver
  • Pivot Tables & Pivot Charts
  • Timelines
  • Excel Data Model
  • Data Validation
  • Sparklines
Suggested uses:
  • Workspace flat for easy storage and access at a moments notice to find a function you need to use, or to jog your memory for a function you do not use often
  • Company Training reduce help-desk calls and keep productivity flowing for a team or for your entire company
  • Students/Professors make lives easier for students in many majors needing Excel for data management and calculation

Information

Information