 Название: Microsoft Excel 365 Bible, 2nd Edition
Автор: Michael Alexander, Dick Kusleika
Издательство: Wiley
Год: 2025
Страниц: 1088
Язык: английский
Формат: epub (true)
Размер: 81.1 MB
Ваше полное руководство по Excel 365, написанное как для новичков, так и для опытных профессионалов. Хорошо структурированная и написанная на понятном языке, Библия Microsoft Excel 365 содержит все, что читателям нужно знать, чтобы быстро начать работу с Excel. Второе издание охватывает многочисленные обновления Excel 365 с момента публикации предыдущего издания в 2022 году и содержит множество полезных примеров, советов и рекомендаций, которые охватывают все основные аспекты Excel - от основ, таких как навигация по пользовательскому интерфейсу, до более продвинутых тем, таких как создание визуализаций и создание настраиваемых функций. Эта книга предназначена для повышения квалификации пользователей всех уровней (начинающих, средних и даже продвинутых пользователей). Начните с самого начала, если вы новичок в Excel. Часть I охватывает все, что вам нужно для ознакомления с вводом данных, управлением книгами, форматированием листов и печатью. Затем вы можете перейти к части II, где вы откроете для себя все тонкости формул и функций Excel.
Your complete guide to Excel 365, written for newbies all the way to seasoned professionals.
Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions.
Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including:
• Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contents
• Building formulas with Excel table objects, correcting common formula errors and using formula variables
• Working with data series, changing basic chart elements and making use of chart customization
• Loading data from other sources, performing common transformations and applying conditional logic
This book is designed to enhance the skill set of users at all levels (beginning, intermediate, and even advanced users). Start at the beginning if you're new to Excel. Part I covers everything you'll need to get familiar with entering data, managing workbooks, formatting worksheets, and printing. You can then move on to Part II, where you'll discover the ins and outs of Excel formulas and functions. If you're a seasoned analyst hoping to enhance your data visualization and analytic toolset, check out Part III and Part IV. We've included many examples and tips for analyzing data and creating visually appealing Excel dashboards. If you've been working with an earlier version of Excel, this book is for you too! Part V covers the Power Pivot and Power Query toolsets. In the past, these features were free Microsoft add-ins that were used peripherally. Now they've become an essential part of how Excel manages data and interacts with external data sources. If you want to learn the basics of Visual Basic for Applications (VBA) programming, you'll find what you need in Part VI. This part offers a robust set of chapters that will get you started leveraging VBA to automate and enhance your Excel solutions.
Microsoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.
Contents:
Introduction
Part I: Getting Started with Excel
Part II: Working with Formulas and Functions
Part III: Creating Charts and Other Visualizations
Part IV: Managing and Analyzing Data
Part V: Understanding Power Pivot and Power Query
Part VI: Automating Excel
Index
Скачать Microsoft Excel 365 Bible, 2nd Edition
|
Навигация
Вход на сайт
Реклама
Microsoft Excel 365 Bible, 2nd Edition 
