Let’s Know What’s There In The Book
MICROSOFT EXCEL 2016 STEP BY STEP
The quick way to learn Microsoft Excel 2016 and get more done!
By Curtis Frye
This learning made easy reference shows you exactly what to do, step by step. Learn to
• Quickly set up workbooks, enter data, and format it for easier viewing
• Perform calculations and find and correct errors • Filter, sort, summarize, and combine data
• Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
• Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
• Build data models and use them in business intelligence analyses
• Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
• Look up just the tasks and lessons you need
Let’s Know The Contents
Introduction
Part 1: Create and format workbooks
1. Set up a workbook
2. Work with data and Excel tables.
3. Perform calculations on data
4. Change workbook appearance
Part 2: Analyze and present data
5. Manage worksheet data
6. Reorder and summarize data
7. Combine data from multiple sources
8. Analyze alternative data sets.
9. Create charts and graphics.
10. Create dynamic worksheets by using PivotTables
Part 3: Collaborate and share in Excel
11. Print worksheets and charts
12. Automate repetitive tasks by using macros
13. Work with other Microsoft Office apps
14. Collaborate with colleagues
Part 4: Perform advanced analysis
15. Perform business intelligence analysis .
16. Create forecasts and visualizations
Let’s Know About the Author
Curtis Frye is a writer, speaker, and performer who lives in Portland, Oregon. He is the author or co-author of more than 20 books, including Microsoft Excel 2013 Step by Step. In addition to his writing, Curt presents keynote addresses on Excel and motivational topics.
Purchase the book from our website at special discount. Click here