Название: Excel Cookbook: Recipes for Mastering Microsoft Excel (2nd Early Release) Автор: Dawn Griffiths Издательство: O’Reilly Media, Inc. Год: 2023-05-03 Страниц: 500 Язык: английский Формат: epub (true) Размер: 10.2 MB
Filled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular problem and outlines a solution that you can put to use right away—without having to comb through tutorial pages.
Whether you're a data analyst, project manager, or financial analyst, author Dawn Griffiths directs you straight to the answers you need. Ideal as a quick reference, Excel Cookbook is also perfect for learning how to work in a more efficient way, leading to greater productivity on the job. With this book, you'll jump in and get answers to your questions—fast.
Excel isn’t a word processor, but there are many situations in which you need to manipulate text strings and transform data to fit a data model. This chapter shows how to perform common text manipulation exercises, including joining text together, extracting numeric codes, removing extra spaces and characters, and applying text formats to currency, number, and date/time values.
This cookbook shows you how to
Get the most out of Excel's features Address complex data problems in the best way possible Collect, manage, and analyze data from a variety of sources Use functions and formulas with ease—including array formulas Analyze data with PivotTables, Power Pivot, and more Import and transform data with Power Query Write custom functions and automate Excel with VBA
Навигация
Вход на сайт
Реклама
Excel Cookbook (2nd Early Release) 
Название: Excel Cookbook: Recipes for Mastering Microsoft Excel (2nd Early Release)