Microsoft Excel Professional 2021 Guide CA Manmeet Singh Mehta
(ebook)
(audiobook)
(audiobook)
- Autor:
- CA Manmeet Singh Mehta
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 494
- Dostępne formaty:
-
ePubMobi
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
Wybrane bestsellery
-
Jeśli zastanawiasz się nad przekwalifikowaniem i karierą w branży informatycznej albo chcesz poszerzyć swoje umiejętności o programowanie, ale wydaje Ci się ono czarną magią, zapewniamy - w programowaniu nie ma nic z magii. To proces polegający na tworzeniu zbioru instrukcji, dzięki którym komputer wykona to, czego od niego oczekujesz. Jak się nauczyć pisać te instrukcje? Jeśli dysponujesz pakietem Microsoft Office i arkuszem kalkulacyjnym Excel, to masz też dostęp do języka programowania VBA (Visual Basic for Applications).- Druk
- PDF + ePub + Mobi pkt
(23,94 zł najniższa cena z 30 dni)
23.94 zł
39.90 zł (-40%) -
Oto obszerne i praktyczne wprowadzenie do pracy z usługą Power Automate. Pokazano tu, jak skonfigurować zautomatyzowane przepływy pracy, nawet jeśli procesy biznesowe wymagają korzystania z setek aplikacji. Wyjaśniono, w jaki sposób korzystać z łączników, wyzwalaczy i akcji, przedstawiono też metody zarządzania danymi użytkowników, dokumentami i zatwierdzeniami. W tym wydaniu książki zaprezentowano również nowe możliwości usługi Power Automate, takie jak zastosowanie narzędzia RPA do automatyzacji starszych aplikacji, interakcja z interfejsem API aplikacji Microsoft Graph i korzystanie z modeli sztucznej inteligencji w celu przeprowadzenia analizy sentymentu. Treść została uzupełniona rzeczywistymi przykładami i praktycznymi projektami, które pokazują, jak zastępować powtarzające się zadania nowoczesną technologią.- Druk
- PDF + ePub + Mobi pkt
(52,20 zł najniższa cena z 30 dni)
52.20 zł
87.00 zł (-40%) -
The Power Platform Administration Guide addresses the most important topic in the enterprise space today: No Code/Low Code applications. Gone are the days of thousands of lines of code. Apps are now built by business users and citizen developers with point-and-click ease. If you want to know everything about Power Platform, this book is for you-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Your All-in-One Guide to the Digital World Key Features Includes basic concepts about computer hardware and software, device connections, and the Internet. Solutions on how to get the most out of emails, office suites, photos, videos, and maps. Insights on social media, e-commerce, digital payments, and online booking. Description Technology touc-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Clear your doubts about Business Intelligence and start your new journey KEY FEATURES Includes successful methods and innovative ideas to achieve success with BI. Vendor-neutral, unbiased, and based on experience. Highlights practical challenges in BI journeys. Covers financial aspects along with technical aspects. Showcases multiple BI organizati-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
An end-to-end guide for IBM implementation partners and solution providers. Key Features Detailed step-by-step IBM Software installation and configuration that saves time for installing and configuring computers. Designed for students, IT consultants, systems and solution architects, data analysts, and developers. Unique solution documentation for-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Your guide to becoming a marketing guru and supercharge your brand with modern technologies. Key Features Industry-led best practices and real-world examples of brand successes and failures. Leading AI tools, guidelines, and templates for Marketing, Sales, and Customer Success. Advanced forms of marketing such as Consumer Neuroscience, Subliminal-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Learn techniques of project scheduling using MS Excel and Solver. Key Features Covers methods to streamlining project completion and optimising budgets. Includes techniques for resolving business problems and optimising EVM. Examines project crashing strategies, linear programming solutions, and the Solver tool. Description This book assists proj-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
A Complete Data Analytics Guide for Learners and Professionals. Key Features Learn Big Data, Hadoop Architecture, HBase, Hive and NoSQL Database. Dive into Machine Learning, its tools, and applications. Coverage of applications of Big Data, Data Analysis, and Business Intelligence. Description These days critical problem solving related to data a-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
A refresher for Java developers on how to use Selenium IDE and Selenium Grid to automate web browsers Key Features Extensive practical demonstration of Selenium with numerous real-world examples. Includes thorough examination of various test automation ideas. Covers tools in conjunction with Selenium for implementing browser and web test automatio-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
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@helion.pl.
- Język publikacji:
- 1
- Rozmiar pliku ePub:
- 22.2MB
- Rozmiar pliku Mobi:
- 22.2MB
BPB Publications - inne książki
-
Wireshark: A hackers guide to network insights Key Features Issue resolution to identify and solve protocol, network, and security issues. Analysis of network traffic offline through exercises and packet captures. Expertise in vulnerabilities to gain upper hand on safeguard systems. Description Ethical Hacking and Network Analysis with Wireshark-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Classic tricks in a modern wrap Key Features Learn fundamentals of object-oriented programming (OOP). Learn powerful creational, structural, and behavioral patterns. Apply SOLID and GoF principles for maintainable and scalable code. Description A comprehensive guide that takes you on a journey through the world of design patterns in .NET, empower-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
A comprehensive guide with basic to advanced SRE practices and hands-on examples. Key Features Demonstrates how to execute site reliability engineering along with fundamental concepts. Illustrates real-world examples and successful techniques to put SRE into production. Introduces you to DevOps, advanced techniques of SRE, and popular tools in use-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Learn Angular beyond basic concepts best practices and project experience. Key Features Includes real examples and numerous illustrated use-cases on how to build dynamic and interactive web applications. Covers true challenges faced by Angular professionals along with proven solutions and best practices. Discusses various kinds of best practices-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Build your data science skills. Start data visualization Using Python. Right away. Become a good data analyst by creating quality data visualizations using Python. Key Features Exciting coverage on loads of Python libraries, including Matplotlib, Seaborn, Pandas, and Plotly. Tons of examples, illustrations, and use-cases to demonstrate visual stor-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Explore the complex app development concepts for iOS application programming with fun and ease. Key Features In-depth knowledge with practical examples on how to develop professional iOS apps. Includes coverage on the entire iOS application development, right from designing the UI to application deployment. Get to know more about machine learning-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Think about UIs using design thinking principles from an award winning graphic designer Key Features Practical knowledge of visual design basics and typography. Understand the modern UI to kick-start your career with UI designs. Introduces you to explore UI designs for e-commerce web applications. Description From the initial introduction about t-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
A complete end-to-end guide to implement Azure Functions and serverless orchestration with the help of various use cases. Key Features Step-by-step guide along with code snippets and screenshots to master the topics. Easy handbook to brush up the fundamental concepts and advanced topics of Serverless computing. Includes real use-cases and numerous-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
An elite guide for building an exclusive distinctive career. Key Features In-depth practical demonstration of Solution Architecture concepts with examples. Incorporates graphical illustrations and visual explanations for architecture methods. Cloud-to-Cloud migration techniques, High-level, and Low-Level Design, and Emulation Tools. Description E-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Implement robust applications by applying efficient Design Patterns with .NET 5 and C# Key Features Detailed theoretical concepts covered, including the use of encapsulation, interfaces, and inheritance. Access to solutions applied for software strategy and final product output. Simplified demonstration of real applications implementing numerous d-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
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@helion.pl
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Proszę czekać...
Oceny i opinie klientów: Microsoft Excel Professional 2021 Guide CA Manmeet Singh Mehta (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.