Description :
The quick way to learn Microsoft Excel 2016 and get more done! 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
Content :
Introductioni
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 Related Books : | |
 | | MICROSOFT SHAREPOINT 2013 ADMINISTRATION INSIDE OUT
By WILLIAMS, RANDY, CALLAHAN, CA , GIVENS, CHRIS, GROSS, JOHN MILAN, ALDERMAN, BRIAN, BARRERA, JAVIER | |
| |
|
| | |
| | |
Books by the same Author :
|
ADVERTISING
