# 300 Examples

Are you looking for Excel examples? Are you looking for clear explanations that help you master many more Excel features quickly and easily? You can find related examples and features (300 Examples) on the right side of each chapter. Below you can find an overview of all examples.

## Introduction

2 Formulas and Functions: Percent Change, Names in Formulas, Dynamic Named Range, Paste Options, Status Bar, Quick Operations.

## Basics

2 Workbook: Save in 97-2003 Format, View Multiple Workbooks, AutoRecover.

3 Worksheets: Zoom, Split, Freeze Panes, Group Worksheets, Consolidate, View Multiple Worksheets, Spelling.

5 Find & Select: Find Features, Delete Blank Rows, Row Differences, Copy Visible Cells Only, Search Box.

6 Templates: Calendar, Budget, Meal Planner, Invoice, Automated Invoice, Default Templates.

8 Keyboard Shortcuts: Function Keys.

## Functions

1 Count and Sum: Countif, Count Blank/Nonblank Cells, Count Characters, Running Total, Sumif, Sumproduct.

2 Logical: Nested If, Ifs, Switch, Roll the Dice.

3 Cell References: Copy Exact Formula, 3D-reference, External References, Hyperlinks.

6 Lookup & Reference: VLookup, Tax Rates, Case-sensitive Lookup, Offset, Left Lookup, Two-way Lookup, Locate Maximum Value, Indirect.

10 Formula Errors: IfError, IsError, Aggregate, Circular Reference, Formula Auditing, Floating Point Errors.

## Data Analysis

1 Sort: Sort by Color, Reverse List, Randomize List.

3 Conditonal Formatting: Manage Rules, Data Bars, Color Scales, Icon Sets, New Rule, Find Duplicates, Shade Alternate Rows, Compare Two Lists, Conflicting Rules, Checklist.

6 Tables: Structured References, Table Styles.

7 What-If Analysis: Data Tables, 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.

8 Macro Errors: Debugging, Error Handling, Err Object, Interrupt a Macro, Macro Comments.

9 String Manipulation: Separate Strings, Reverse Strings, Convert to Proper Case, 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.

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