Bill Jelen (MrExcel), Szilvia Juhasz - The 40 Greatest Excel Tips of All Time / 40 лучших трюков-приёмов работы в Excel всех времён [2015, PDF, ENG]

Ответить на тему
Статистика раздачи
Размер:  15 MB   |    Зарегистрирован:  7 лет 8 месяцев   |    Скачан:  4 раза
Сидов:  412  [  0 KB/s  ]   Личеров:  9  [  0 KB/s  ]   Подробная статистика пиров
 
   
 
 
Автор Сообщение

Скачать Windows ®

Пол:

Стаж: 9 лет 1 месяц

Сообщений: 7412

Создавать темы 17-Июл-2016 23:20

[Цитировать]

The 40 Greatest Excel Tips of All Time / 40 лучших трюков-приёмов работы в Excel всех времён
Год издания: 2015
Автор: Bill Jelen (MrExcel), Szilvia Juhasz
Жанр или тематика: работа в Excel
Издательство: Holy Macro! Books
ISBN: 978-1-61547-004-2
Язык: Английский
Формат: PDF
Качество: Издательский макет или текст (eBook)
Интерактивное оглавление: Да
Количество страниц: 278
Описание: Автор провёл опрос по теме "Какой ваш любимый трюк-приём работы в Excel?" и лучшие 40 ответов разместил в своей книге. Каждый приём объясняется текстом, скриншотами и, иногда, иллюстрациями. Любой, кто регулярно пользуется Excel найдёт здесь для себя приём, который поможет сэкономить многие часы работы.

Примеры страниц

Оглавление

Table of Contents
Dedication.............................................................................................................................................................................v
Acknowledgments..............................................................................................................................................................v
About the Authors............................................................................................................................................................vii
About the Contributors...................................................................................................................................................vii
Foreword...............................................................................................................................................................................ix
Introduction..........................................................................................................................................................................x
Part 1 - Bill’s Top 40 Tips......................................................................................................1
#1 Double-Click the Fill Handle to Copy a Formula................................................................................................1
#2 Filter by Selection..........................................................................................................................................................4
Bonus Tip: Total Visible..............................................................................................................................................6
#3 The Fill Handle Does Know 1, 2, 3….......................................................................................................................8
Bonus Tip: Fill 1 to 100,000 in a Flash................................................................................................................ 12
#4 Fast Worksheet Copy................................................................................................................................................. 12
Bonus Tip: Worksheet Name in a Cell................................................................................................................ 13
Bonus Tip: Create a SUM that Spears Through All Worksheets................................................................ 14
#5 Compare Sheets Side by Side with Synchronous Scrolling........................................................................ 15
#6 Turning Data Sideways with a Formula.............................................................................................................. 18
#7 Default Settings for All Future Workbooks........................................................................................................ 20
#8 Recover Unsaved Workbooks................................................................................................................................ 23
#9 Perfect One-Click Charts.......................................................................................................................................... 26
#10 Paste New Data on a Chart................................................................................................................................... 29
Bonus Tip: Comparative Scatter Charts............................................................................................................ 32
#11 Sort East, Central, and West Using a Custom List......................................................................................... 33
#12 Sort Left to Right...................................................................................................................................................... 35
Bonus: Another Way to Move columns............................................................................................................ 36
Bonus Tip: Use Power Query................................................................................................................................. 36
#13 Sort Subtotals............................................................................................................................................................ 37
Bonus Tip: Filling in a Text Field on the Subtotal Rows............................................................................... 39
Bonus Tip: Formatting the Subtotal Rows....................................................................................................... 40
Bonus Tip: Copying the Subtotal Rows............................................................................................................. 40
#14 Easy Year-over-Year Report in a Pivot Table.................................................................................................... 41
#15 True Top Five in a Pivot Table............................................................................................................................... 43
#16 Eliminate Pivot Table Annoyances..................................................................................................................... 48
Ctrl+T Table Before Adding New Data.............................................................................................................. 49
Bonus Tip: Ctrl+T Helps VLOOKUP and Charts............................................................................................... 52
Bonus Tip: Readable References with Ctrl+T ................................................................................................. 53
Bonus Tip: Running Totals in Tables................................................................................................................... 54
#17 Replicate a Pivot Report For Each Rep............................................................................................................. 58
#18 Use a Pivot Table to Compare Lists.................................................................................................................... 60
Bonus Tip: Showing Up/Down Markers............................................................................................................ 61
#19 Custom Chart Labels in Excel 2013.................................................................................................................... 63
#20 Build Dashboards with Sparklines and Slicers............................................................................................... 68
Bonus Tip: Make Your Workbook into an Web App...................................................................................... 72
#21 GETPIVOTDATA Might Not Be Entirely Evil...................................................................................................... 74
#22 Eliminate VLOOKUP with the Data Model....................................................................................................... 78
Bonus Tip: Count Distinct...................................................................................................................................... 80
#23 Budget Versus Actual via Power Pivot.............................................................................................................. 81
Bonus Tip: Portable Formulas.............................................................................................................................. 83
#24 F4 for Absolute and Repeat Last Command.................................................................................................. 86
#25 The Fastest Way to Convert Formulas to Values............................................................................................ 90
#26 See All Formulas at Once....................................................................................................................................... 92
Bonus Tip: Highlight All Formula Cells.............................................................................................................. 92
#27 Discover New Functions Using fx ...................................................................................................................... 94
#28 Calculate Nonstandard Work Weeks................................................................................................................. 96
Bonus Tip: Use WORKDAY.INTL for a Work Calendar.................................................................................... 99
#29 Handle Multiple Conditions in IF......................................................................................................................100
Bonus Tip: Using Boolean Logic........................................................................................................................101
iv MrEXCEL XL
#30 Cure Triskaidekaphobia with a Killer Formula.............................................................................................102
#31 Troubleshooting VLOOKUP................................................................................................................................106
Bonus Tip: Replacing Columns of VLOOKUP with a Single MATCH......................................................110
Bonus Tip: VLOOKUP Left with INDEX/MATCH.............................................................................................112
#32 Replace Nested IFs with a Lookup Table.......................................................................................................114
Mini Bonus Tip: Matching the Parentheses...................................................................................................114
#33 Speed Up VLOOKUP..............................................................................................................................................116
#34 Protect All Formula Cells.....................................................................................................................................118
#35 Back into an Answer Using Goal Seek............................................................................................................119
#36 Do 60 What-If Analyses with a data table.....................................................................................................120
Bonus Tip: data table from a Blank Cell..........................................................................................................122
#37 Find Optimal Solutions with Solver.................................................................................................................124
#38 Load a File List into Excel with Power Query................................................................................................127
#39 Pivot Table on a Map Using 3D Maps.............................................................................................................129
#40 Avoid Whiplash with Speak Cells.....................................................................................................................132
Bonus Tip: A Great April Fool’s Day Trick .......................................................................................................133
Part 2 - 40 Keyboard Shortcuts...................................................................................... 134
Part 3 - Excel 30 Anniversary Tips.................................................................................. 139
#1 Wingdings and Other Unsung Font Heroes....................................................................................................139
#2 In-Cell Charting with REPT().................................................................................................................................145
#3 AutoSum on a Matrix..............................................................................................................................................147
#4 Retrieve the Intersection Value – From Space!..............................................................................................148
#5 How to Lose Your VBA-V (VBA-Virginity)..........................................................................................................151
#6 Recording Your Very First Macro.........................................................................................................................153
#7 Turn Your QAT into Your Personal Laugh Track..............................................................................................157
Bonus Tip: Add Icons to the Quick Access Toolbar.....................................................................................162
#8 VBA For Troublemakers..........................................................................................................................................163
#9 Absolute, Relative, and Multiplication Tables................................................................................................164
#10 From Outline to Flat Table...................................................................................................................................166
#11 Goal Seek for Renters and Shoe Lovers..........................................................................................................168
#12 Controlled Lists with Data Validation.............................................................................................................171
Bonus Tip: Other Data Validation Settings....................................................................................................175
#13 The XSzil Guide to Excel Protection.................................................................................................................176
#14 Named Formulas: Yesterday and Tomorrow................................................................................................178
#15 Named Formulas: VLOOKUP Without the Sausage....................................................................................179
#16 Controlled Formula Lists with Data Validation............................................................................................183
#17 Dependent Data Validation Lists......................................................................................................................186
#18 Smile for the Excel Camera!................................................................................................................................190
#19 VLOOKUP – to the Left!........................................................................................................................................194
#20 Data Shaping (Unpivot) with Power Query..................................................................................................197
#21 XSzil Design Tips for Excel for Presenters and Trainers.............................................................................202
#22 Fill in a Flash.............................................................................................................................................................206
#23 Suppress Errors with IFERROR...........................................................................................................................207
#24 Plural Conditions with SUMIFS..........................................................................................................................208
#25 Formatting as Façade...........................................................................................................................................210
#26 Extract Uniques with a CSE Formula...............................................................................................................212
#27 Consolidate Quarterly Worksheets..................................................................................................................214
#28 A2:INDEX() Is Like a Non-Volatile OFFSET.....................................................................................................218
#29 Sort and Filter by Color or Icon.........................................................................................................................220
#30 Word for Excellers...................................................................................................................................................221
Bonus Tip: Merge Shapes....................................................................................................................................223
Bonus Tip: Eye Dropper........................................................................................................................................223
#31 40 Tips for the next MXL Book...........................................................................................................................223
The Excel Lover’s Guide To Cocktails.......................................................................................................................225
Part 4 - Excel Fun............................................................................................................. 242
Excel Jokes........................................................................................................................................................................242
Excel Tweets.....................................................................................................................................................................246
Excel Art From The FrankensTeam...........................................................................................................................248
Excel Stories......................................................................................................................................................................250
Excel Classifieds / Excel Resources...........................................................................................................................277
[only-soft.org].t50643.torrent
Торрент: Зарегистрирован   [ 2016-07-17 23:20 ]

19 KB

Статус: проверено
Скачан: 4 раз
Размер: 15 MB
Оценка: 
(Голосов: 0)
Поблагодарили: 0  Спасибо
Bill Jelen (MrExcel), Szilvia Juhasz - The 40 Greatest Excel Tips of All Time / 40 лучших трюков-приёмов работы в Excel всех времён [2015, PDF, ENG] скачать торрент бесплатно и без регистрации
[Профиль] [ЛС]
Показать сообщения:    
Ответить на тему

Текущее время: Сегодня, в 10:35

Часовой пояс: GMT + 4



Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете голосовать в опросах
Вы не можете прикреплять файлы к сообщениям
Вы можете скачивать файлы