Microsoft Excel 365 advanced : QuickStudy reference software guide / Curtis Frye.

Format:

Book

Author/Creator:

Frye, Curtis, 1968- author.

Series:

QuickStudy computer.

QuickStudy computer

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Business.

Electronic spreadsheets.

Physical Description:

1 online resource (6 pages)

Edition:

1st ed.

Place of Publication:

[Boca Raton, Florida] : BarCharts Publishing Inc., [2021]

Summary:

Quick and easy 6 page laminated 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 laminated reference guide includes:Conditional FormatsHighlighting RulesData Bar, Color Scale & Icon Set FormatsManaging Conditional FormatsFiler Data Using SlicersWhat-If AnalysisAnalyzing Data Using ScenariosCalculating Alternatives Using Data TablesCalculating Target Values Using Goal SeekFinding Optimal Values Using SolverPivot Tables & Pivot ChartsTimelinesExcel Data ModelData ValidationSparklinesSuggested 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 oftenCompany Training - reduce help-desk calls and keep productivity flowing for a team or for your entire companyStudents/Professors - make lives easier for students in many majors needing Excel for data management and calculation

Contents:

Conditional Formats

Highlighting Rules

Data Bar, Color Scale &amp

Icon Set Formats

Data Bars

Color Scales

Icon Sets

Managing Conditional Formats

Filter Data Using Slicers

What-If Analysis

Analyzing Data Using Scenarios

Calculating Alternatives Using Data Tables

Calculating Target Values Using Goal Seek

Goal Seek

Finding Optimal Values Using Solver

Tables &amp

Charts

Timelines

Excel Data Model

Data Validation.

Notes:

Description based on publisher supplied metadata and other sources.

Description based on print version record.

Other Format:

Print version: Frye, Curtis Microsoft Excel 365 Advanced

ISBN:

9781423247074

OCLC:

1303083631