Microsoft excel professional 2021 guide : a complete excel reference, loads of formulas and functions, shortcuts, and numerous screenshots to become an excel expert / by CA Manmeet Singh Mehta

By:

Mehta, CA Manmeet Singh [author]

Material type:

Computer fileLanguage: English Publication details: London : BPB Publications, 2023Description: 1 online resource (495, pages) : color illustrationsContent type:

text

Media type:

computer

Carrier type:

online resource

ISBN:

9789355510464 (e-book)

Subject(s):

LOC classification:

HD69 M56 2023

Online resources:

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 and 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

Summary: 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.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Materials specified	Status	Notes	Date due	Barcode
Online E-Books	Ladislao N. Diwa Memorial Library Multimedia Section	Non-fiction	OEBP HD69 M56 2023 (Browse shelf(Opens below))		Available	PAV		OEBP000469
Compact Discs	Ladislao N. Diwa Memorial Library Multimedia Section	Non-fiction	EB HD69 M56 2023 (Browse shelf(Opens below))		Room use only	PAV		CD0001398

Browsing Ladislao N. Diwa Memorial Library shelves, Shelving location: Multimedia Section, Collection: Non-fiction Close shelf browser (Hides shelf browser)

Previous								Next
Previous	OEBP HD61 P21 2023 Comprehensive guide to business risk management /	OEBP HD610 C2C26 2020 Compassionate capitalism : business and community in medieval England /	OEBP HD6285 B31 2019 Sexual orientation and transgender issues in organizations : towards an inclusive human resource practice /	OEBP HD69 M56 2023 Microsoft excel professional 2021 guide : a complete excel reference, loads of formulas and functions, shortcuts, and numerous screenshots to become an excel expert /	OEBP HD69 P75H69 2021 Becoming a PMP® certified professional : a study guide to mastering project management for the PMP® exam /	OEBP HD82 Ec7 2023 Economic empowerment and sustainable development /	OEBP HD9005 C93 2021 Current issues in global agricultural and trade policy : essays in honour of Timothy E. Josling /	Next

https://portal.igpublish.com/iglibrary/ is required to read this e-book.

Includes index

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 and 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.

Fund 164 CE-Logic Purchased February 19, 2024 OEBP000469 P. Roderno PHP 1,938.00
2024-02-0124 2024-1-113

Click on an image to view it in the image viewer