Curtis Frye is the author of more than 30 books, including Microsoft Excel 2016 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK.
Meer over Curtis FryeMicrosoft Excel 2016 Step by Step
Paperback Engels 2015 1e druk 9780735698802Samenvatting
The quick way to learn Microsoft Excel 2016!
This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers-brisk lessons and full-color screen shots 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
- 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
Specificaties
Lezersrecensies
Inhoudsopgave
Who this book is for
The Step by Step approach
Download the practice files
Sidebar: Adapt exercise steps
Ebook edition
Get support and give feedback
Errata and support
We want to hear from you
Stay in touch
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
Part 4: Perform advanced analysis
15. Perform business intelligence analysis
Keyboard shortcuts
Glossary
Index
About the author
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan