Microsoft Excel 2019 Inside Out

Häftad, Engelska, 2019

462 kr

Skickas . Fri frakt över 249 kr.

Beskrivning

You’re beyond the basics—so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Learn how the experts tackle Excel—and challenge yourself to new levels of mastery. Includes companion eBook and sample files.

Topics include:

Customizing the Excel workspace
Best practices for designing and managing worksheets
Creating formulas and functions
Performing statistical, what-if, and other data analysis
Core to advanced charting techniques
Using graphics and sparklines
Managing databases and tables
Automating Excel with macros and custom functions
Collaborating in Excel online, in the cloud, and more
Extending Excel

Produktinformation

Utgivningsdatum:2019-01-16
Mått:215 x 275 x 50 mm
Vikt:1 300 g
Format:Häftad
Språk:Engelska
Serie:Inside Out
Antal sidor:864
Upplaga:1
Förlag:Pearson Education
ISBN:9781509307692

Utforska kategorier

Affärsapplikationer inom Data och IT

Mer om författaren

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He loves performing his live Power Excel seminars around the United States. He has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches, working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company.

Innehållsförteckning

Part I THE EXCEL INTERFACE1 What’s New in Excel 2019 and Office 3652 Using the Excel Interface3 Customizing Excel4 Keyboard Shortcuts Part II CALCULATING WITH EXCEL5 Understanding Formulas6 Controlling Formulas7 Understanding Functions8 Using Everyday Functions: Math, Date and Time, and Text Functions9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions10 Other Functions11 Connecting Worksheets and Workbooks12 Array Formulas and Names in Excel Part III DATA ANALYSIS WITH EXCEL13 Transforming Data with Power Query14 Summarizing Data Using Subtotals or Filter15 Using Pivot Tables to Analyze Data16 Using Slicers and Filtering a Pivot Table17 Mashing Up Data with Power Pivot18 Using What-If, Scenario Manager, Goal Seek, and Solver19 Automating Repetitive Functions Using VBA Macros20 More Tips and Tricks for Excel 2016 Part IV EXCEL VISUALS21 Formatting Worksheets22 Using Data Visualizations and Conditional Formatting23 Graphing Data Using Excel Charts24 Using 3D Maps25 Using Sparklines26 Formatting Spreadsheets for Presentation27 Printing28 Excel Online APPENDIXESA DAX FunctionsB Power Query M Functions