Advanced Excel Tutorial Step by Step
- Length: 479 pages
- Edition: 1
- Language: English
- Publication Date: 2021-08-24
- ISBN-10: B09DLGCNWQ
- Sales Rank: #0 (See Top 100 Books)
Advanced Excel Tutorial Step by Step
This Excel book is very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to master advanced Excel 2019 skills. Here are some of the reasons that you should choose this book:
- It provides a thorough (and easy to understand) coverage of Power Pivot, Power Query, and DAX. Excel now includes Power Pivot. Unlike most other books, this book will teach you the relational database and data modeling skills needed to create optimal Power Pivot Star Schema data models incorporating DAX measures. You’ll conform to 24 best-practice Power Pivot rules, ensuring excellence in your future real-world data model designs.
- It won’t waste your time by teaching basic Excel 2019 skills that you already know.This isn’t a beginner’s book. If you are an absolute beginner, you need our Excel Essential Skills book. By assuming that you are already able to use Excel’s basic features, far more ground can be covered.
- It teaches to true Expert level. This Expert Skills book teaches Excel to an extremely high level of competence that is very rarely found in the workplace (even amongst top professionals). At Expert level your skills will be greater and broader than almost all other Excel users and you will understand (and be able to effectively use) absolutely every Excel and Power Pivot feature. You’ll have a complete mastery of skills that are often even a mystery to Excel power users.
- Learning success is guaranteed. For over fifteen years, Smart Method courses have been used by large corporations, government departments and the armed forces to train their employees. The book is ideal for teaching or self-learning because it has been constantly refined (during hundreds of classroom courses) by observing which skills students find difficult to understand and then developing simpler and better ways of explaining them. This has made the book effective for students of all ages and abilities.
- Smart Method® books are #1 best sellers.Every paper printed Smart Method Excel book (and there have been twenty-two of them starting with Excel 2007) has been an Amazon #1 best seller in it’s category. This provides you with the confidence that you are using a best-of-breed resource to learn Excel.
- It is the book of choice for teachers.As well as catering for those wishing to learn Excel by self-study, Smart Method books have long been the preferred choice for Excel teachers as they are designed to teach Excel and not as reference books. Books follow best-practice adult teaching methodology with clearly defined objectives for each learning session and an exercise to confirm skills transfer.
- It is written in plain English. Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way.
Part 1: Excel New Features Part 2: Fundamental Data Analysis Part 6: Other Features About the Tutorial ................................................................................. Table of Contents .................................................................................. PART 1: EXCEL NEW FEATURES ......................................................................... 1. Excel – Chart Recommendations ................................................................. Chart Recommendations .............................................................................. Fine Tune Charts Quickly ........................................................................... Select / De-select Chart Elements .................................................................. Format Style ....................................................................................... Format Color ....................................................................................... Filter Data being displayed on the Chart ........................................................... 2. Excel – Format Charts ......................................................................... Provision for Combo Charts ......................................................................... 3. Excel – Chart Design .......................................................................... Quick Layout ....................................................................................... Change Colors ...................................................................................... Switch Row / Column ................................................................................ Select Data ........................................................................................ Change Chart Type .................................................................................. Move Chart ......................................................................................... 4. Excel – Richer Data Labels .................................................................... Look of the Data Labels ............................................................................ Shape of a Data Label .............................................................................. Resize a Data Label ................................................................................ 5. Excel – Leader Lines .......................................................................... Format Leader Lines ................................................................................ 6. Excel – New Functions.......................................................................... New Functions in Excel 2013 ........................................................................ User Defined Functions in Add-ins .................................................................. PART 2: FUNDAMENTAL DATA ANALYSIS .................................................................. 7. Instant Data Analysis ......................................................................... Conditional Formatting ............................................................................. Charts ............................................................................................. Totals ............................................................................................. Tables ............................................................................................. Sparklines ......................................................................................... 8. Excel – Sorting Data by Color ................................................................. 9. Excel – Slicers ............................................................................... 10. Excel – Flash Fill ........................................................................... PART 3: POWERFUL DATA ANALYSIS – INTRODUCTION ...................................................... 11. Excel – PivotTable Recommendations ........................................................... Create a PivotTable to analyze external data ....................................................... Connect to a new external data source .............................................................. Using the Field List option ........................................................................ PivotTables based on Multiple Tables ............................................................... PART 4: POWERFUL DATA ANALYSIS – 1 ................................................................. 12. Excel – Data Model in Excel .................................................................. Explore Data Using PivotTable ...................................................................... Create Relationship between Tables ................................................................. 13. Excel – Power Pivot .......................................................................... Data Model using Calculated Columns ................................................................
Donate to keep this site alive
To access the Link, solve the captcha.
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.