_Banner_Intro_Formulas_Functions-Blue.webp)
Chapter 4
Importing, Exporting & Validating Data
Import Data into Excel
Chapter 4
Importing, Exporting & Validating Data
Connect to External Data Source
Chapter 4
Importing, Exporting & Validating Data
Clean Data Imported into Excel
Chapter 4
Importing, Exporting & Validating Data
Convert Text to Columns
Chapter 4
Importing, Exporting & Validating Data
Create Data Validation Rules
Chapter 4
Importing, Exporting & Validating Data
Use Lists to Limit Values Entered into a Cell
Chapter 5
Auditing Worksheet Formulas
Manage Excel Formula Error Indicators
Chapter 5
Auditing Worksheet Formulas
Trace Formula Precedents & Dependents
Chapter 5
Auditing Worksheet Formulas
Identify and Trace Errors
Chapter 5
Auditing Worksheet Formulas
Evaluate Excel Formulas Step by Step
Chapter 5
Auditing Worksheet Formulas
Watch Cell Values
Chapter 6
Performing What-If Analysis
Create & Apply Scenarios to Excel Worksheets
Chapter 6
Performing What-If Analysis
Edit, Delete, and Summarize Scenarios
Chapter 6
Performing What-If Analysis
Create a Single-Input Data Table
Chapter 6
Performing What-If Analysis
Create a Two-Input Data Table
Chapter 6
Performing What-If Analysis
Find Target Values using Goal Seek
