# 300 Examples

Complete this section and become an Excel pro! The examples and features on this page can also be found on the right side of each chapterat the bottom of each chapter.

## Introduction+

2 Formulas and Functions: Most Used Functions | Subtract | Multiply | Divide | Square Root | Percentage | Named Range | Dynamic Named Range | Paste Options | Discount

## Basics+

8 Keyboard Shortcuts: Function Keys | Insert Row | Save As | Delete Row | Formula to Value | Scroll Lock | Bullet Points | Line Break | Show Formulas | Paste Special

## Data Analysis+

3 Conditional Formatting: Manage Rules | Data Bars | Color Scales | Icon Sets | Find Duplicates | Shade Alternate Rows | Compare Two Lists | Conflicting Rules | Heat Map

7 What-If Analysis: Data Tables | Goal Seek | Quadratic Equation

9 Analysis ToolPak: Histogram | Descriptive Statistics | Anova | F-Test | t-Test | Moving Average | Exponential Smoothing | Correlation | Regression

## VBA+

2 MsgBox: MsgBox Function | InputBox Function

3 Workbook and Worksheet Object: Path and FullName | Close and Open | Loop through Books and Sheets | Sales Calculator | Files in a Directory | Import Sheets | Programming Charts

5 Variables: Option Explicit | Variable Scope | Life of Variables | Type Mismatch

9 String Manipulation: Separate Strings | Reverse Strings | Convert to Proper Case | Instr | Count Words

13 Function and Sub: User Defined Function | Custom Average Function | Volatile Functions | ByRef and ByVal

14 Application Object: StatusBar | Read Data from Text File | Write Data to Text File | Vlookup

15 ActiveX Controls: Text Box | List Box | Combo Box | Check Box | Option Buttons | Spin Button | Loan Calculator