Microsoft Excel Professional 2021 Guide CA Manmeet Singh Mehta
- Autor:
- CA Manmeet Singh Mehta
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 494
- Dostępne formaty:
-
ePubMobi
Zostało Ci
na świąteczne zamówienie
opcje wysyłki »
opcje wysyłki »
Opis
książki
:
Microsoft Excel Professional 2021 Guide
The power to build a successful career is at your fingertips with Excel 2021
Description
Do you struggle with handling Excel data?
Do you waste a lot of time figuring out which formulas and functions to use for your day-to-day office work?
Even so, do you still want to become a master of Excel's most advanced features and techniques?
This book will teach you the fundamentals and most beneficial uses of Microsoft Excel through various examples, practical illustrations, and good shortcuts to make your life easier with it. To begin, we'll look at the numerous features every professional needs to manage enormous volumes of data. The reader will discover how to import data from various sources and cleanse and arrange it.
You'll learn how to use Excel's formulas and functions, as well as how to analyse data in a variety of ways. This book will demonstrate how Excel's new capabilities combine AI and ML to improve and simplify data visualisation straightforwardly. This book will teach you how to solve business problems using Excel's built-in functions.
In this book, you will learn:
Start with the essential Excel skills and gradually learn the sophisticated formulas.
Discover how to quickly and easily import data from various external sources and formats.
Eliminate complex data structures, adjust formats, and enhance data visibility.
Discover hundreds of shortcuts, do complex computations, and study intelligent visuals.
Learn how to use PivotTables, What-If Analysis and Array functions to generate valuable reports and dashboards.
What makes this book your go-to Excel skill guide?
Excel techniques and formulas.
Several practical examples that make day-to-day job activities easier in minutes.
With only a few clicks, you can learn to filter, manage, and analyse your business data.
High-quality images and screenshots help you choose the correct tool in seconds.
And there are many more to explore in this book. Who this book is for
Students, recent graduates, and professionals, such as Accountants, Retail Managers, Sales Executives, Business Analysts, Administrative Assistants, and HR Professionals who want to boost their day-to-day data management and analytical skills, will find this book to be an invaluable resource.
This book, along with Excel or Microsoft 365, is all you need to become a professional Excel user. Table of Contents
1. What is New in Excel 2021
2. Excel Basics
3. Transforming and Managing Data
4. Achieving Data Consistency
5. Manipulating data
6. Power of Tables
7. Introduction to Formulas and Functions
8. Text & Other Functions
9. Date Functions
10. Logical and Lookup Functions
11. Array Functions
12. Formula Auditing
13. PivotTables
14. What-If Analysis
15. Protection and Security
16. Conditional Formatting
17. Charting Data
18. Excel Hacks and Tips - The Practical Side
19. The Way Forward
Do you struggle with handling Excel data?
Do you waste a lot of time figuring out which formulas and functions to use for your day-to-day office work?
Even so, do you still want to become a master of Excel's most advanced features and techniques?
This book will teach you the fundamentals and most beneficial uses of Microsoft Excel through various examples, practical illustrations, and good shortcuts to make your life easier with it. To begin, we'll look at the numerous features every professional needs to manage enormous volumes of data. The reader will discover how to import data from various sources and cleanse and arrange it.
You'll learn how to use Excel's formulas and functions, as well as how to analyse data in a variety of ways. This book will demonstrate how Excel's new capabilities combine AI and ML to improve and simplify data visualisation straightforwardly. This book will teach you how to solve business problems using Excel's built-in functions.
In this book, you will learn:
Start with the essential Excel skills and gradually learn the sophisticated formulas.
Discover how to quickly and easily import data from various external sources and formats.
Eliminate complex data structures, adjust formats, and enhance data visibility.
Discover hundreds of shortcuts, do complex computations, and study intelligent visuals.
Learn how to use PivotTables, What-If Analysis and Array functions to generate valuable reports and dashboards.
What makes this book your go-to Excel skill guide?
Excel techniques and formulas.
Several practical examples that make day-to-day job activities easier in minutes.
With only a few clicks, you can learn to filter, manage, and analyse your business data.
High-quality images and screenshots help you choose the correct tool in seconds.
And there are many more to explore in this book. Who this book is for
Students, recent graduates, and professionals, such as Accountants, Retail Managers, Sales Executives, Business Analysts, Administrative Assistants, and HR Professionals who want to boost their day-to-day data management and analytical skills, will find this book to be an invaluable resource.
This book, along with Excel or Microsoft 365, is all you need to become a professional Excel user. Table of Contents
1. What is New in Excel 2021
2. Excel Basics
3. Transforming and Managing Data
4. Achieving Data Consistency
5. Manipulating data
6. Power of Tables
7. Introduction to Formulas and Functions
8. Text & Other Functions
9. Date Functions
10. Logical and Lookup Functions
11. Array Functions
12. Formula Auditing
13. PivotTables
14. What-If Analysis
15. Protection and Security
16. Conditional Formatting
17. Charting Data
18. Excel Hacks and Tips - The Practical Side
19. The Way Forward
Szczegóły książki
- ISBN Ebooka:
- 978-93-555-1045-7, 9789355510457
- Data wydania ebooka :
-
2024-12-18
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna
z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie.
Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- 1
- Rozmiar pliku ePub:
- 22.2MB
- Rozmiar pliku Mobi:
- 22.2MB
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@ebookpoint.pl
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Oceny i opinie klientów: Microsoft Excel Professional 2021 Guide CA Manmeet Singh Mehta (0)
Weryfikacja opinii następuje na podstawie historii zamowień na koncie Użytkownika umiejszczającego opinię.