COMPLETE GUIDE FOR EXCEL 2021 FORMULAS, FUNCTIONS & AUTOMATION
There are over a thousand formulas and functions in Excel, manual entry of these functions can be so boring, hence Microsoft developed automation for Excel. Excel automation primarily involves coding in Visual Basic for Applications (VBA) by using Visual Basic language designs to integrate seamlessly with Microsoft Excel. This book is written to teach you as many Excel formulas and functions as possible and at the same time, teach you how to effortlessly automate these functions. Below is a brief insight into this book’s content:
EXCEL FORMULAS AND FUNCTIONS: The formulas and functions are the main engines that perform the major operations carried out in Excel. They are used to perform complex calculations and analysis and make your job easy. Here, you’ll learn
Meaning of a formula
How to insert formula
Meaning of Excel function
How to insert Excel function
Differences between Excel formulas and functions
Math functions
Statistical functions
Financial functions
Logical functions
Lookup and reference functions
Text functions
Date and time functions
… and lots more
EXCEL VBA AND MACROS: These are Excel programming tools that are used to automate virtually any routine Excel task. These save hours, days, maybe even weeks of manual entry in Excel as they can be used to create automated reports that are amazingly powerful. Here, you’ll learn
Meaning of Excel Macros & VBA and how they work
How to create macros in Excel to maximize your productivity
How to quickly master Excel macro development
How to work more efficiently with ranges, cells, and formulas
How to automate pivot tables to summarize, analyze, explore, and present data
How use custom dialog boxes to collect data from others using Excel
How to improve the reliability and resiliency of your macros
How to integrate data from the internet, Access databases, and other sources
How to solve sophisticated business analysis problems more rapidly
Shortcuts, tips and tricks in Excel
… and lots more
Product details
ASIN : B097XJZGNY
Publication date : June 24, 2021
Language : English
File size : 28915 KB
Text-to-Speech : Enabled
Enhanced typesetting : Enabled
X-Ray : Not Enabled
Word Wise : Not Enabled
Print length : 611 pages
Lending : Enabled
