Excel 2019 All-In-One: Master the new features of Excel 2019 Lokesh Lalwani
(ebook)
(audiobook)
(audiobook)
- Autor:
- Lokesh Lalwani
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 284
- Dostępne formaty:
-
ePubMobi
Zostało Ci
na świąteczne zamówienie
opcje wysyłki »
opcje wysyłki »
Opis
książki
:
Excel 2019 All-In-One: Master the new features of Excel 2019
100% practical guide to understand and use Basic to Advance level Excel 2019
Key FeaturesWhats New in Excel 2019 / Office 365
Putting Data into Excel
Transforming and Managing the Data
Formulas and Functions
Data Analysis techniques
Data Visualization techniques
Multiple ways of Data Extraction
Automation in Excel through Macros
Description
Excel is, by far, the most preferred spreadsheet program on this planet. People love it because of its simplicity and easy user interface. The primary focus of Excel is to perform basic to advanced level numeric calculations. Every industry, department, job role is dependent on Excel to perform day to day duties as well as data analysis and visualization. Microsoft Excel is available in both offline (Excel 2019) and online (Office 365) versions.
If you are new to Excel or use this program day in day out, then this book will surely clear your logics and concepts of excel.
This book starts with an introduction to Excel program and an overview of its interface and move towards an explanation of new features being introduced in Excel 2019 and Office 365, then an in-depth discussion on entering and transforming data. Understanding different formulas and functions with practical exercises. Afterwards, how to perform data analysis and present it using different data visualization tools. Finally, extracting data and automation of tasks through Macros.
After going through this book, you will become conceptually strong in using various features of Excel. You will increase your productivity by understanding and using the right tool for the related data set.
What Will You Learn
By the end of the book, you will come across many case studies to put your knowledge to practice and understand many tools to solve real-life business problems such as importing data into Excel from different sources, data cleaning through various tools including flash fill, bringing data together into one place using lookup functionality, analysing it to get insights through pivot tables & what if analysis, generating forecast based on past trends, exporting final reports, understanding Power features like Power Pivot/Query/Map and automating manual processes through Macros . Remember to practice along with sample data files provided in the exercise files bundle of the book to master these techniques.
Who This Book Is For
This book is for anyone who is either new to Excel or daily Excel user. This book will take you from basic concepts of Excel to Advanced level. Whether you belong to any industry or serving any department, as an Excel user, this book will make you a Pro in Excel.
Table of Contents
1. Whats New in Excel 2019/Office 365
2. Entering Data in Excel
3. Transforming and Managing Data
4. Formulas and Functions
5. Data Analysis
6. Data Visualization
7. Data Extraction
8. Automation in Excel through Macros
About the Author
Lokesh Lalwani, is a Microsoft Certified Office Expert with over a decade of experience in the field of training. He is a seasoned entrepreneur and Co-founder of a renowned corporate training firm - Nurture Tech Academy.
He has conducted 1,000 plus corporate workshops on various technologies like Advanced Excel, Business Presentations, Power BI etc. and trained over 12,000 professionals. He is also sharing his knowledge through 5 pre-recorded courses, on above mentioned technologies, over worlds most popular E-learning platforms with an average rating of 4.5/5 from over 15,000 learners. He believes in life is learning.
His Blog: https://www.nurturetechacademy.in/blog/
His LinkedIn Profile: https://in.linkedin.com/in/lokesh-lalwani-7a6b6b55
Key Features
Description
Excel is, by far, the most preferred spreadsheet program on this planet. People love it because of its simplicity and easy user interface. The primary focus of Excel is to perform basic to advanced level numeric calculations. Every industry, department, job role is dependent on Excel to perform day to day duties as well as data analysis and visualization. Microsoft Excel is available in both offline (Excel 2019) and online (Office 365) versions.
If you are new to Excel or use this program day in day out, then this book will surely clear your logics and concepts of excel.
This book starts with an introduction to Excel program and an overview of its interface and move towards an explanation of new features being introduced in Excel 2019 and Office 365, then an in-depth discussion on entering and transforming data. Understanding different formulas and functions with practical exercises. Afterwards, how to perform data analysis and present it using different data visualization tools. Finally, extracting data and automation of tasks through Macros.
After going through this book, you will become conceptually strong in using various features of Excel. You will increase your productivity by understanding and using the right tool for the related data set.
What Will You Learn
By the end of the book, you will come across many case studies to put your knowledge to practice and understand many tools to solve real-life business problems such as importing data into Excel from different sources, data cleaning through various tools including flash fill, bringing data together into one place using lookup functionality, analysing it to get insights through pivot tables & what if analysis, generating forecast based on past trends, exporting final reports, understanding Power features like Power Pivot/Query/Map and automating manual processes through Macros . Remember to practice along with sample data files provided in the exercise files bundle of the book to master these techniques.
Who This Book Is For
This book is for anyone who is either new to Excel or daily Excel user. This book will take you from basic concepts of Excel to Advanced level. Whether you belong to any industry or serving any department, as an Excel user, this book will make you a Pro in Excel.
Table of Contents
1. Whats New in Excel 2019/Office 365
2. Entering Data in Excel
3. Transforming and Managing Data
4. Formulas and Functions
5. Data Analysis
6. Data Visualization
7. Data Extraction
8. Automation in Excel through Macros
About the Author
Lokesh Lalwani, is a Microsoft Certified Office Expert with over a decade of experience in the field of training. He is a seasoned entrepreneur and Co-founder of a renowned corporate training firm - Nurture Tech Academy.
He has conducted 1,000 plus corporate workshops on various technologies like Advanced Excel, Business Presentations, Power BI etc. and trained over 12,000 professionals. He is also sharing his knowledge through 5 pre-recorded courses, on above mentioned technologies, over worlds most popular E-learning platforms with an average rating of 4.5/5 from over 15,000 learners. He believes in life is learning.
His Blog: https://www.nurturetechacademy.in/blog/
His LinkedIn Profile: https://in.linkedin.com/in/lokesh-lalwani-7a6b6b55
Szczegóły książki
- ISBN Ebooka:
- 978-93-885-1158-2, 9789388511582
- Data wydania ebooka :
-
2024-12-13
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:
- 46.7MB
- Rozmiar pliku Mobi:
- 46.7MB
- Zgłoś erratę
- Kategorie:
Programowanie
Technologie webowe » Node.js
Technologie webowe » AngularJS
Aplikacje biurowe » Excel
Technologie webowe » Bootstrap
Technologie webowe » AJAX
Technologie webowe » CSS
Technologie webowe » JavaScript - Programowanie
Technologie webowe » JSP i JavaServlet - Programowanie
Serwery internetowe » Apache
Technologie webowe » React
Technologie webowe » jQuery - Programowanie
Programowanie » Go - Programowanie
BPB Publications - inne książki
-
Description This book comprehensively covers essential topics ranging from the fundamentals of cybersecurity to advanced hacking concepts, cyber law, malware detection, wireless networking, and strategies for staying secure in the digital world. This book starts with networking and security basics, covering network models, communication protocols,-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Unlock the power of AWS and elevate your cloud expertise with "Mastering AWS for Cloud Professionals." This comprehensive guide illuminates the path to cloud mastery, offering a blend of theoretical knowledge and practical expertise. Dive deep into Amazon Web Services (AWS), exploring its vast potential to revolutionize business operati-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book explores how AI, blockchain, and the IoT can work together to build a more sustainable and efficient tech ecosystem. This book breaks down complex concepts, making them accessible to readers of all backgrounds. By focusing on the convergence of these technologies, it reveals how they are shaping a future where autonomous syste-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book offers a comprehensive overview of the Mendix platform from a developer's perspective. This powerful technology breaks down barriers, allowing anyone, with or without coding experience, to build custom applications quickly and efficiently with a solid foundation for platform evaluation. Key topics include Mendix's database des-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description This book will cover the entire System Center at the latest release of 2022. Here, we will cover various grounds by not only covering the purpose of each product within the System Center suite but also introducing all the latest features and updates that come with each product. Windows System Center 2022 is a complete toolkit for simpli-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Introducing "Salesforce Automation with Salesforce Flow and Apex", a practical guide designed for anyone wanting to learn Salesforce automation. Whether you are just starting out or looking to build on your existing skills, this book is here to help you navigate the world of Salesforce flow and automation techniques. This book provides-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Adopting AI for Business Transformation offers a comprehensive guide for businesses ready to transition into AI and automation and transform their operations and ways of working. The book focuses on various industries providing practical insights and step-by-step guides for AI adoption and integration. Through real-world examples, exper-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description Mastering AWS Elastic Kubernetes Services" is your comprehensive guide to understanding and implementing AWS EKS. This book helps you master Kubernetes, the industry-standard container orchestration platform, on the robust and scalable Amazon Web Services (AWS) cloud. This book is a complete guide to Kubernetes and AWS EKS, starting wit-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Description PostgreSQL, a robust and versatile relational database management system (RDBMS), is gaining immense popularity due to its reliability, scalability, and rich feature set. This book is your indispensable companion to mastering PostgreSQL, helping you become a great PostgreSQL developer and create amazing database-driven applications. Thi-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
-
Get answers to frequently asked questions on Data Science and Machine Learning using R Key Features Understand the capabilities of the R programming language Most of the machine learning algorithms and their R implementation covered in depth Answers on conceptual data science concepts are also covered Description This book prepares you for the-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
67.43 zł
89.90 zł (-25%) -
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: Excel 2019 All-In-One: Master the new features of Excel 2019 Lokesh Lalwani (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.