Microsoft Excel 2019 inside out /
Jelen, Bill,
Microsoft Excel 2019 inside out / Microsoft Excel 2019 Bill Jelen. - xxxi, 829 pages : illustrations ; 24 cm
Includes index.
What's new in Excel 2019
Using the Excel interface
Customizing Excel
Keyboard shortcuts
Understanding formulas
Controlling formulas
Understanding functions
Using everyday functions : math, date and time, and text functions
Using powerful functions : logical, lookup, and database functions
Other functions
Connecting worksheets and workbooks
Array formulas and names in Excel
Transforming data
Summarizing data using subtotals or filter
Using pivot tables to analyze data
Using slicers and filtering a pivot table
Mashing up data with power pivot
Using what-if, scenario manager, goal seek, and solver
Automating repetitive functions using VBA macros
More tips and tricks for Excel 2019
Formatting worksheets
Using data visualizations and conditional formatting
Graphing data using Excel charts
Using 3D maps
Using sparklines
Formatting spreadsheets for presentations
Printing
Sharing dashboards with power BI
Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. -- Provided by publisher
9781509307692 1509307699
2018959530
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
Electronic spreadsheets--Computer programs.
Handbooks and manuals.
Handbooks and manuals.
HF5548.4.M523 / JEL
005.54
Microsoft Excel 2019 inside out / Microsoft Excel 2019 Bill Jelen. - xxxi, 829 pages : illustrations ; 24 cm
Includes index.
What's new in Excel 2019
Using the Excel interface
Customizing Excel
Keyboard shortcuts
Understanding formulas
Controlling formulas
Understanding functions
Using everyday functions : math, date and time, and text functions
Using powerful functions : logical, lookup, and database functions
Other functions
Connecting worksheets and workbooks
Array formulas and names in Excel
Transforming data
Summarizing data using subtotals or filter
Using pivot tables to analyze data
Using slicers and filtering a pivot table
Mashing up data with power pivot
Using what-if, scenario manager, goal seek, and solver
Automating repetitive functions using VBA macros
More tips and tricks for Excel 2019
Formatting worksheets
Using data visualizations and conditional formatting
Graphing data using Excel charts
Using 3D maps
Using sparklines
Formatting spreadsheets for presentations
Printing
Sharing dashboards with power BI
Dive into Microsoft Excel 2019-and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks-and challenge yourself to new levels of mastery. -- Provided by publisher
9781509307692 1509307699
2018959530
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets--Computer programs.
Electronic spreadsheets--Computer programs.
Handbooks and manuals.
Handbooks and manuals.
HF5548.4.M523 / JEL
005.54