Excel In 7 Days : Master Excel Features & Formulas. Become A Pro From Scratch In Just 7 Days With Step-By-Step Instructions, Clear Illustrations, And Practical Examples

Copyright © 2022 By PAUL SLATKIN
 INTRODUCTION
 CHAPTER ONE- BRIEF INTRODUCTION TO SOME EXCEL BASIC
 How does the formula in Excel look?
 Define and use names in Excel formula
 Naming a cell (For Windows users)
 Define names from a selected range
 Managing names in your workbook with Name Manager
 Naming a cell (For macOS users)
 Define names from a selected range
 Use names in formulas
 Deleting or removing a formula in your Excel workbook
 How to delete a formula but keep the result of the formula (for Windows users)
 Delete a formula but keep the results (for web users)
 Avoiding broken formula in Excel
 Does your function actually start with an equal to sign?
 Is the opening parentheses matching with the closing parentheses?
 Does your formula contain multiplication without the asterisk symbol?
 Ensure that you are evaluating a nested formula one after the other
 CHAPTER TWO - EXCEL FORMULA COMMONLY USED IN BUSINESS ANALYTICS
 Calculating Percent of Goal
 How it works
 Formula: Calculating Percent Variance
 How it works
 Alternative: Simplified percent variance calculation
 Formula: Calculating Percent Variance with Negative Values
 How it works
 Formula: Calculating a Percent Distribution
 How it works
 Alternative: Percent distribution without a dedicated Total cell
 Formula: Calculating a Running Total
 How it works
 Formula: Applying a Percent Increase or Decrease to Values
Formula: Dealing with Divide-by-Zero Errors
 How it works
 The “IF” function
 The “IF” syntax
 Simple IF cases
 Using the “IF” function to confirm if a cell is blank
 Formula: Basic Rounding of Numbers
 How it works
 Formula: Rounding to the Nearest Penny
 How it works
 Formula: Rounding to Significant Digits
 How it works
 Formula: Counting Values in a Range
 How it works
 Formula: Creating a Conversion Table
 How it works
 CHAPTER THREE- MANIPULATING TEXTS WITH FORMULA
 Formula: Joining Text Strings
 How it works
 Formula: Setting Text to Sentence Case
 What is the TRIM Function?
 Formula
 A few notes about the TRIM Function:
 How to use the TRIM Function in Excel?
 Example 1
 Example 2
 Example 3
 What is the FVSCHEDULE Function?
 Formula
 Example
 Few things to know about the FVSCHEDULE Function
 Using functions and Nested functions in Excel formula
 Excel function syntax
 Entering Excel functions
 Nesting Excel functions
 What is the ACCRINT Function?
 Formula
 How to employ the ACCRINT Function in Excel
 Example 1
 Example 2 – Using DATE with ACCRINT
 What is the CUMIPMT Function?
 Formula
 How to use the CUMIPMT Function in Excel
 Example 1
 What Is the Excel FV Function?
 How to use the FV Function in Excel
 Example 1 – FV function Excel
 Example 2 – FV function Excel
 What is the IPMT Function?
 Formula
 How to use the IPMT Function in Excel
What is the NPER Function?
 Formula
 How to use the NPER Function in Excel
 Example 1
 Example 2
 What is the PDURATION Function?
 Formula
 How to use the PDURATION Function in Excel
 Example 1
 VLOOK UP
 VLOOKUP Formula
 How to get started
 How to use VLOOKUP in Excel
 What is the CELL Function?
 Formula
 How to use the CELL function in Excel
 Example – Finding a certain value
 Things to remember
 What is Excel ISBLANK Function?
 Formula
 How to use the Excel ISBLANK Function
 How to carry out conditional formatting
 What is the ISERROR Excel Function?
 Formula
 How to use the ISERROR Excel Function
 Example 1
 Example 2
 What is the ISEVEN Function?
 Formula
 How to deploy the ISEVEN Function in Excel
 Example 1
 Example 2
 How to create conditional formatting
 How this formula worked:
 Things to remember about the ISEVEN Function
 What is the ISTEXT Function?
 Formula
 How to deploy the ISTEXT Function in Excel
 Example 1
 Example 2
 How to apply this formula?
 Example 3
 These are some useful things to look out for while using the ISTEXT
 What is the TYPE Function?
 Formula
 How to use the TYPE Function in Excel
 Example 1
 A few things to remember about the TYPE Function
 What is the AND Function?
 Formula
 Notes:
How to employ the AND Function in Excel
 Example 1
 Example 2
 Things to Remember about the AND Function
 Using the “IFS” Function
 Simple syntax
 Example 1
 Remarks
 What is the NOT Function?
 Formula
 How to use the NOT Function in Excel
 Example 1
 Example 2
 Example 3
 How it works
 Alternative: Calculating Markup
 Calculating the EBIT and EBITDA
 How it works
 Calculating Cost of Goods Sold
 How it works
 Calculating Return on Assets
 How it works
 Calculating Break Even
 Calculating Customer Churn