Microsoft Excel 2019 Step by Step
- Length: 480 pages
- Edition: 1
- Language: English
- Publisher: Microsoft Press
- Publication Date: 2018-12-17
- ISBN-10: 1509307672
- ISBN-13: 9781509307678
- Sales Rank: #59294 (See Top 100 Books)
The quick way to learn Microsoft Excel 2019!
This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step.
- Quickly set up workbooks, enter data, and format it for easier viewing
- Perform calculations and find and correct errors
- Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines
- Visualize data with 3D maps, funnel charts, and other powerful tools
- Import, process, summarize, and analyze huge datasets with Excel’s improved PowerPivot and Power Query
- Build powerful data models and use them in business intelligence
- Look up just the tasks and lessons you need
Table of Contents
1: Set up a workbook
2: Work with data and Excel tables
3: Perform calculations on data
4: Change workbook appearance
5: Manage worksheet data
6: Reorder and summarize data
7: Combine data from multiple sources
8: Analyze
9: Create charts and graphics
10: Create dynamic worksheets by using PivotTables and PivotCharts
11: Print worksheets and charts
12: Automate repetitive tasks by using macros
13: Work with other Microsoft Office apps
14: Collaborate with colleagues
15: Perform business intelligence analysis
16. Create forecasts and visualizations
Chapter 1 - Getting Started with Excel Chapter 2 - Understanding OneDrive Chapter 3 - Creating and Opening Workbooks Chapter 4 - Saving and Sharing Workbooks Chapter 5 - Cell Basics Chapter 6 - Modifying Columns, Rows, and Cells Chapter 7 - Formatting Cells Chapter 8 - Understanding Number Formats Chapter 9 - Working with Multiple Worksheets Chapter 10 - Using Find & Replace Chapter 11 - Checking Spelling Chapter 12 - Page Layout and Printing Chapter 13 - Intro to Formulas Chapter 14 - Creating More Complex Formulas Chapter 15 - Relative and Absolute Cell References Chapter 16 - Functions Chapter 17 - Basic Tips for Working with Data Chapter 18 - Freezing Panes and View Options Chapter 19 - Sorting Data Chapter 20 - Filtering Data Chapter 21 - Groups and Subtotals Chapter 22 - Tables Chapter 23 - Charts Chapter 24 - Conditional Formatting Chapter 25 - Comments and Co-authoring Chapter 26 - Inspecting and Protecting Workbooks Chapter 27 - Intro to PivotTables Chapter 28 - Doing More with PivotTables Chapter 29 - What-if Analysis
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.