### 1. File

#### 1.4 Excel Options

Editing options, save & recover options, trust center, and so on.

#### 1.5 Excel Templates

Create, edit, and apply templates in Excel.

#### 1.6 File Format Converter

Convert between Excel workbooks and PDF / CSV / HTML / TXT files, and convert between XLSX files and XLS files.

#### 1.8 Page Setup

Set header and footer, page numbers, page breaks, watermark, and others in Excel workbooks.

### 2. Edit

#### 2.15 Split Cells, Columns, or Ranges

Split cells by delimiters or width, split names, split text and numbers, split to rows, and split columns/range, etc.

### 3. Insert

#### 3.7 Insert List of values

Custom list, list of combinations or permutations, list of dates or weekdays, list of sheets or files or folders, list of unique values, etc.

### 6. Review & Security

#### 6.2 Protect sheets

Automatically protect worksheets, protect multiple worksheets in bulk, edit protected worksheets, and prevent operations in protected worksheets, etc.

#### 6.3 Protect workbooks

Protect multiple workbooks, protect workbook templates, and share workbooks.

### 7. Calculation & Formulas

#### 7.3 Math Functions

• 7.3.1 SUM
Sum with criteria, sum across sheets, sum excluding cells, sum until meeting condition, sum visible cells only, and sum calculations.
• 7.3.2 ROUND
Round up, round down, round even, round odd, round date/time, etc.
• 7.3.3 ABS, SQTR, SUMIF, and SUMPRODUCT

#### 7.4 Statistic Functions

• 7.4.1 AVERAGE
Calculate average by date or criteria, average ignoring zeros or special values, weight average, and other average calculations.
• 7.4.2 COUNT
Count cells with criteria, count characters or works in cells or ranges, count days between two dates, count duplicate, unique values, or other special cells, count ignoring cells, count sheets or workbooks, and other counting calculations.
• 7.4.3 MAX & MIN
Find max or min value with criteria, find max or min value in a group, find max or min excluding special values (says 0), find the nth highest or smallest values, etc.
• 7.4.4 RANK
Calculate rank percentile, rank with criteria, rank across worksheets, rank ignore special values (says 0), etc.
• 7.4.5 MEDIAN, PERCENTILE, QUARTILE, etc.

#### 7.5 User Defined Functions

• 7.5.1 Edit Cells
Apply user defined functions to change cell content, combine cells/rows/columns, convert, delete or clear cell content, extract content, fill cell content, split cell content, and so on.
• 7.5.2 Calculation
Apply user defined functions to statistic, do math calculations, look for values, date/time calculations, and so on.
• 7.5.3 Inserting, formatting, data, etc.

#### 7.6 Formula Examples

This section lists articles that use formulas to solve problems in Excel. The articles and Excel functions applied in the corresponding articles are separated and displayed in two columns.

#### 7.7 Formula Applications

Do addition, subtraction, multiplication, division with formulas, calculate percentages, calculate interest/payment/tax/price, etc.

#### 7.8 Calculation Options

Hide, highlight formula errors, or replace formula errors with 0, blank, or certain text; ignore blank or zero, show or hide formula, show or hide trace arrows, update formulas, and so on.

#### 7.9 Other Formula Tips

Change, lock cell references in formulas, copy formulas, replace formulas with their calculation result, named ranges, and other formula tips.

### 8. Developer

#### 8.2 Macros & VBA

• 8.2.1 File
Apply VBA code to set Excel options, import/export worksheets, workbooks, graphics, csv/text/pdf files, save/close/open workbooks, configure page setup, print, view, etc.
• 8.2.2 Insert
Apply VBA code to insert illustrations, links, lists, PivotTable/PivotChart, rows/columns, and other objects in Excel easily.
• 8.2.3 Edit
Apply VBA code to change cell content, combine cells/ranges/sheets, convert numbers/file format, copy/paste, delete or clear content and formatting, fill cell content, find and replace, go to cell, range, or sheets, etc.
• 8.2.4 Format
Apply VBA code to configure conditional formatting, format cells, and so on.
• 8.2.5 Data
Check data with VBA code, or apply VBA code to set data validation, filter, sort, etc.
• 8.2.6 Review & Security
Apply VBA code to add, change, format comments, protect cells/sheets/workbooks, and so on.
• 8.2.7 Calculation
Use VBA code to configure calculation options, do math calculations (including sum, count, average, round, rank, etc.), and others.
• 8.2.8 Developer
Apply VBA code to insert, format, or delete controls, macros, and others.
• 8.2.9 Mailings and others
Apply VBA code to send emails, set signatures, add attachments, and other operations in Excel as well.

### 9. Shortcut Keys

Many users prefer to shortcut keys to help themselves work more effectively in Excel. This section collects articles which use frequently used shortcuts, function keys, etc. to solve problems in Excel. For example, press Ctrl + ; keys to insert the current date, press Shift + Enter keys to jump to the last cell of current selection, and so on.