Recommended Books on Microsoft Office
| Michael Alexander |
Microsoft Business Intelligence Tools for Excel Analysts |
Amazon
|
|
| Book Description: Self-Service Business Intelligence with Excel
For the first time, Excel is an integral part of the Microsoft BI stack - capable of integrating multiple data sources, defining relationships between data sources, processing analysis services cubes, and developing interactive dashboards that can be shared on the web. With these new tools, it’s becoming important for Excel analysts to expand their knowledge to include new skills, like database management, query design, data integration, multidimensional reporting, and a host of other practices.
This book is aimed squarely at business analysts and managers who find it increasingly necessary to become more efficient at working with the new Microsoft BI tools like Power Pivot, Power Query, and Power View. |
| Helen Feddema |
Access 2013: the real startup guide |
Office-Watch |
|
| Book Description: Helen Feddema has spent months slaving over Access 2013 - testing, checking, asking embarrassing questions of MS Support (embarrassing for Microsoft anyway) and she's come up with Access 2013: the real startup guide . In the best tradition of Office-Watch.com, Helen is not content to accept Microsoft hype and vague promises. Access 2013: the real startup guide tells how it really works - Web Apps in depth, what's changed, what's missing and buying Access 2013 for the lowest price. |
| Jelen & Syrstad |
VBA & Macros for Excel 2013 |
Mr Excel |
|
| Book Description:Entry-level VBA book for someone who already knows Excel. |
| Jelen |
LiveLessons Excel Macros & VBA |
Mr Excel |
|
| Book Description: 50 short video lessons on learning Excel VBA |
| Meister et al |
Office VBA Macros You Can Use Today |
Mr Excel |
|
| Book Description: The Rosetta Stone, showing 25 macros for each Office application |
| Verschuuren |
Excel 2013 VBA |
Mr Excel |
|
| Book Description: A slide-based tutorial on VBA - great for visual learners |
| Jelen |
Excel Macro Record to VBA Tip Card |
Mr Excel |
|
| Book Description: A laminated tip card to guide you from the macro recorder to writing VBA |
| Zack Barresse, Kevin Jones |
Excel Tables - A Complete Guide |
Amazon |
|
| Book Description:Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it implies can be intimidating to the uninitiated. In this guide, one of the developers of the official Microsoft Excel 2013 templates—all of which employ tables—helps introduce readers to the multiple benefits of tables. The book begins by explaining what tables are, how to create them, and how they can be used in reporting before moving on to slightly more advanced topics, including slicers and filtering, working with VBA macros, and using tables in the Excel web app. Novice Excel users and experts alike will find relevant, useful, and authoritative information in this one-of-a-kind resource.
|
| - |
- |
- |
- |
| Book Description: |
|
|
