| Excel Beginner Outlines |
| Excel 2010 Beginner 1 |
Running Time 1 hr, 29 min
00. Intro (9:50)
01. Excel Interface 1 (6:22)
Starting Excel
The Ribbon Changes with Window Size
Title Bar
Maximize, Minimize, Restore Down
Close Button
File Tab - Backstage View
02. Excel Interface 2 (7:06)
The Ribbon
Ribbon Tabs, Groups, Buttons
Help Popup Menus for Each Command
Command Buttons
Drop-Down Menus
Command Button Groups
Galleries
Dialog Box Launcher Buttons
03. Excel Interface 3 (5:30)
Quick Access Toolbar
Adding or Removing a Command from QAT
Status Bar
Views Buttons
Zoom Controls
Scroll Bars
04. Excel Interface 4 (5:55)
Formula Bar
What is a Spreadsheet
Columns, Rows, Cells
Name Box
Mouse Pointer
Sheet Tabs
05. Entering Data (5:19)
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Select a Cell with Mouse
Select a Cell with Keyboard
Move with ENTER, TAB
Move with Arrow Keys
Entering Data
06. Editing Data (7:37)
Editing data in a cell
Four methods for editing data
Overtyping your data
Replacing data in your cells
Editing data using the Formula Bar
Editing a cell by double-clicking
Backspace vs. Delete Keys
Edit Mode with F2
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel
07. Formatting 1 (6:14)
Home, Alignment
Formatting your text
Horizontal cell alignment
Align Right, Left, Center
Format multiple cells at once
A Cell Range defined
Cell Range Notation (A1:B5)
Selecting cell rangess
Bold, Italics, Underline
08. Formatting 2 (8:40)
Changing the Font
Live Preview
Change Font Size Dropdown
Type in a Font Size Manually
Increase Font Size
Decrease Font Size
Resizing Columns
Changing Column Width
Resize Column with Double-Click
Resizing Rows
Background Color / Fill Color
Foreground Color / Font Color
09. Basic Math 1 (7:48)
Moving to a different sheet tab
Using a "scratch" sheet
Adding two cells together
How Formula Work in Excel
Auto Recalculation of Formula
See Formula in Formula Bar
See Result on the Sheet
Basic math operators
Addition
Subtraction
Multiplication
Division
Exponentiation
Using Constants
Clearing a range of cells
Selecting an Entire Column
10. Basic Math 2 (5:11)
Adding Multiple Cells
Select to See Summary in Status Bar
Click to Add Cell to Formula
Order of Operations
Using parentheses in math operations
Average a Group of Cells
11. Save, Load, Print (8:24)
Saving Your Workbook File
Save As a Different File
Open Recent Documents
Open Any Document
Pinning Documents to the List
Create a New Blank Workbook
Print Preview
Print Your Spreadsheet
12. Review (4:57)
|
|
| Excel 2010 Beginner 2 |
Running Time: 1 hour, 28 minutes
00. Intro (7:37)
01. Cut Copy Paste (9:30)
The Clipboard
Copy, Paste
Cut, Paste
Formula References Updated
Paste Multiple Times
Clipboard Heyboard Shortcuts
02. Autofill (7:46)
Autofill a Formula
Autofill Handle
Mistakes
Moving a cell
Move a Cell Value
03. Cell Formats 1 (10:39)
Text, Number
Missing Leading Zeros
Currency, Accounting
Short Date, Long Date
04. Cell Formats 2 (7:32)
Fraction
Mixed Fraction
Percentage
Increase Decimal
Decrease Decimal
Comma Style
Scientific Style
05. Rows & Columns (9:42)
Clear v. Delete
Selecting Multiple Columns
Delete Columns
Delete Rows
Right-Click Delete
Insert Column
Insert Row
Insert Multiple Row
Clear Contents
06. Sheets (9:34)
Insert New Worksheet
Delete Worksheet
Rename Sheet
Moving Sheets
Copying a Sheet
Sheet Tab Color
07. Sorting Data (6:25)
Sort A to Z
Dealing with Total Rows
Select Everything First
Sort on a Different Column
Use TAB to Change Columns
08. Conditional Formatting (8:03)
Highlight Cells Rules
Greater Than, Less Than
Above Average
Multiple Conditions
Clear Formatting from Sheet
Data Bars
Color Scales
Icon Sets
09. Find & Replace (7:35)
Find Data
Find Next
Find All
Replace
Replace All
10. Review (4:40)
|
|
| Excel 2010 Beginner 3 |
Running Time: 1 Hour, 40 Minutes
00. Intro (8:00)
01. Functions 1 (8:14)
What is a Function
The SUM Function
Benefits of Functions
02. Functions 2 (9:42)
AVERAGE Function
COUNT
MAX, MIN
Move a Block of Cells
03. Functions 3 (11:17)
Practice with Functions
The Key Cell Format Trick
Insert New Month of Sales
AutoFill Multiple Cells
04. Styles & Themes (9:03)
Selecting Cell Styles
Using Styles to Format
Changing Themes
Theme Colors vs. Standard Colors
05. Page Layout (11:55)
Margins
View, Page Layout
Print Preview
Orientation
Page Size
Set Print Area
Clear Print Area
Page Breaks
Background
Gridlines: View, Print
Headings: View, Print
06. Illustrations 1 (13:11)
Insert a Picture
Move and Resize a Picture
Rotate Picture
Picture Tools, Format Tab
Brightness, Contrast
Reset Picture
Compress Pictures
Delete a Picture
Insert Clipart
07. Illustrations 2 (11:38)
Insert Shapes
Rectangle
Drawing Tools, Format Tab
Shape Styles
How Themes Effect Shape Styles
Shape Outline
Shape Effects
Add Text
Format Text
Quick Mini Toolbar Popup
WordArt Styles
Inserting an Arrow
08. Illustrations 3 (12:39)
Insert SmartArt
Basic Process
Format SmartArt Options
Screenshots
Screen Clippings
Insert WordArt
WordArt Options
09. Review (5:03)
|
|
| Excel 2010 Beginner 4 |
Running Time: 1 Hour 38 Minutes
00. Introduction (8:46)
01. Charts 1 (10:51)
What is a Chart
Parts of a Chart
Insert a Column Chart
02. Charts 2 (11:24)
Add Data to an Existing Chart
Line Charts
Multiple Series in a Chart
Chart Styles & Themes
03. Charts 3 (16:14)
Selecting Non-Contiguous Data
3D Pie Charts
Move a Chart to a Different Sheet
Format Objects Inside Charts
Chart Layouts
Leader Lines
Change Chart Type
3D Column Charts
Stacked 3D Column Chart
04. Charts 4 (13:52)
Switch Row/Column
Current Selection Box
Format Selection
Reset to Match Style
Insert Shapes
Insert Text Box
Labels
Chart Title
Axis Titles
Legend
Data Labels
Data Table
05. Charts 5 (13:15)
Copy Excel Charts into Word
Creating a Summary Sheet / Dashboard
Separate a Slice of Pie
Create a Leader Line
06. Tables (17:05)
Creating a Table
Why Use a Table
Table Styles
Table Formulas are Uniform
New Rows Automatically Copy Formulas
Sort in a Table
Filter in Tables
Turn off Filtering
Total Row
Insert New Row
07. Review (6:46)
|
|
| Excel 2010 Beginner 5 |
Running Time: 1 Hour 46 Minutes
00. Introduction (9:35)
01. Insert Text 1 (9:45)
Insert > Text Group
Insert Hyperlink
Web Page Hyperlinks
Email Hyperlinks
Link to Customer Address
Link to Google Maps
02. Insert Text 2 (13:07)
Insert Text Box
Insert WordArt
Insert Signature Line
Insert Object
Insert Symbol
03. Header & Footer (12:55)
Insert Header & Footer
Three Sections
Header & Footer Elements
Entering Text in Header
&[Page] Code for Page Number
Page 1 of 2
Page Footer
Date Code
Insert Picture
Header & Footer Templates
Go To Footer, Header
04. View Window (12:25)
Working with Large Sheets
Create a Large Sheet of Data
Freeze Panes
Freeze Top Row
Freeze First column
Split the Window
05. Borders (7:42)
Print Preview
Zoom to Page
Printing Gridlines
Changing Borders
Top, Left, Right, Bottom
Inside, Outside Borders
Thick Borders
06. Misc Format Tricks (9:22)
Merge and Center
Merge Across
Merge Cells
Unmerge Cells
Cell Orientation
Format Painter
Double-Click Trick
07. Comments (5:56)
Insert Comment
Edit Comment
Delete Comment
Show, Hide Comments
Previous, Next Comment
08. Research (10:00)
Spell Check
Thesaurus
Getting Stock Quotes
Translate
09. Office Online Templates (11:47)
How to Download Templates
Calendar Template
Invoice Template
Home Mortgage Template
10. Review (4:07) |
|
| | Excel Expert Outlines |
| Excel 2010 Expert 1 |
Running Time: 68 Minutes
00. Intro (7:20)
01. Working With Functions (10:06)
Typing in a function
Function library
Grouped categories of functions
AutoSum button
Changing the AutoSum function
Insert Function dialog
CONCATENATE function
Argument Select Buttons
Concatenate with the & sign
02. Relative v Absolute References (8:53)
What is an Absolute Reference?
What is a Relative Reference?
Reference behavior with AutoFill
Sales Tax Rate example
F4 keyboard trick
03. Named Cells and Ranges (7:03)
What is a Named Cell
Create a Name with the Name Box
Jump to a Named Cell
Define Name button
Name Manager
Edit, Delete Names
Create a Named Range
Named Range example with SUM
04. Values on Other Sheets (10:05)
Refer to a Cell on Another Sheet
=SheetName!CellName
Moving a Named Cell
Copy, Paste Link
Creating a Summary Sheet
05. Text Functions 1 (14:10)
Checking if Two Strings are Equal
=A1=B1
EXACT
CONCATENATE
=A1&B1
LEN
LEFT
RIGHT
MID
FIND
Separate First and Last Names
SEARCH
06. Text Functions 2 (6:23)
SUBSTITUTE
REPLACE
TRIM
07. Review (4:27)
|
|
| Excel 2010 Expert 2 |
| Running Time: 1 Hour 33 Minutes
00. Intro (7:49)
01. Excel Dates & Times (9:12)
Valid Date Formats
Valid Time Formats
Valid Date/Time Formats
Understanding Internal Dates
Date Arithmetic
Adding Days
Adding Hours
02. Custom Date/Time Codes (6:33)
Customizing Date Formats
Custom Date & Time Codes
03. Date/Time Functions 1 (11:11)
Current System Date/Time
Current Time
NOW()
F9 to Recalculate
Current Date
TODAY()
Calculating the Time Only
Components of a Date
YEAR, MONTH, DAY
HOUR, MINUTE, SECOND
WEEKDAY
Changing WEEKDAY Start Day
Building a Date from Components
DATE
Buildnig a Time from Components
TIME
Adding Dates with DATE Function
Adding Times with TIME Function
04. Date/Time Functions 2 (14:13)
Calculate Difference in Dates
Calculate Age in Years Using Math
INT function
Difference in Whole Years
YEARFRAC
DATEDIF
Difference in Months Between Dates
05. Date/Time Functions 3 (13:49)
Converting Bad Imported Dates
Convert 20110801 to 8/1/2011
Review of LEFT, RIGHT, MID
Convert Text Date to Actual Date
DATEVALUE, TIMEVALUE
EDATE
Determine Last Day of the Month
EOMONTH
Work Days Between Two Dates
NETWORKDAYS
Custom List of Excluded Holidays
Count Number of Workdays Forward
WORKDAY
NETWORKDAYS.INTL
WORKDAY.INTL
Custom Work Days String "0000011"
Week Number of the Year
WEEKNUM
06. Date/Time Functions 4 (12:04)
AutoFill with Days of the Week
AutoFill Date Options
Fill Days, Months, Years, Weekdays
Subtract Two Times
Format as a Number
Convert Days to Hours
Display Hours and Fractions
Display Hours and Minutes
Adding up hours with [h]:mm
07. Date/Time Tips & Tricks (13:57)
Creating a series of dates with AutoFill
Calculating specific dates
First day of a month
Last day of a month
Number of days in a month
What quarter is a date in
First day of the year
Last day of the year
Day number (of the year)
Days remaining in the year
Inserting the current date and time
Adding up hours, minutes, seconds
[h]:mm
[mm]:ss
Displaying fractions of a second
h:mm:ss.00
08. Review (4:28)
|
|
| Excel 2010 Expert 3 |
| Running Time: 1 Hour 11 minutes
00. Intro (6:29)
01. Logic Functions (19:05)
TRUE, FALSE Values
0 = FALSE
AND, OR, NOT
Is an invoice late?
Is an invoice paid?
Collection Letter Example
Shipping an Order Example
Credit Card Batching Example
TRUE, FALSE Functions
02. IF Function 1 (14:18)
IF THEN Statement
IF THEN ELSE Statement
Charge Sales Tax Example
Set Tax Rate if in NY
Calculate Sales Tax
Calculate Credit Card Batch Total
Give Students PASS or FAIL Grade
03. IF Function 2 (14:05)
Nested IF Functions
Assign a Letter Grade with IF
Fixing Our Time Sheet Example
Shifts That Cross Over Midnight
Calculating Overtime Pay
04. IS Functions (14:05)
ISBLANK, ISERROR
ISEVEN, ISODD
ISLOGICAL, ISNUMBER
ISTEXT, ISNONTEXT
Extra Space Between Names
FN, MI, LN
"Mr.", "Mrs.", or "Mr. & Mrs."
Divide by Zero errors
ISERROR to fix #DIV/0!
IFERROR to fix #DIV/0!
05. Review (3:20)
|
|
| Excel 2010 Expert 4 |
Running Time: 1 Hour 10 minutes
00. Intro (5:58)
01. VLOOKUP 1 (8:10)
Look up week day name
VLOOKUP simple function
Lookup Value
Table Array
Column Index Number
Problem With AutoFill
Use Absolute Reference
Use Named Range
02. VLOOKUP 2 (7:01)
Student Letter Grades
Range Lookup
Assign A to F
Convert to Table
Hide empty values
IF and ISBLANK
03. VLOOKUP 3 (9:22)
Employee Time Sheet
Employee List Table
Rename a Table
Timecard Worksheet
Exact Match Lookup
Lookup Employee Name
Lookup Pay Rate
Calculate Hours Worked
Calculate Total Pay
04. Other Lookups (13:50)
HLOOKUP
LOOKUP
MATCH, INDEX
Less Than
Exact Match
Greater Than
Wildcard Match
Backward Lookup
Searching an Array
05. Cell References (10:26)
Construct a cell reference
Deconstruct a cell reference
ADDRESS
INDIRECT
Year to date sales figure
Sales between two months
06. Compare Two Lists (4:18)
Use MATCH to compare
Is item in list missing
ISNA
07. Closest to Value (7:06)
Which value is closest to target
Calculate Difference
Autofill Double-Click Trick
ABS Absolute Value
MIN to find closest value
MATCH to locate the value
INDEX to determine winner
Closest to average value
|
|
| Excel 2010 Expert 5 |
Running Time 1 Hour, 5 Minutes
00. Intro (5:49)
01. More With SUM (5:01)
Non-contiguous ranges with SUM
Insert function with multiple ranges
Running balance
Running total
02. SUMIF (11:05)
Add up values with specific criteria
">=100"
Variable criteria
">="&A1
SUMIF, COUNTIF, AVERAGEIF
Sum Range vs. Criteria Range
Make sure to use absolute references
03. SUMIFS (10:03)
Sum of commissions by sales rep
Commissions by rep over $100
Orders past due
Unpaid orders past due
SUMIFS, COUNTIFS, AVERAGEIFS
04. Counting & Rounding (11:29)
COUNT
COUNTA
COUNTBLANK
What you see isn't necessarily valid
Decrease decimal hides true value
ROUND
ROUNDUP
ROUNDDOWN
MROUND
CEILING
FLOOR
INT
TRUNC
05. Misc Math (13:03)
MEDIAN
MODE
PRODUCT
Scientific Notation
4.19E+23
POWER
SQRT
10^2
Integer Division
QUOTIENT
MOD
Modulus
ABS
SIGN
Random Numbers
RAND
RANDBETWEEN
Turn off Automatic Recalculation
F9 to Recalculate
06. Trigonometry (5:10)
SIN, COS, TAN
PI
RADIANS
DEGREES
Calculate Height of a Building
07. Review (3:08)
|
|
| Excel 2010 Expert 6 |
RunningTime: 1 Hour, 8 Minutes
00. Intro (6:14)
01. Financial Terms (4:49)
PV, FV, PMT, RATE, NPER
APR (Annual Percentage Rate)
Simple Interest
Compound Interest
02. Loan Calculator (9:39)
Calculate Mortgage Payment
PMT function
Compare Multiple Scenarios
03. Investment Calculator (5:03)
FV Future Value Function
Calculate Investment in 5 Years
04. Interest Rate Calculator (6:09)
What is your Return on Investment
RATE function
Calculate interest rate
05. Millionaire Calculator (6:01)
NPER Function
How many years until goal reached
06. Initial Deposit Calculator (2:29)
PV Function
What was the initial deposit?
07. Home Value Calculator (4:04)
How much house can I afford
PV function
Optional FV and TYPE parameters
08. Loan Amortization (12:10)
Microsoft's Amortization Template
Create your own amortization table
IPMT, PPMT functions
Cumulative interest and principal paid
CUMPRINC, CUMIPMT
09. Credit Card Payments (6:08)
How many payments at minimum
How long to pay off card debt
What payment to pay off in 6 months?
NPER and PMT
10. Review (4:44)
|
|
| Excel 2010 Expert 7 |
Running Time: 1 Hour, 5 Minutes
00. Intro (5:55)
01. What is a PivotTable (4:58)
Why are they useful?
What you can do with them.
02. Our First PivotTable (6:07)
Create Data Table
Optional download from web site
Create PivotTable
Set Row Labels
Set Column Labels
Set Values
Change from Count to Sum
03. Editing Your PivotTable (8:28)
Changing Fields
Multiple Fields per Axis
Expanding / Collapsing Levels
Filter & Sort Data
Label Filter
Value Filter
Report Filter
"Pivoting" Your Table
04. PivotTable Options (12:42)
Multiple Sets of Values
PivotTable Pane Layout Mode
Defer Layout Update
PivotTable Options Menu
For Empty Cells Show
Group / Ungroup
Slicers
Select Multiple Items
Slicer Settings
Multiple Slicers
05. PivotTable Design (5:14)
Layout
Show Subtotals
Grand Totals
Report Layout
Blank Rows
Row & Column Headers
Banded Rows / Columns
PivotTable Styles
Double-Click to Create Data Subset
06. PivotCharts (4:51)
Creating a PivotChart
PivotChart Options
07. Grouping Data (11:47)
Group by Month
Table Better Than Range
Refresh
Change Data Source
Group by Year/Month
Subtotal Row
Custom Weekly Grouping
Group Ranges of Numbers
Group on Age Distribution
08. Review (4:37)
|
|
| Excel 2010 Expert 8 |
| Running Time: 1 Hour, 8 Minutes
00. Intro (5:13)
01. Protect Worksheets (11:15)
Create Loan Calculator Sheet
Review > Changes
Protect Sheet
Set Password
Locked v. Unlocked Cells
Set Allowed Actions
Hiding Cell Formulas
02. Protect Workbook (8:58)
Structure
Windows
Set Password
Protect With Password
Save As > Tools
Password to Open
Password to Modify
03. Advanced Copy Paste 1 (10:59)
Cut Copy Paste Review
Copy by Click & Drag
Paste Smart Tag Options
Paste Formulas
Transpose Axes
Paste Number Formatting
Keep Source Formatting
Keep Source Column Width
No Borders
Paste Values
Paste Link
Paste as Picture
Paste Special
Merge Conditional Formats
Mathematical Operations
Increase all prices 3%
04. Advanced Copy Paste 2 (6:10)
Office Clipboard
Collecting Items
Pasting Multiple Items
Clear All
Undocking the Clipboard Pane
Copying Formulas not Values
05. Fill & Series (6:03)
Left, Right, Up, Down
Fill Series
Linear Numbers
Dates
Weekdays
Trends
Step Value
Stop Value
Across Worksheets
Growth Factor
06. Data Entry Forms (15:07)
Adding Buttons to Quick Access Toolbar
Add/Remove Standard Buttons
Add Forms Button to QAT
Creating Data Form
Make Labels
Set up the Form
Add Data
Move Between Records
Leading Zero Problem
Calculated Columns Display Differently
Delete - No Undo!
Restore
Criteria
Simple Search
Inequalities
Wildcard Characters *, ?
07. Review (4:28)
|
|
| Excel 2010 Expert 9 |
| Running Time : 1 Hour, 5 Minutes
00. Intro (5:28)
01. Advanced Sorting 1 (7:31)
Custom Sort
My data has headers
Sort By
Sort On
Sort Order
Add Level
Delete Level
Copy Level
Sort by Color
Conditional Formatting
Icon Sets
Options
Case Sensitive
Sort Left to Right
Sort Top to Bottom
02. Advanced Sorting 2 (8:49)
Sort on Custom List
Sort on Birth Month
Create a Custom List
Sort by Roman Numerals
Alphanumeric Sorts
McDonald, Mc Donald
a1, a10, a11, a2, a3
03. Customizing the Interface (11:11)
Customizing Quick Access Toolbar
Adding buttons
Removing buttons
Change order of buttons
Insert separator
Choose commands from
Show QAT Below the Ribbon
Reset customizations
Import/export customizations
Custom toolbars for specific workbooks
Customizing the Ribbon
Main Tabs v. Tool Tabs
Removing groups
Adding your own custom tab
Adding groups
Adding commands
Hiding built-in tabs
04. Filtering Data 1 (5:58)
Download sample spreadsheet
Turn on filtering
Filter on one or more values
Filtering on multiple columns
Turn off filtering
Clearing the filter
Reapplying the filter
05. Filtering Data 2 (8:15)
AND and OR conditions
Text Filters
Numeric Filters
Date/Time Filters
Wildcard Characters
Top 10 Filters
Filter for blanks
Right-click to filter
06. Advanced Filters (13:15)
Create an Advanced Filter Row
List range
Criteria range
Copy to another location
Filter the list in place
Unique records only
AND across, OR down
Multiple rows, multiple columns
Set up nice formatted filter region
07. Review (4:18)
|
|
| Excel 2010 Expert 10 |
00. Intro (5:33)
01. Custom Views (6:06)
Turn on filtering
Create a Custom View
Add Dropdown to Toolbar
Add View with Dropdown
02. SUBTOTAL Function (7:12)
SUM calculates ALL cells
SUBTOTAL function know filters
Select a subtotal type
SUM, AVERAGE, etc.
Just HIDING a row
Only works in columns, not rows
AutoSum uses SUBTOTAL for SUM only
03. Outline Subtotals (7:33)
Create a Subtotal
Expand Collapse Buttons
Multiple Subtotal Groups
04. Outlines (7:45)
Creating a Manual Outline
Group, Ungroup Buttons
Clear Outline
Auto Outline
05. Data Validation 1 (10:05)
Validation Rules
Text Length
Circle Invalid Data
Input Message
Error Alert
Stop, Warning, Information
06. Data Validation 2 (9:30)
Date Values
TODAY() function
Appts in 30 days
Range Formulas for Validation
Ignore First Row Error
Times
Whole Numbers
List
Dropdown List Values
Conditional Formatting
07. Data Validation 3 (8:43)
Custom Rules
ISTEXT()
AND()
MID()
LEN()
Exceeding a Budget
08. Data Validation 4 (8:46)
Cascading Lists
Pick a Car Make
Show Models for that Company
DGET Function
Lookup with Multiple Criteria
09. Review (4:36)
|
|
| | Excel Expert 11 Outline | 00. Intro (4:37)
01. Video Time Conversion (27:39)
Separating Text Strings
FIND, LEFT, LEN, MID, RIGHT
Converting to Seconds
Adding Times
QUOTIENT, MOD, TEXT Functions
How Many Hours in X Seconds
Force 2 Digit Minute, Sec 00:00
02. XLOOKUP Part 1 (13:28)
Benefits of XLOOKUP
Look up to the left or right
Return multiple results
Vertical or horizontal lookups
Reverse search (last to first)
Defaults to an exact match
Supports wildcards (*, ?, ~)
Sspecify a value if not found
Return entire columns or rows
Can work with arrays
Review of VLOOKUP
Weekday Lookup
Absolute References F4
Still works if you move ranges
Student Grades
Grade Lookup Table
List doesn't have to be in asc order
Exact Match Lookup
Approximate Lookup (Range)
Match Mode: Exact Match or Next Smaller Item
03. XLOOKUP Part 2 (11:13)
Returning multiple values
match_mode
Match Not Found: if_not_found argument
Wilcard Searches * ? ~
search_mode
Binary Searches - discussion
XMATCH
04. XLOOKUP Part 3 (16:48)
Two-way lookups (double lookup)
Clothes, Sizes, Look up Price
Course, Grade, Look up Letter
BONUS: Developer Tab
Combo Box
Input Range
Cell Link
05. Review (2:49)
| | Old Excel 2003 Outlines |
| Excel 2000-2003 |
| Excel 101 |
1. INTRODUCTION
Objectives
Pre-Requisites
Important concepts
2. PARTS OF THE EXCEL SCREEN
Starting Excel
Parts of the screen
Title Bar
Workbook name
Spreadsheets Defined
Maximize
Minimize
Close
Two sets of max/min/close buttons
Menubar
Toolbars
Standard toolbar
Formatting toolbar
Formula Bar
The Spreadsheet Window
Columns v. Rows
Names of Columns and Rows
Column and Row Headers
Cells
Names of Cells
The Cell Name Box
The Mouse Pointer in Excel
Scroll Bars and their use in Excel
The Task Pane
Sheet Tabs
Status Bar
Adjustments to Excel for class
Closing the Task Pane
Moving Toolbars Around
Floating v. Docked Toolbars
3. ENTERING DATA
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Entering a full column of data
Pressing ENTER, TAB, or ARROW KEYS
Using the Mouse to move around
Using the keyboard to move around
4. EDITING DATA
Editing data in a cell
Overtyping your data
Replacing data in your cells
Editing data using the Formula Bar
Editing a cell by double-clicking
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel
5. FORMATTING OUR SHEET
A Cell Range defined
Cell Range Notation (A1:B5)
Highlighting (selecting) ranges of cells
Formatting your text
Horizontal cell alignment
Align Right, Left, Center
Bold, Italics, Underline
Changing Fonts, Font Size
Resizing Columns
Changing Column Width
Resizing Rows
Resizing Columns Automatically with Double-Click
Background Color / Fill Color
Foreground Color / Font Color
6. BASIC MATH
Moving to a different sheet tab
Using a "scratch" sheet
Basic math operators
Adding two cells together
Demonstrate auto-recalculation
Result on sheet, formula in formula bar
Addition
Subtraction
Multiplication
Division
Exponentiation
Clearing a range of cells
Adding a range of cells
Taking the average of a range of cells
Order of Operations
Using parentheses in math operations
7. FUNCTIONS, PART ONE
Functions defined
What is a function
The SUM function
The AVERAGE function
Using the mouse with functions
Selecting function ranges with the mouse
The MAX, MIN, and COUNT functions
8. FUNCTIONS, PART TWO
Adding functions to our sales summary sheet
Totalling each month's sales
Totalling each sales rep's sales
Calculating a grand total
Calculating sums for columns and rows
Practical application for our student gradebook
9. CUT, COPY, PASTE, AUTOFILL
Copying and pasting a formula
Excel adjusting formula automatically
Using AutoFill to copy a formula
The AutoFill Handle
Common mistakes while trying to AutoFill
Moving cells by click and drag
AutoFill Series: Months
10. SAVING, LOADING, PRINTING
Saving your workbook
Saving with the floppy disk (save) button
Saving to your "My Documents" folder
Entering a filename
Closing Excel
Reloading your workbook
Using the Task Pane
Using the File Menu Option
Using the Windows Documents options
Printing your spreadsheet
File, Print
Print Options
11. REVIEW
Review topics
|
|
| Excel 102 |
1. INTRODUCTION
Objectives
Pre-Requisites
2. USING AUTOFILL, PART ONE
Using AutoFill with series
Months of the year
Days of the week
Sequential dates
Number series
Non-seqential dates
Creating a calendar in Excel
Using the ZOOM drop-down
Zooming in and out
Zoom to selection
AutoFilling backwards (to the left)
###### showing up in your cells
Double-click to auto-resize a column
Highlighting multiple columns
Resizing multiple columns to the same width
Double-click resize multiple columns
Manually entering a column width
3. USING AUTOFILL, PART TWO
Right Click, Format Cells
Changing the format of a date
Two v. Four Digit Years
Using the Format Painter
Format Painter double-click trick
Sticky Format Painter
AutoFilling multiple columns/rows
Inserting a blank row or column
Forcing Excel to format text
Single-quote text formatting
Losing leading zeros (ZIP codes, SSN, etc.)
Align left
Merge and Center Cells
Center Across Columns
Print Preview
Cell Borders
Turning borders on and off
Preset borders
All Borders
No Borders
Thick Outside Border
Resizing rows to the same hight
Changing vertical cell alignment
Top, Center, Bottom vertical alignment
4. SORTING DATA
Setting up a new sheet
Green warning markers
Ignoring Errors
Numbers stored as text
Percent Style
Dealing with decimals and fractions
Increase Decimal
Decrease Decimal
Currency Style
How Excel rounds decimals
Using the AutoSum button
A warning about the AutoSum feature!
Sort Ascending
Sort Descending
Selecting the right cells to sort
Sort Warning
Expand the selection
Continue with the current selection
Accidentally scrambling your data
Recognizing the Key Cell to sort by
Sorting by the left-most cell in a range
Sorting by the right-most cell in a range
Sorting by some column in the middle of your range
Moving the Key Cell with the TAB key
Using Data > Sort
Sorting by up to three fields
The Sort Dialog box
5. CHARTING, PART ONE
Selecting which cells to chart
Selecting non-contiguous ranges with the CTRL key
Getting rid of Clippy, the Office Assistant
Using the Chart Wizard
Selecting a Chart Type and Chart Subtype
Verifying your data range
Entering a chart title
Where to place your chart
Chart as a new sheet
Chart as an object in an existing sheet
Using Format Data Series
Changing the color of your chart columns
Changing the background colors with Format Plot Area
Using Format Axis
6. CHARTING, PART TWO
Creating a 3D Column Chart
Press and Hold to View Sample
Entering a Category (X) Axis Title
Entering a Series (Y) Axis Title
Entering a Value (Z) Axis Title
The Axes tab - turning axis labels on/off
Major and Minor Gridlines
Showing or hiding the Legend
Legend Placement
Using Data Labels
Show Data Table
Show Legend Keys
Hiding the Chart Toolbar
Format Data Point
Changing the format of one specific column
Format Walls
Using a Gradient fill
Fill Effects
Textures
Patterns
Using 3-D View to rotate your chart
Changing elevation, perspective, rotation
7. CHARTING, PART THREE
Creating a pie chart
Category name, percentage data labels
Separating a piece of the pie
Separating all of the pie pieces
3-D View for pie charts
Formatting, moving data labels
Leader lines
8. REVIEW
Review topics
|
|
| Excel 103 |
0. INTRODUCTION
Objectives
Pre-Requisites
1. SETTING UP OUR SHEET
Building an Income & Expense Report Sheet
Setting up Income & Expense Categories
Moving a range of cells with the mouse
Formatting our sheet
Inserting blank rows
AutoFill Review
2. WORKING WITH LARGE SHEETS
Freezing panes
Window, Freeze Panes
Window, Unfreeze Panes
Splitting the Screen
Window, Split
Window, Remove Split
Window, New Window
Insert Comments
Edit Comment
Delete Comment
Hiding Columns and Rows
Unhiding Columns and Rows
3. PAGE SETUP, PART ONE
Print Preview
Using the Magnifying Glass
Zooming in and out
Closing Print Preview
File, Page Setup
Page Orientation
Portrait v. Landscape
Scaling
Adjust to % Normal Size
Fit to pages
Print quality (resolution)
First Page Number
Additional printer options
Page Margins
Top, Bottom, Left, Right Margins
Header & Footer Margin Settings
Center on Page Horizontally, Vertically
Adjusting margins visually
4. PAGE SETUP, PART TWO
Headers & Footers
Using the stock page headers
Page header previews
Creating a custom header and footer
Left, center, right sections
Using the insert codes for headers/footers
Page numbering
Number of pages
Putting an ampersand in your headers
Inserting the date and time
The path and file of your workbook
Inserting a picture in your sheet
Changing text format of headers/footers
5. PAGE SETUP, PART THREE
Working with the Page Setup, Sheet tab
Specifying a Print Area
Using the range popup boxes
Rows to repeat at top
Columns to repeat at left
Showing gridlines
Black and white printing only
Draft quality
Showing row and column headings
Showing comments, options
Forcing comments to stay visible on sheet
Displaying Cell Errors
Page Order (numbering)
6. WORKING WITH MULTIPLE SHEETS
Viewing the page breaks
View, Page Break Preview
Moving the page break lines
View, Normal
Changing the name of your sheet tabs
Creating a copy of a sheet
Changing the color of a sheet tab
Using the keyboard to move between sheets
Deleting a sheet tab
Inserting a blank new worksheet
Moving a sheet tab with the mouse
Selecting multiple sheet tabs
Moving multiple sheet tabs
Format, Sheet, Background
Creating a background picture for the sheet
7. REVIEW
Review topics
|
|
| Excel 104 |
0. INTRODUCTION
Objectives
Pre-Requisites
1. FORMAT CELLS: NUMBER FORMATS
Setting up a sales log sheet
Right Click, Format Cells
The Number Tab
General Number Format
Number of decimal places
Use 1000 Separator
Formats for negative numbers
Currency Style
Accounting Style
The Date Formats
The Time Formats
Percentage Formats
Fractions Format
Precisions with fractions
Scientific notation format
Plain Text Formats
Special Formats
Custom Formats, a brief discussion on
Using Format Painter on a whole column
Percent Style Button
Calculating sales tax by a tax rate
Math for calculating totals, subtotals
2. FORMAT CELLS: ALIGNMENTS
Format Cells, Alignment Tab
Setting vertical alignment
Top Vertical Alignment
Wrap Text to keep text in a cell
Text Orientation
Displaying text at an angle
Insert Cut Cells to move a whole row
Shrink To Fit text
Merge and Center
Center Across Columns
Merge Cells
3. FORMAT CELLS: FONTS
Format Cells, Font Tab
Strikethrough, Superscript, Subscript
Borders Tab
None, outline, inside borders
Manually turning borders on/off
Diagonal (strike) borders
Border styles, colors, thickness
Patterns tab
Setting a pattern and color
Cell protection, brief discussion
4. CONDITIONAL FORMATTING
Format, Conditional Formatting
Formatting a cell based on its value
Example: Highlighting sales over $300
Adding more conditions
Example: Highlighting sales under $100
Formatting based on a cell value
5. SPELLING, FIND, REPLACE, AUTOFORMAT
Tools, Spelling to spell check your sheet
Ignore once
Ignore all
Add to dictionary
Change
Change All
Edit, Replace
Find and Replace Dialog
Finding based on format
Match case
Match entire cell contents
Find Within (workbook, sheet, range)
Search By (rows, columns)
Look in (formulas)
Format, AutoFormat
Pre-designed AutoFormats
6. FINANCIAL CALCULATOR
Creating a loan calculator
Entering the value of the house, down payment
Calculating the financed amount
Entering the interest rate, period
Learning the PMT function
Using PMT to calculate the monthly payment
Calculating number of payments
Figuring out total interest paid
Currency Style button
Comparison shopping: compare two loans
Changing interest rates, periods, down payments
Calculating your savings
Locking specific cells to prevent tampering
Turning on sheet protection
Format Cells, Protection tab
Locked cells
Tools, Protection, Protect Sheet
Unprotect Sheet
7. REVIEW
Review Topics
|
|
| Excel 201 |
0. INTRODUCTION
Objectives
Pre-Requisites
1. REVIEW AND SHEET SETUP
Setting up a student gradebook
2. THE IF FUNCTION, PART ONE
How the IF function works
Learning about logical tests
Specifying true and false values for IF
Using text values with IF
3. THE IF FUNCTION, PART TWO
Setting up a sales tax sheet for IF
Logical test with text values
Charging tax only to customers from NY
4. RELATIVE V. ABSOLUTE REFERENCES, PART ONE
Marking a student "pass" or "fail"
Move passing grade outside formulas
Making a cell reference absolute
absolute references v. relative references
AutoFill with absolute references
Move sales tax outside formulas
5. RELATIVE V. ABSOLUTE REFERENCES, PART TWO
Making passing grade based on class average
Grading on a "curve"
Creating a new quarterly sales summary sheet
Showing percent of sales for each quarter
Divide by Zero Error (#DIV/0!)
6. VALUES FROM OTHER SHEETS
Moving all of our external data to a new sheet
Refering to a cell on a different sheet
Cutting and pasting a link to a cell
Right click, paste special
Paste Special dialog box
Pasting the value of a cell (Paste Values)
#NAME? error
Referring to sheet names with spaces in them
7. COPYING DATA TO MICROSOFT WORD
Copying Excel sheet data into Word
Pasting Excel Data as a Word Table
Edit, Paste Special
Microsoft Excel Worksheet Object
Paste Link
Linking v. Embedding
Linking data back to the original Word document
8. TIPS AND TRICKS
Insert Cut Cells
Moving a whole row
Shift cells right
Shift cells down
Copying a sheet with the CTRL-drag trick
Manually drawing borders
View, Toolbars, Borders
Borders Toolbar
Pencil tool
Eraser tool
Insert Comments
Show Comments
Hide Comments
9. REVIEW
Review topics
|
|
| Excel 202 |
0. INTRODUCTION
Objectives
Pre-Requisites
1. REVIEW AND SHEET SETUP
Reconstruct Student Gradebook
Short review of important concepts
2. NAMED CELLS
Defining a named range
Insert, Name, Define
Refers To Box
Using the Name Box
Naming the PassingGrade cell
Jumping to a named cell
Using the named cell in functions
Collapse Dialog
Expand Dialog
Valid names for cells
3. NAMED RANGES, PART ONE
Defining a named range
Pasting a named cell or range
Insert, Name, Paste
Using named ranges in formulas
Jumping to named ranges
Range Intersections
4. NAMED RANGES, PART TWO
Deleting a named range or cell
Editing a named range or cell
Pasting a list of your named ranges
Paste List
Creating names based on your headers
Insert, Name, Create
Applying names to existing ranges
Insert, Name, Apply
5. NESTED IF FUNCTIONS
What is a Nested IF function
Using the COUNT function
Checking multiple conditions
Giving our students an Incomplete
Giving a letter grade using nested IFs
6. VLOOKUP, PART ONE
Creating a subtable (lookup table)
Grade values lookup table
Using VLOOKUP to return the letter grade
Using VLOOKUP to return a commission rate
7. VLOOKUP, PART TWO
Expanding our lookup table to three columns
Using VLOOKUP to return multiple columns
Creating a basic invoice using Excel
Using HLOOKUP to calculate a discount
Using the Function Wizard for HLOOKUP
8. REVIEW
Review Topics
|
|
| Excel 220 |
0. INTRODUCTION
Objectives
Pre-Requisites
1. DATA LISTS
Data Lists Defined
Header Row
Fields
Records
Database Terminology
Pick From List
2. FORMATTING DATA LISTS
Formatting the Header Row
Freezing Panes (review)
Calculate Time Difference (in hours)
Absolute References (review)
Conditional Formatting (review)
Spreadsheet v. Database (when to switch)
3. DATA ENTRY FORMS
Data entry forms defined
Opening the data form
Moving between fields
Entering data
New records
Find Previous
Find Next
Deleting records
You can't undo deletes
Calculated fields in data forms
Searching for records
Search Criteria
Using wildcard characters * and ?
Wildcard rules
Restore button
4. ADVANCED SORTING
The sum preview on the status bar
Changing from sum to a different function
Count v. Count Nums
Sorting month names in month order (not alpha)
First key sort order
Sort options
Custom Lists (using in sorts)
Sorting on more than 3 fields
Restoring a list's original sort order
Alphanumeric sorting rules
5. CUSTOMIZING TOOLBARS
Toolbars and commands defined
Customizing built-in toolbars
Reviewing the command button options
Moving buttons around
Removing buttons from toolbars
Copying a button from one toolbar to another
Resetting a toolbar to its default settings
Changing a button from icon to text
Creating a New Toolbar
Attaching a toolbar to a workbook (to share it)
Change Button Image
Creating a custom button image
Button Editor
Edit Button Image
Copying ANY image onto a button
Changing the tooltip text
Toolbars Options tab
Toolbar Quick-Add Buttons
Toolbar buttons with dual functions
How to backup your custom toolbars
8. REVIEW
Review Topics
|
|
| Excel 221 |
0. INTRODUCTION
Objectives
Pre-Requisites
LESSON 1. FILTERING DATA
Data > Filter > AutoFilter
Filtering by a single item
Filtering by multiple items
Showing (All) records
Showing (Top 10...) results
Top/Bottom X Items/Percent
Duplicate values
Turning off AutoFilter
Adding AutoFilter and Show All to toolbar
1000 Item Limit
LESSON 2. CUSTOM FILTERS
(Custom...) AutoFilter
One item, equals
AND and OR conditions
End With
Inequalities (greater/less than)
Blank option
(Blanks) and (NonBlanks)
LESSON 3. ADVANCED FILTERING
Boolean operators
Creating custom advanced filter fields
Data > Filter > Advanced Filter
List Range
Criteria Range
Adding Advanced Filter to Toolbar
Creating a custom advanced Criteria Row
Filtering in place
Creating a named range for our DataList
Criteria named range
AND across, OR down
LESSON 4. SENDING LATE NOTICES (PROJECT)
Creating a customer list
Show records with missing data
Show customers over 30 days late
Copying filtered records
Showing non-blank records with Advanced Filters
Showing blank records with Advanced Filters
Showing customers in the 14xxx ZIP code
Wildcard Filter Characters
Showing customers with "gate" in address
Copying filtered records to a new sheet
Microsoft Word Mail Merge Wizard
Creating Mailing Labels
Configuring your Address Block
Matching Fields
LESSON 5. CALCULATED FILTERS, CUSTOM VIEWS
Calculating the average of all sales
Filtering sales above/below average
Calculating average of an entire column (D:D)
Custom Views
Creating a filtered Custom View
Switching between Custom Views
Placing Custom Views on your toolbar
LESSON 6. SUBTOTALS
Using the SUBTOTAL function
Why use SUBTOTAL instead of SUM
What the function_num means
List of available functions for SUBTOTAL
Using the Function Wizard with SUBTOTAL
Using the AutoSum button with SUBTOTAL
How AVERAGE doesn't work with filters
Using SUBTOTAL for averages
Creating automatic Subtotals
Data > Subtotals
Grouping and Outlining - brief discussion
Calculated Subtotals for each group
Removing subtotals
Sorting the list properly
Sorting to remove subtotals
7. REVIEW
Review Topics
|
|
| Excel 222 |
INTRODUCTION
Objectives
Pre-Requisites
LESSON 1. STYLES
Format > Style
Style Dialog
Built-In Excel Styles
Currency Style
Modifying Styles
Style Patterns
Creating your own Styles
Changing styles throughout your workbook
Adding the Style dropdown to your toolbar
Style Borders
Merging styles from different workbooks
LESSON 2. GROUPING AND OUTLINING
Traditional outline formats
Sales & expenses
Tracking multiple stores
Data > Group and Outline > Auto Outline
Grouping and Outline Levels
Collapse and Expand
Data > Group and Outline > Clear Outline
Horizontal outlines
Grouping months into quarters
Data > Group and Outline > Settings
Summary rows below detail
Summary columns to right of detail
Automatic styles
RowLevel_1 and RowLevel_2
ColLevel_1 and ColLevel_2
LESSON 3. MANUAL GROUPING
Data > Sort review
Data > Group and Outline > Group
Creating a manual group
Creating a sorting and grouping toolbar
Manually creating subtotals
Hide detail and show detail
Review of creating a custom view
LESSON 4. GROUPING TIPS AND TRICKS
Selecting only visible items when you collapse a group
Selecting Visible Cells Only
Using the Go To command
Using CTRL-8
Creating a HeaderGroupStyle
Changing your style and watching the whole sheet change
LESSON 5. DATA VALIDATION
Correcting user input
Data > Validation
Checking text length
Custom Input Message
Custom Error Alerts
Stop, Warning, or Information
Dealing with dates in a range
Number types
Picking from a list
Drop down menu of options
Hiding your source list
Putting your list in the Settings dialog
Formula Auditing Toolbar - a quick look
Circle Invalid Data
Clear Validation Circles
Conditional Formatting - review
Custom formulas for data validation
ISTEXT() function
Ignore Blank
LEFT() function
REVIEW
Review Topics
|
|
| Excel 223 |
- What is a PivotTable
- Building a PivotTable
- Manipulating PivotTable Fields
- PivotTable rules for data
- Field Settings
- Pivoting Your Data
- Inner & Outer Fields
- Example: Sales Log
- Example: Employee List
- Refreshing PivotTable Data
- Filtering Data
- Using Page Fields to Filter Data
- Sorting PivotTable Data
|
|
| Excel 224 |
- Grouping Data
- Drill to Detail
- Grouping Dates Together (months, quarters, etc.)
- Grouping Numeric Values
- Subtotals
- Subdetails
- Advanced Field Settings
- Formatting PivotTables
- Copying PivotTable Data
- PivotTable Options
- Calculated Fields
- Calculated Items
- Base Fields & Items
- Running Totals
- Showing Data as a Percentage of Previous Data
- Example: Employee Costs using IF, VLOOKUP, and a PivotTable
|
|
| Excel 230 |
Lesson 1. Multisheet Ranges
Selecting Multisheet (3D) Ranges
Tracking sales for multiple years
Formatting multiple sheets with one selection
Creating a summary sheet
Lesson 2. Go To > Special
Comments, Formulas, Blanks,
Current Region, Objects, Row & Column Differences
Precedents & Dependents, Last Cell
Visible Cells Only, Conditional Formats,
Data Validation
Lesson 3. Advanced Find & Replace
Find, Replace Options
Wildcards: *, ?
using tilde ~ to find a wildcard character
Find Format > Choose Format From Cell
Find in Sheet, Workbook
Find All
Selecting all found cells
Find in Formulas, Values, Comments
Match Case
Match Entire cell
Careful when doing Replace All, esp w numbers!
Lesson 4. File Options
AutoRecover
AutoRecover Options
Saving Your AutoRecover file
File Save Options
Creating Automatic Backups
Password to Open, Modify
Encryption
Workbook Summary
Summary Fields (Subject, Title, etc.)
Custom Fields - creating a workbook database
Item, Type, Data
Lesson 5. Templates
Understanding templates
Modifying the default Excel template
Setting up custom workbook templates
Book.xlt, Sheet.xlt
XLStart Folder |
|
| Excel 231 |
LESSON 1. ERROR TYPES
Types of Errors
Syntax Errors
Logical Errors
Reference Errors
Circular References
Mismatched Parentheses
LESSON 2. SPECIFIC ERRORS
#DIV/0!
Handle DIV/0 error with IF function
ISERROR() function
#NAME?
#REF!
#VALUE!
#NUM!
SQRT() Function for square root
Exponents too large 10^308
#NULL!
#N/A
=NA() Function
LESSON 3. ERRORS WITHOUT MESSAGES
Logical Errors
Relative v. Absolute References
Rounding errors
Actual v. displayed values
ROUND() function
Force "Precision as displayed"
Floating Point Errors
Numbers close to zero not rounding right
LESSON 4. LOGICAL FUNCTIONS
TRUE
FALSE
NOT
AND
OR
=IF(AND(X,Y),TRUE,FALSE)
LESSON 5. AUDITING
Tracking Errors
Auditing Toolbar
Trace Dependents
Trace Precedents
Dependents on another sheet
Goto jumping to those dependents
Trace Errors
Blue and Red Arrows
Evaluate Formula
Evaluate, Step In, Step Out
Circle Invalid Data
Watch Window
LESSON 6. HIDING ERRORS
Automatic Error Checking
Hiding Cell Errors from Printouts
LESSON 7. CIRCULAR REFERENCES
Circular Iterations
When you WANT a Circular Reference
Simulating a DO LOOP
LESSON 8. TIPS & TRICKS
Transpose Data
Edit > Fill
Series Trend
Increasing X Weekdays
AutoFill with RIGHT Mouse Button |
|
| Upgrading to Excel 2007 Seminar |
00. Intro (6:29)
01. The Ribbon 1 (8:03)
Ribbon Tabs
Ribbon Tab Groups
Simple Command Buttons
Complex Command Buttons
Drop-Down Menus
Dialog Box Launcher Buttons
On Demand Menu Tabs
Minimize the Ribbon
02. The Ribbon 2 (7:37)
Resize Formula Bar
Keyboard Shortcuts
New ALT-key Combinations
ALT-arrow keys
Live Preview
Mini Toolbar Popup Menu
03. Quick Access Toolbar (7:35)
Customizing
Office > Options > Customize
Adding Commands
Adding a Separator
Add for All Books
Add to This Book
Show Above / Below the Ribbon
Right-Click, Add to
Commands Not in the Ribbon
04. Upgrades & Changes (6:16)
Get the Latest Updates
Upgrades and Changes
Row, Cell, Size Increases
Other Changes
05. Office Button 1 (9:22)
Save, Load, Print, etc.
Save in Other Formats
New File Formats
XLSX, XLSM, XLTX, XLTM
Backward Compatibility
Excel 2007 Viewer
Other File Formats
06. Office Button 2 (12:32)
Pin Workbooks to Recent List
Print vs. Quick Print
Print Preview
Page Layout View
Prepare
Document Properties
Inspect Document
Encrypt Document
Digital Signatures
Mark as Final
Compatibility Checker
07. Excel Options (14:33)
Show Mini Toolbar
Enable Live Preview
Show Developer Tab
Edit Custom Lists
New Workbook settings
Font, Number of Sheets
Change Language Settings
R1C1 Reference Style
Other Formula Options
Error Checking Options
AutoCorrect Options
Spelling Options
Default File Format
AutoRecover
Advanced Options
Trust Center Settings
Macro Settings
Resources
Get Updates
About Excel
08. Home Tab 1 (11:02)
Home Tab
Clipboard Group
Upgrades to Paste Options
Draw Borders
New Color Options
Orientation Button
New Format Number Dropdown
Cells, Insert, Delete
Format Cells on Ribbon
New AutoSum Button
09. Home Tab 2 (13:52)
Styles
Conditional Formatting
10. Home Tab 3 (13:23)
Tables
Table Styles
How Tables Work
Total Row
Banded Columns / Rows
Table Autofilters
Sort & Filter
Sort By Color
11. Charts (14:58)
Inserting a Chart
No More Chart Wizard
Chart Types
Switch Row/Column
Quick Layout
Chart Styles
Move Chart
Layout Formatting
12. PivotTables (14:02)
Creating PivotTables
New / Changed Features
Adding Fields
Rows Columns
Formatting
Grouping
Sorting
PivotChart
Conditional Formatting
13. Illustrations (10:51)
Pictures
Clipart
Shapes
Smart Art
14. Insert Tab Misc (5:51)
Text Box
Header & Footer
WordArt
Signature Line
Object
Symbol
15. Themes (6:45)
Color Schemes
Font Groups
Effects
16. Page Layout (10:57)
Margins
Orientation
Page Size
Print Area
Page Breaks
Background
Print Titles
Scale to Fit
Gridlines
Headings
Arrange
Bring to Front
Send to Back
Selection Pane
Align, Group, Rotate
17. Formulas (12:37)
Insert Function
Search For Function Name
Function Libraries
New Functions
IFERROR
AVERAGEIF
AVERAGEIFS
SUMIFS
COUNTIFS
18. Get External Data (9:49)
From Access Database
From a Web Site
Automatic Refresh
19. Data, Review (4:32)
Remove Duplicates
Review Tab
20. Miscellaneous (11:45)
Templates
Microsoft Office Online
Customize Status Bar
Zoom Slider
Find & Select New Features
Name Manager
Create from Range
Range Intersections
21. Review (5:02) |
|
| |
| | Additional Access Developer Courses | | Access Developer 51 | Opening a modal pop-up form over the active control
Calculating and determining control screen coordinates
Reusable pop-up system for multiple controls and forms
Storing calling form and control info with TempVars
Returning values from pop-up form to original control
Creating reusable public functions for pop-up handling
Best practices for naming controls when using pop-ups
Handling pop-up forms with subforms and continuous forms
Finding control position on main forms and subforms
Calculating control coordinates in multiple subform scenarios
Using class modules to encapsulate pop-up logic
Setting up properties and methods in a class module
Determining if a control is in a subform via class logic
Building helper modules to streamline pop-up operations
Creating leftmost and rightmost custom string functions
Handling nulls and empty strings in string helper functions
Practical uses for custom string helper functions
Safely deleting records from a table inside recordset loops
Avoiding skipped records and cursor issues in deletions
Archiving records with custom business logic
Passing recordsets to functions for cleaner code
Processing deletions and archives using SQL statements
Setting up a drag-and-drop file system in Access forms
Capturing file paths using Windows API for dropped files
Wiring a listener to detect file drops on a form
Organizing folder structure for storing dropped files
Safety checks before allowing file drops in forms
Ensuring file drop system only runs when safe
Copying dropped files to structured folders
Generating unique file names for dropped files
Linking copied files to records in the Access database
Refreshing form UI and focusing on newly added file | | Access Developer 52 | Adding thumbnails and file type icons for preview
Building open link or file function in Access
Launching files, folders, and web links from Access
Handling and previewing various file types
Expanding support for hyperlinks and folders
Improving performance of file previews
Automating Excel to open workbooks to specific sheets
Automating Word to jump to headers or run searches | | Access Developer 53 | Tightening error handling for Word automation
Tightening error handling for Excel automation
Building a recycle bin system for records
Sending files to the Windows recycle bin
Implementing a one-click button to create Word documents
Auto-naming and storing Word documents in customer folders
Registering new Word documents in the database
Creating a recursive make-dir function for folder paths
Batch importing all files from a folder
Importing screenshots and other files with one click | | Access Developer 54 | Purpose and use cases for split transactions
Designing a split transaction data model
Creating parent transaction and child split tables
Building forms for split transaction entry
Adding and managing splits with subforms
Implementing a pop-up split editor form
Rollback protection for canceled changes
Synchronizing transaction and split values
Adding split entry by percentages
Auto-calculating remaining split balances | | Access Developer 55 | Building a table to store form color settings
Storing color settings for sections and controls
Generating a list of forms using an array list
Organizing and managing form appearance settings
Creating an engine to read and save property values
Looping through every control and section on forms
Capturing and saving entire form layouts
Switching between light and dark mode
Updating all open forms to the current theme
Ensuring new forms use the selected theme automatically
Customizing the Access workspace background for dark mode
Adding event handler shortcuts for theme management
Restoring button gradients in themed forms | | Access Developer 56 | Cleaning up the background form with Windows API
Making the background form fit the Access window
Removing scroll bars from the background form
Reading the Windows theme from the registry
Synchronizing Access dark mode with Windows dark mode
Setting the Windows dark mode from Access
Building a bubble sort algorithm in VBA
Sorting data with a DAO recordset and temp tables
Sorting data with a disconnected ADO recordset | | Access Developer 57 | Controlling Microsoft Office theme with VBA
Automatically switching Word, Excel, and Access themes
Integrating the VBA editor with theme switching
Handling subforms in dark mode
Managing desktop colors in Access
Creating command line shortcuts for theme control
Implementing one-click setup switching | | Access Developer 58 | Building a dynamic Kanban board in Access
Replacing fixed layout with dynamic layout
Creating configurable columns in Kanban board
Storing control positions in a table
Moving and resizing controls with VBA
Showing and hiding controls with VBA
Tracking active columns in the interface
Automatically centering controls
Hiding unused list boxes dynamically
Resizing the form at runtime
Adding safety checks for clean adjustments
Implementing mouse events for drag-and-drop
Using coordinate math to detect drop targets
Handling dynamic layout during drag-and-drop
Moving records between list boxes on drop
Changing mouse pointer during drag operations
Refreshing interface after drag-and-drop
Addressing Access quirks during UI updates | | Access Developer 59 | What Record Set Clone is in Access
Differences between Record Set Clone and Find Record
Navigating records with Find First and Find Next
Detecting No Match and using Bookmarks
Searching records behind the scenes without changing user view
Looping through filtered records with Record Set Clone
Counting records visible on a form using Record Set Clone
Batch updating filtered records based on user filters
Building generic search functions for any form
Comparing Record Set Clone with Open Record Set
When to use Bookmarks versus Where condition in opening forms
Practical routines for search, navigation, and batch processing using Record Set Clone |
| | TechHelp Excel | | 3D Charts & Moving Charts | TechHelp Excel, chart non-contiguous data, 3D pie chart, move chart to sheet, change chart layout, change chart type, 3D column chart, pie chart sales reps, select multiple data ranges, Excel chart formatting, auto update charts, stacked column chart, axi | | Absolute References | TechHelp Excel, absolute reference, relative reference, Excel formulas, cell references, autofill Excel, dollar sign Excel, F4 shortcut, static values Excel, sales tax calculation Excel, grand total formula, Excel formatting, commission percentage Excel | | Account Balances 1 | TechHelp Excel track microsoft excel account balances, personal finances, daily spending transactions, track finances, balance chart, credit and debit, banking activity, credit card balances | | Account Balances 2 | TechHelp Excel track microsoft excel account balances, personal finances, daily spending transactions, track finances, balance chart, credit and debit, banking activity, credit card balances | | Advanced Copy Paste 1 | TechHelp Excel, advanced copy and paste Excel, Excel shortcut keys, Excel Smart Tag, paste values Excel, paste special Excel, transpose data Excel, copy formatting Excel, paste as picture Excel, Excel linked picture, add subtract multiply divide paste spe | | Advanced Copy Paste 2 | TechHelp Excel, Office Clipboard, Excel Clipboard, copy multiple items Excel, paste multiple items Excel, Office Clipboard options, Clipboard pane, copy formulas Excel, paste values Excel, clear clipboard Excel, Clipboard icon taskbar, Clipboard status, d | | Advanced Filters | TechHelp Excel, advanced filter Excel, Excel filtering, Excel filter in place, Excel filter criteria range, Excel inequalities, Excel and or condition, Excel between condition, Excel unique records, Excel filter multiple columns, Excel filter setup | | Advanced Sorting | TechHelp Excel, advanced sorting Excel, custom sort Excel, sort by cell color, sort by icon, multi-level sorting Excel, conditional formatting sort, sort by values, Excel sort options, sort left to right, case sensitive sort Excel, sort by multiple column | | Advanced Sorting 2 | TechHelp Excel, custom sort Excel, sort by month Excel, custom list Excel, sort Roman numerals Excel, Excel alphanumeric sort, Excel original order restore, Excel sort tricks, Excel sort numbers and letters, Excel import custom list, Excel grouping sort, | | AutoFill Basics | TechHelp Excel, AutoFill, Excel AutoFill, copy formulas Excel, fill handle, copy data Excel, drag to copy Excel, Excel fill series, Excel months autofill, Excel days autofill, Excel sum formula, common AutoFill mistakes, Excel shortcuts, Excel copy across | | Basic Math 1 | TechHelp Excel, Excel formulas, Excel math operators, Excel addition, Excel subtraction, Excel multiplication, Excel division, Excel exponentiation, Excel formula bar, Excel cell references, Excel recalculate, Excel delete column, Excel clear contents | | Basic Math 2 | TechHelp Excel, Excel basic math, add multiple cells Excel, Excel average formula, Excel order of operations, Excel sum, sum cells Excel, average cells Excel, parentheses in Excel formulas, Excel formula bar, Excel status bar, Excel math operations | | Borders | TechHelp Excel, add borders to spreadsheet, print grid lines, spreadsheet borders, customize borders, draw borders, change border color, thick box border, all borders, remove borders, grid lines print, sheet options, border styles, border color, dashed bo | | Cascading Drop Downs | TechHelp Excel, cascading drop down list, Excel data validation, dependent drop down, create named range, INDIRECT function, DGET function, lookup car price, Excel car database, multiple criteria lookup, Excel drop down list, Excel named ranges | | Cell Formats 1 | TechHelp Excel, Excel cell formats, Excel number format, Excel text format, Excel currency format, Excel accounting format, Excel date format, Excel leading zero, Excel zip code formatting, Excel format column as text, Excel headers, Excel formula bar | | Cell Formats 2 | TechHelp Excel, Excel cell formatting, Excel fractions, Excel percentages, increase decimal Excel, decrease decimal Excel, comma style Excel, scientific notation Excel, format cells dialog box, custom number formats Excel, accounting format Excel | | Cell References | TechHelp Excel, ADDRESS function, INDIRECT function, cell reference functions, dynamic cell references, Excel MATCH function, sum with INDIRECT, build cell reference from row and column, Excel sales summary, R1C1 style, A1 style, sum a dynamic range, date | | Chart Formatting | TechHelp Excel, switch row and column, Excel chart formatting, chart tools ribbon, insert objects in Excel chart, chart labels, chart design tab, current selection, format selection, 3D chart options, reset to match style, insert shapes chart, add text bo | | Closest to Value | TechHelp Excel, find closest value in Excel, closest number to target Excel, Excel ABS function, Excel MIN function, Excel MATCH function, Excel INDEX function, Excel conditional formatting, guess closest value Excel, Excel average closest value | | Column Charts | TechHelp Excel, charts, Excel charts, chart parts, column chart, data visualization, bar chart, axes, data series, data points, chart area, chart title, chart legend, Excel 2010, gridlines, chart types, insert chart, format chart, clustered column | | Comments | TechHelp Excel, Excel comments, insert comment Excel, add notes to spreadsheet, hide comments Excel, show comments Excel, edit comment Excel, delete comment Excel, comment box, review tab Excel, cell notes Excel, multiple users Excel | | Comments & Notes | TechHelp Excel, comments vs notes, spreadsheet collaboration, threaded discussion, reference notes, cell indicators, red corner marker, purple corner marker, review tab, resolve comment, add note, context menu, convert to comments, export notes, import no | | Compare Two Lists | TechHelp Excel, compare two lists in Excel, find missing items Excel, Excel MATCH function, Excel ISNA function, Excel ISBLANK function, employee order comparison Excel, Excel conditional formatting, highlight missing data Excel | | Conditional Formatting | TechHelp Excel, conditional formatting, Excel, highlight cells, color scales, data bars, icon sets, clear rules, sales data, Styles group, Home tab, greater than rule, less than rule, duplicate values, top bottom rules, custom format, visualization | | Conditional Formatting | TechHelp Excel Use conditional formatting to highlight information, Highlight patterns and trends with conditional formatting, Applying Conditional Formatting, budget vs actual | | Copy Column Row Sizes | TechHelp Excel, Excel copy row heights column widths, Excel preserve format copying, Excel cells maintain dimensions, Excel VBA copy paste dimensions, Excel VBA preserve size, Excel copy partial sheet VBA, Excel sheet dimensions VBA, Excel macro row heigh | | Counting & Rounding | TechHelp Excel, COUNT function, COUNTA, COUNTBLANK, ISBLANK, ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING, FLOOR, INT, TRUNC, rounding numbers, counting functions, Excel decimals, multiple rounding, Excel math functions | | Credit Card Payments | TechHelp Excel, credit card statement, pay off credit card, minimum payment, credit card interest, calculate payoff time, NPER function, PMT function, credit card payoff chart, total interest paid, monthly payment calculation, balance repayment, financial | | Custom Date Codes | TechHelp Excel, custom date format, Excel date and time codes, date formatting, Format Cells dialog, short date, long date, regional date settings, custom time codes, date serial number, leading zeros, abbreviated month, weekday names, AM PM format | | Custom Views | TechHelp Excel, custom views, filter data, Excel filters, quick filter switching, filtered spreadsheets, save filter settings, sales data filtering, custom filter views, Quick Launch toolbar, add custom views, multiple column filter, All Commands Excel | | Customizing Interface | TechHelp Excel, customize Excel ribbon, Quick Access Toolbar, add commands Excel, custom tabs Excel, Excel options, Excel macros, Developer tab Excel, Excel groups, reset ribbon, import export customizations, move ribbon tabs, remove ribbon groups, separa | | Cut Copy Paste | TechHelp Excel, clipboard, cut, copy, paste, Excel clipboard, Excel cut and paste, Excel copy and paste, Excel keyboard shortcuts, Ctrl C, Ctrl X, Ctrl V, Excel formula copy, dancing ants, add sales in Excel, Excel sum formula, align text Excel | | Dashboards | TechHelp Excel, Excel charts in Word, copy Excel chart to Word, Excel dashboard, Excel summary sheet, move chart between sheets, separate pie chart slice, Excel pie chart label, Excel leader line, chart rotation, link Excel chart to Word, resize chart in | | Data Entry Forms | TechHelp Excel, Excel data entry form, Excel Quick Access Toolbar, add form button Excel, Excel data entry interface, set up data entry Excel, Excel column headers forms, Excel data entry for beginners, data entry search Excel, Excel wildcards data entry | | Data Validation 1 | TechHelp Excel, data validation, Excel data validation, data validation settings, input message, error alert, text length validation, whole number validation, list validation, circle invalid data, clear validation circles, stop warning information, custom | | Data Validation 2 | TechHelp Excel, data validation, drop-down list, custom validation, date validation, time validation, whole number validation, conditional formatting, restrict date range, in-cell drop-down, error alert, absolute reference, list validation, Excel data ent | | Data Validation 3 | TechHelp Excel, data validation, custom validation rules, logic functions, istext, and function, or function, social security number format, mid function, length function, budget tracking, numeric validation, spending limits, value comparison | | Date/Time Functions | TechHelp Excel, date functions, time functions, NOW function, TODAY function, YEAR function, MONTH function, DAY function, HOUR function, MINUTE function, SECOND function, WEEKDAY function, DATE function, TIME function, add dates, subtract time | | Date/Time Functions 2 | TechHelp Excel, calculate date difference Excel, Excel DATEDIF, YEARFRAC function, Excel INT function, Excel date functions, difference between two dates Excel, calculate age Excel, Excel date formulas, Excel days between dates, Excel years between dates, | | Date/Time Functions 3 | TechHelp Excel, Excel date functions, fix bad dates in Excel, DATEVALUE, TIMEVALUE, EDATE, EOMONTH, NETWORKDAYS, WORKDAY, WEEKNUM, NETWORKDAYS.INTL, WORKDAY.INTL, convert text to date Excel, custom weekends Excel, Excel serial date, Excel holidays | | Date/Time Functions 4 | TechHelp Excel, Excel timesheet, calculate hours worked Excel, Excel time difference, Excel date time functions, Excel autofill dates, Excel hours and minutes, Excel lunch break deduction, sum hours over 24, Excel custom time format, Excel time formatting | | Date/Time Tricks | TechHelp Excel, first day of month, last day of month, days in month, calculate quarter, day of year, days left in year, Excel date functions, EOMONTH, DATE function, ROUNDUP month, insert current date, insert current time, sum hours Excel, time formattin | | Daylight Saving Time | TechHelp Excel dst, daylight saving time, utc, timeclock, Time Clock sheet, employees, clock in, clock out, buttons, Universal Time, time tracking, employee shift, time clock changes, time management, time conversion, local time to UTC, UTC conversion, Ex | | Default Template | TechHelp Excel default template Excel, workbook settings, font customization, Book.XLTX, row height adjustment, column width, background color, Trust Center, Trusted Locations, startup folder, change default font, template creation, start screen configura | | Drop Down | TechHelp Excel, drop-down lists, Excel drop-down, create drop-down list, Excel data validation, list of options, dynamic drop-down list, name range, absolute references, cascading drop-down list, sort drop-down list, Excel Expert Level 10, move list diffe | | Editing Data | TechHelp Excel, edit data in Excel, correct cell value Excel, Excel formula bar, Excel F2 key, undo in Excel, redo in Excel, remove cell data Excel, overtype in Excel, Excel double click edit, delete cell content Excel, Excel keyboard shortcuts | | Editing PivotTables | TechHelp Excel, pivot table, Excel pivot table editing, change pivot table fields, collapse expand pivot table, filter pivot table data, sort pivot table, pivot table report filter, pivot table value filter, pivot table label filter, drill down pivot tabl | | Entering Data | TechHelp Excel, Excel data entry, Excel spreadsheet, Excel columns, Excel rows, Excel cells, sales summary sheet, Excel headers, Excel formula bar, Excel keyboard shortcuts, Excel navigation, Excel sales reps, Excel sample data, Excel cell selection, spre | | Excel Automation | TechHelp Excel, Excel VBA automation, importing Access data to Excel, create Excel sheet from Access, Excel macro button, Excel VBA tutorial, control Excel formatting with VBA, create new sheet in Excel, import customer data Excel, Excel VBA variable decl | | Excel Automation 2 | TechHelp Excel, automate Excel with VBA, import data from Access to Excel, Excel VBA import data, creating buttons in Excel VBA, formatting imported data in Excel, handling duplicate sheet names in Excel, using SQL in Excel VBA, customizing imported field | | Excel Dates & Times | TechHelp Excel, Excel dates, Excel times, Excel date formats, Excel time formats, Excel date arithmetic, Excel serial date, Excel date number, Excel add days, Excel add hours, Excel add minutes, Excel format cells, Excel military time, Excel before 1900, | | Excel Interface 1 | TechHelp Excel, Excel interface, Excel ribbon, Excel window controls, start Excel, Excel title bar, Excel file tab, Backstage View, minimize maximize close buttons, Excel workspace, Excel menu, resizing Excel, Excel 2010, Windows Start menu | | Excel Interface 2 | TechHelp Excel, Excel ribbon, ribbon tabs, Excel commands, dialog box launcher, ribbon groups, font group, alignment group, number group, styles group, command buttons, button groups, pull-down menus, galleries, tooltips, live preview, Format Cells | | Excel Interface 3 | TechHelp Excel, Excel interface, Quick Access Toolbar, Status Bar, Zoom Control, Scroll Bars, Excel views, Page Layout View, Page Break Preview, Normal View, add buttons Quick Access Toolbar, customize Status Bar, Excel navigation, Excel zoom, Excel scrol | | Excel Interface 4 | TechHelp Excel, Excel interface, formula bar, spreadsheet parts, columns, rows, cells, name box, mouse pointer, sheet tabs, resize column, select column, select row, Excel workbook, add sheets, delete sheets, rename sheets, sheet formatting | | Excel TechHelp | techhelp excel directory | | Expense Tracker | TechHelp Excel recurring expense tracker, monthly expenses, annual expenses, weekly expenses, EDATE Function, DATE Function, YEAR Function, MONTH Function, DAY Function, IF Function, TODAY Function, Nested IF | | Fill & Series | TechHelp Excel, Autofill, Fill handle, Fill button, series fill, Excel fill series, linear series, growth series, date series, fill across worksheets, step value, stop value, trend fill, fill down, fill right, fill left, weekdays fill, overwrite cells | | Filtering Data 1 | TechHelp Excel, Excel filter, Excel filtering data, Excel filter multiple columns, Excel data tab, Excel sort filter group, filter by store Excel, filter by manager Excel, Excel drop down filter, Excel filter tips, Excel sample data download | | Filtering Data 2 | TechHelp Excel, Excel filter, Excel advanced filter, Excel custom filter, Excel date filter, Excel number filter, Excel text filter, Excel OR AND filter, Excel wildcard filter, Excel top 10 filter, filter by blank cells, reapply filter Excel, filter by co | | Financial Terms | TechHelp Excel, Excel financial functions, present value, future value, PMT, interest rate, NPER, loan payment calculation, compound interest, simple interest, mortgage calculation, car loan payment, financial terms Excel, APR, savings account interest | | Find & Replace | TechHelp Excel, find and replace Excel, Excel find, Excel replace, find in Excel, replace in Excel, Excel sales ledger, sort Excel, Excel data search, replace all Excel, Excel customer list, Excel copy paste, Excel columns, Excel formatting, find all Exce | | First Pivot Table | TechHelp Excel, pivot table, Excel, create pivot table, sales by city, sales by year, summarize data, Pivot Table Field List, Insert tab, table vs range, values, sum sales, drag fields, row labels, column labels, grand total, SUMIF, report filters | | Flowcharts | TechHelp Excel, Excel flowchart, flowchart creation, shape formatting, Excel connector types, Excel hyperlink feature, Excel flowchart symbols, Excel decision diamond, Excel process rectangle, Excel terminator oval, Excel check mark and X, Excel text form | | Formatting 2 | TechHelp Excel, change font, font size, resize columns, resize rows, change background color, change text color, fill color, font face, column width, row height, bold text, italic text, underline text, formula bar, theme colors, highlight cells | | Formatting Basics | TechHelp Excel, spreadsheet formatting, cell alignment, bold cells, italics, underline, select multiple cells, cell ranges, horizontal alignment, vertical alignment, Excel formatting, column headers, font group, cell selection, undo formatting | | Functions 1 | TechHelp Excel, Excel functions, Excel SUM function, add numbers in Excel, Excel formula, sum column Excel, Excel average function, Excel max min count, Excel 2010 functions, Excel range formula, Excel auto update formula, basic Excel functions | | Functions 2 | TechHelp Excel, sum function, average function, count function, max function, min function, Excel functions, Excel formulas, AVERAGE formula, COUNT formula, MAX formula, MIN formula, spreadsheet shortcuts, auto sum, cell range selection, moving cells, edi | | Functions 3 | TechHelp Excel, Excel functions, sum function, average function, max function, min function, count function, autofill, decrease decimal, increase decimal, formatting numbers, sales data, bold formatting, Excel tips, spreadsheet practice | | Grouping Data | TechHelp Excel, pivot table grouping, group dates in pivot table, group months in pivot table, group by week pivot table, group by range pivot table, dynamic pivot table data, change pivot table data source, subtotal in pivot table, ungroup pivot table | | Happy Birthday Excel | TechHelp Excel, Excel leap year bug, Lotus 123 compatibility, secret games, Hall of Tortured Souls, flight simulator, Dev Hunter, toolbar with icons, Lambda function, camera tool, gene names to dates, mouse scroll wheel inspiration, spreadsheet disasters, | | Header & Footer | TechHelp Excel, Excel header and footer, page numbers Excel, insert date in header, insert time in footer, Excel print formatting, file path in header, sheet name in footer, Excel page layout view, logo in header, different first page header, odd even pag | | Home Value Calculator | TechHelp Excel, PV function, present value, mortgage calculator, home affordability, monthly payment calculation, 30 year mortgage, interest rate, number of periods, PMT, future value, payment type, house shopping, loan approval, home value estimation | | IF Function 1 | TechHelp Excel, Excel IF function, IF statement Excel, Excel conditional formulas, Excel logic functions, Excel pass fail formula, Excel sales tax calculation, absolute reference Excel, Excel cell references, Excel named ranges, Excel autofill | | IF Function 2 | TechHelp Excel, IF function, nested IF, letter grades Excel, VLOOKUP, Excel timesheet over midnight, calculate overtime pay, Excel regular vs overtime hours, Excel logic functions, Excel date and time, formula for overtime, employee payroll Excel | | Illustrations | TechHelp Excel, insert picture Excel, clip art Excel, Excel Format Picture tab, resize picture Excel, move picture Excel, rotate picture Excel, picture styles Excel, artistic effects Excel, compress pictures Excel, recolor picture Excel, change picture Ex | | Illustrations 2 | TechHelp Excel, insert shapes, format shapes, add text to shape, shape styles, shape effects, Word Art, drawing tools, change shape color, add outline, adjust shape size, add arrow, group shapes, arrange shapes, delete shape, edit text in shape | | Initial Deposit | TechHelp Excel, PV function, initial deposit calculation, present value formula, bank account interest, future value, financial functions, find original deposit, interest rate calculation, account balance, compound interest example | | Insert Text 1 | TechHelp Excel, Excel hyperlinks, insert hyperlink Excel, hyperlink to web page Excel, hyperlink to email Excel, hyperlink to Google Maps Excel, Excel 2010 hyperlinks, link to file Excel, Excel hyperlink options, Excel insert tab, Excel text group | | Insert Text 2 | TechHelp Excel, text box, WordArt, signature line, insert object, insert symbol, Excel insert tab, drawing tools format, digital signature, embedded files, display as icon, Wingdings, Webdings, special characters, header and footer, geometric shapes | | Interest Rate Finder | TechHelp Excel, interest rate calculator, Excel RATE function, return on investment, APR calculation, calculate interest rate Excel, investment analysis Excel, present value, future value, Excel financial functions, ROI calculation, negative numbers Excel | | Introduction | TechHelp Excel, Excel 2010, freeze panes, split spreadsheet, insert hyperlinks, text boxes, WordArt, signature line, headers and footers, format painter, merge and center, wrap text, comments, borders, gridlines, spell check, thesaurus, templates, stock q | | Introduction | TechHelp Excel, pivot tables, Excel 2010, pivot charts, slicers, grouping data, edit pivot table, pivot table design, filter and sort pivot table, Excel expert, build pivot table, sales data analysis, collapse expand levels, Excel forums, custom grouping | | Introduction | TechHelp Excel, protect worksheet data, protect workbook files, advanced copy and paste, paste special options, office clipboard, fill series, data entry forms, excel data protection, password protect workbook, autofill, excel expert, excel forms, vba, ma | | Introduction | TechHelp Excel, advanced sorting, advanced filtering, customize Excel ribbon, Excel 2010, custom lists, Quick Access Toolbar, filter data, user interface, Roman numerals sorting, macros, user forms, templates, Visual Basic for Applications, integrate Offi | | Introduction | TechHelp Excel, Excel financial functions, loan calculator, investment calculator, interest rate calculator, millionaire calculator, home value calculator, loan amortization schedule, credit card payoff, PV function, Excel expert level | | Introduction | TechHelp Excel, Excel 2010, cut copy paste, AutoFill, cell formatting, sort data, conditional formatting, find and replace, rows and columns, insert delete rows, insert delete columns, worksheets, rename worksheet, move worksheet, copy worksheet, Excel fo | | Introduction | TechHelp Excel, Excel 2010, Excel beginner, Excel interface, ribbon, Quick Access Toolbar, formatting spreadsheets, basic math operations, formulas, cell alignment, saving workbooks, printing spreadsheets, entering data, editing data, rows columns cells | | Introduction | TechHelp Excel, custom views, subtotal function, data validation, drop down lists, outlines, filtered data, grouping data, ungrouping data, outline subtotal, manual outline, custom range formats, cascading drop down lists, Dget function, social security n | | Introduction | TechHelp Excel, Excel 2010 charts, Excel 2010 column chart, Excel 2010 pie chart, Excel 2010 line chart, Excel 2010 3D charts, Excel 2010 data tables, chart formatting, Excel chart styles, Excel chart axes, Excel chart legends, Excel filter sort tables | | Introduction | TechHelp Excel, Excel 2010 dates and times, Excel date functions, Excel time functions, custom date format Excel, date arithmetic Excel, Excel date difference, Excel time difference, ExcelYearfrac, ExcelEdate, ExcelEomonth, ExcelNetworkdays, ExcelWorkday, | | Introduction | TechHelp Excel, Excel 2010 formulas, Excel 2010 functions, function library, relative vs absolute references, named ranges, name manager, reference other worksheets, text functions, concatenate, len, left, right, mid, find, search, substitute, replace, tr | | Introduction | TechHelp Excel, Excel 2010 functions, Sum function, Average function, Count function, Max function, Min function, styles, themes, page layout, margins, orientation, paper size, print area, inserting pictures, clip art, shapes, WordArt, SmartArt | | Introduction | TechHelp Excel, Excel 2010 logic functions, IF function, AND function, OR function, NOT function, nested IF, ISBLANK, ISERROR, IFERROR, ISNUMBER, ISTEXT, ISLOGICAL, ISEVEN, ISODD, timesheet over midnight, calculate overtime, letter grade formula | | Introduction | TechHelp Excel, sum function, sumif, sumifs, running balance, counting functions, rounding functions, median, mode, product function, square root, absolute value, random numbers, trigonometric functions, tangent function, sine, cosine, degrees, radians | | Introduction | TechHelp Excel, VLOOKUP, lookup functions, HLOOKUP, MATCH, INDEX, ADDRESS, INDIRECT, Excel 2010, Excel expert, compare lists, range lookup, exact match, employee timesheet, find closest value, logic functions, IF function, IS functions | | Introduction | TechHelp Excel, XLOOKUP, video time conversion, Excel combo box, Excel 2019, double lookup, Developer tab, match mode, wildcard search, VLOOKUP limitations, convert time text, Excel Office 365, Excel VBA, macro programming | | Investment Calculator | TechHelp Excel, investment calculator, future value function, FV formula, Excel savings calculation, compound interest, APR calculation, Excel FV example, Excel financial functions, interest over years, Excel investment chart, calculate future investment | | IS Functions | TechHelp Excel, ISBLANK, ISERROR, ISEVEN, ISODD, ISLOGICAL, ISNUMBER, ISTEXT, ISNONTEXT, IFERROR, Excel logical functions, Excel error handling, Excel mailing labels, Excel concatenate, Excel IS functions, Excel formulas | | Line Charts | TechHelp Excel, Excel charts, add data to chart, line chart, multiple series chart, chart styles, chart themes, select data, dynamic chart axes, chart design tab, chart data range, 3D chart, trends in data, chart formatting, change chart look | | Loan Amortization | TechHelp Excel, loan amortization schedule, Excel amortization template, loan payment breakdown, interest vs principal, PMT function, IPMT function, PPMT function, CUMIPMT, CUMPRINC, cumulative interest, mortgage schedule, extra loan payments, Excel finan | | Loan Calculator | TechHelp Excel, Excel loan calculator, mortgage calculator, PMT function, calculate monthly payment, Excel financial functions, interest calculation, down payment comparison, total mortgage payments, Excel round function, home loan Excel, amortization Exc | | Logic Functions | TechHelp Excel, logic functions, Excel Boolean, AND function, OR function, NOT function, true false values, Boolean in Excel, logical operators, Excel conditional formulas, IF function preview, Excel sales tax, paid status Excel, Excel credit card batch, | | MCA Loan Calculator | TechHelp Excel excel mca loan calculator, Merchant Cash Advance (MCA) Calculator | | Millionaire Calculator | TechHelp Excel, millionaire calculator, financial goal calculator, compound interest, reach one million dollars, savings plan, future value calculation, monthly deposit, NPER function, Excel finance, bank interest, investment period calculation, interest | | Misc Format Tricks | TechHelp Excel, merge and center, cell orientation, format painter, merge cells, unmerge cells, format cell alignment, vertical text, rotate text, change text angle, copy cell formatting, alignment group, change cell borders, highlight data, apply cell fo | | Misc Math | TechHelp Excel, Excel math functions, Excel statistics functions, median function, mode function, product function, power function, quotient function, mod function, ABS function, sign function, square root Excel, scientific notation Excel, randbetween, ra | | More With SUM | TechHelp Excel, SUM function, sum multiple ranges, running balance, non-contiguous ranges, absolute references, autofill, Insert Function button, balance sheet formula, ISBLANK, left justify, right justify, create running total | | Named Cells, Ranges | TechHelp Excel, named cells, named ranges, Excel Name Manager, absolute references, relative references, Excel name box, define name, Excel scope, VLOOKUP lookup table, Excel sum function, Excel named range formula, manage named cells, Excel defined names | | Online Templates | TechHelp Excel, download Excel templates, Microsoft Office templates, Excel calendar template, Excel invoice template, Excel mortgage calculator, loan amortization Excel, office.com templates, Excel financial templates, free Excel templates, Excel search | | Other Lookups | TechHelp Excel, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, Excel lookup functions, backward lookup, absolute reference, grid lookup, wildcard lookup, Excel array, lookup vector, result vector, exact match, quantity discount, drop-down list Excel | | Outline Subtotals | TechHelp Excel, Excel outline subtotal, Excel subtotals, group data in Excel, subtotal groups Excel, Excel data sorting, multiple subtotals Excel, Excel outline feature, Excel subtotal function, data grouping Excel, remove subtotals Excel, Excel sum, Exce | | Outlines | TechHelp Excel, manual outline, group and ungroup data, Excel outline, Excel subtotal, grouping columns, collapse columns, data tab, subtotal feature, outline group, clear outline, auto outline, sheet protection, custom views, nested grouping, subtotal fu | | Page Layout | TechHelp Excel, Page Layout tab, Excel margins, page orientation, print area, page breaks, background image, gridlines, headings, workbook views, print preview, custom margins, landscape mode, set print area, remove page break, sheet options | | PivotCharts | TechHelp Excel, pivot chart, pivot table, create pivot chart, insert pivot chart, 3D column chart, pivot chart tools, chart filters, report filter, slicer, chart layout, chart styles, field list, value field settings, move chart, print chart | | PivotTable Design | TechHelp Excel, pivot table design, pivot table options, pivot table design tab, subtotals, grand totals, report layout, compact form, outline form, tabular form, banded rows, banded columns, pivot table styles, slicers, double click reveal data | | PivotTable Options | TechHelp Excel, pivot table, Excel 2010, slicers, pivot table options, value field settings, group data, report filters, sum of sales, average of sales, count of sales, grand totals, filter fields, defer layout update, slicer connections, data formats | | Protect Workbook | TechHelp Excel, protect workbook, protect worksheet, excel password, excel protect structure, restrict editing excel, excel windows protection, excel read only, encrypt excel file, password to open excel, password to modify excel, excel digital signature, | | Protect Worksheets | TechHelp Excel, protect worksheet, lock cells, unlock cells, allow users to edit ranges, Excel sheet protection, password protect sheet, hide formulas, prevent editing formulas, allow cell formatting, set editable cells, Excel review tab, protect formulas | | Research Tools | TechHelp Excel, Excel spell checker, Excel thesaurus, Excel translate, Excel stock quotes, import stock prices Excel, get external data Excel, refresh stock data Excel, translate words Excel, review tab Excel, proofing Excel, Yahoo Finance Excel | | Review & What's Next | TechHelp Excel, Excel VBA, Excel macro programming, Excel developer, Excel user form controls, Excel 2019 updates, Excel charting changes, Excel forums, Excel TechHelp, 599cd, ExcelLearningZone, Learning Connection, VBA coding | | Review & What's Next | TechHelp Excel, functions, AutoSum, function library, relative reference, absolute reference, sales tax calculation, named cells, named ranges, Name Box, Name Manager, concatenate, ampersand, text functions, LEFT, RIGHT, MID, FIND, SUBSTITUTE, TRIM | | Review & What's Next | TechHelp Excel, Excel if function, nested if, and or not, logic functions, isblank, iserror, istext, Excel decision making, Excel functions, Excel 2010, Excel tips, Excel formulas, Excel student forums, Excel expert level | | Review & What's Next | TechHelp Excel, Excel headers and footers, insert hyperlinks Excel, Excel text boxes, Excel Word Art, freeze top row Excel, split sheet Excel, Excel borders, gridlines Excel, Format Painter Excel, Excel comments, Research pane Excel, Excel templates, Exce | | Review & What's Next | TechHelp Excel, Excel functions, SUM function, AVERAGE function, COUNT function, MAX function, MIN function, cell styles, themes, page layout, print preview, print area, insert picture, clip art, shapes, SmartArt, WordArt, screenshot, Excel charts, tables | | Review & What's Next | TechHelp Excel, pivot table, Excel pivot tables, pivot table filters, pivot table grouping, pivot chart, slicers, report filter, value filter, label filter, subtotals, grand totals, data subset, Excel tips, banded rows, custom grouping, ExcelLearningZone | | Review & What's Next | TechHelp Excel, SUM function, SUMIF, SUMIFS, COUNT, COUNTA, COUNTBLANK, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, MEDIAN, MODE, PRODUCT, ABS, random numbers, trigonometry Excel, TAN function, running balance, Excel statistics functions | | Review & What's Next | TechHelp Excel, Excel charts, Excel tables, column chart, pie chart, bar chart, 3D chart, chart styles, chart themes, chart formatting, leader lines, Excel dashboard, summary sheet, Excel templates, freeze panes, split window, merge cells, format painter, | | Review & What's Next | TechHelp Excel, Excel 2010, cut copy paste, AutoFill, cell formats, currency format, accounting format, insert rows, delete columns, sheet tabs, conditional formatting, find and replace, SUM function, AVERAGE, COUNT, MAX, MIN, styles and themes, page layo | | Review & What's Next | TechHelp Excel, Excel 2010, Excel ribbon, Quick Access Toolbar, Excel zoom controls, Excel view buttons, format cells, resize rows columns, Excel formulas, order of operations, save workbook, print spreadsheet, conditional formatting, find and replace | | Review & What's Next | TechHelp Excel, Excel dates, Excel times, Excel date format, Excel time format, Excel date arithmetic, Excel time functions, Excel now function, Excel today function, Excel date difference, Excel age calculation, Excel yearfrac, Excel datedif, Excel workd | | Review & What's Next | TechHelp Excel, Excel financial functions, PMT function, FV function, loan calculator, investment calculator, NPER function, RATE function, amortization schedule, IPMT function, PPMT function, cumulative interest, credit card calculator, pivot table | | Review & What's Next | TechHelp Excel, advanced sorting, custom sort, sorting by color, conditional formatting sort, filter data, advanced filter, custom list, Excel ribbon customization, quick access toolbar, top 10 filter, wildcard characters, sorting by birth month | | Review & What's Next | TechHelp Excel, custom views, Quick Access Toolbar, subtotal function, filtering, outline subtotals, collapse expand ranges, nested subgroups, manual outlines, group ungroup data, auto outline, data validation, validation rules, drop-down lists, condition | | Review & What's Next | TechHelp Excel, worksheet protection, locked cells, unlocked cells, Excel password, sheet protection, workbook protection, advanced copy and paste, smart tags, paste values, Office clipboard, fill series, data entry forms, Quick Access Toolbar, Excel tips | | Review & What's Next | TechHelp Excel, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, backward lookup, range lookup, exact lookup, ADDRESS function, INDIRECT function, compare two lists Excel, find closest value Excel, Excel math functions, Excel statistical functions | | Rows & Columns | TechHelp Excel, insert rows, delete rows, insert columns, delete columns, clear contents, Excel rows vs columns, Excel formatting, right click delete, right click insert, shift cells, undo delete, insert multiple rows, insert multiple columns, shift cells | | Running Sum | TechHelp Excel, Running Total, Running Average, Running Sum, Running Balance, Cumulative Total, Cumulative Sum, Cumulative Running Total, AutoSum Cumulative, Cumulative Formula, Daily Totals, Progressive Total, How to Add Totals Down a Column, Sum to Curr | | Save, Load, Print | TechHelp Excel, save Excel workbook, save as Excel, open Excel file, print Excel spreadsheet, Excel file extensions, Excel recent workbooks, Excel pin workbook, Excel templates, new blank workbook, close Excel workbook, Excel quick access toolbar, Excel f | | Select Objects | TechHelp Excel, select and move multiple shapes Excel, select multiple objects Excel, move shapes together Excel, Select Objects tool Excel, Find and Select Excel, select all shapes Control A, group objects Excel, ungroup shapes Excel, move objects with a | | SmartArt & WordArt | TechHelp Excel, SmartArt, insert screenshot, WordArt, Excel Insert tab, illustrations group, SmartArt process, SmartArt design, SmartArt layout, Excel screenshots, screen clipping, editing SmartArt, change WordArt, Excel shapes, customize SmartArt | | Sorting Data | TechHelp Excel, Excel sorting, sort data Excel, Excel sort column, Excel sort by name, Excel sort by totals, sort data with headers Excel, sort excluding totals Excel, Excel custom sort, Excel sort warning, Excel sort errors, sort by multiple columns Exce | | Split & Convert | TechHelp Excel, Text to Columns, split CSV data, date formatting, month-day-year conversion, line chart creation, importing data to Excel, sorting data, ISO date format, CSV to Excel columns, water usage chart, Excel beginner tutorial, resizing columns, E | | Stock History | TechHelp Excel how do i get stock history in excel, STOCKHISTORY function, excel 365, microsoft 365, advanced excel tricks, excel for analysts, stockhistory formula, excel stockhistory function, historical stock data excel, combo box, drop-down lists, his | | Stock Portfolio | TechHelp Excel tracking stocks in excel, get latest stock data in excel, stock portfolio, stock dashboard, pull live stock data, track your portfolio, investment portfolio tracker template, stock prices in excel, stock quotes | | Styles & Themes | TechHelp Excel, Excel styles, Excel themes, cell styles, change workbook appearance, conditional formatting, Excel formatting, theme colors, standard colors, change all styles, Excel fonts, format entire workbook, custom themes, style gallery | | SUBTOTAL Function | TechHelp Excel, subtotal function, Excel subtotal with filtered data, sum vs subtotal, sum filtered rows, Excel hidden rows, subtotal 109, Excel count filtered, Excel average filtered, subtotal 9, Excel auto filter sum, subtotal function limitations, auto | | SUMIF | TechHelp Excel, SUMIF, Excel SUMIF function, sum with criteria, Excel formulas, conditional sum, sales commission Excel, SUMIF greater than, SUMIF variable criteria, SUMIF absolute reference, COUNTIF, AVERAGEIF, sales rep totals, Excel sum range | | SUMIFS | TechHelp Excel, SUMIFS, SUMIF, Excel 2007, multiple criteria, commissionable sales, absolute references, autofill, past due, unpaid orders, conditional formatting, TODAY function, AVERAGEIFS, COUNTIFS, sum range, criteria range, Excel formulas | | Tables | TechHelp Excel, Excel tables, insert table in Excel, Excel table formulas, Excel filter table, Excel sort data, total row Excel, format as table Excel, Excel structured references, sum function Excel, Excel database features, add row to table Excel, delet | | Text Functions 1 | TechHelp Excel, EXACT function, CONCATENATE function, LEFT function, RIGHT function, MID function, LEN function, FIND function, SEARCH function, separate first and last name, extract text, case sensitive comparison, Excel wildcards, Excel text functions | | Text Functions 2 | TechHelp Excel, SUBSTITUTE function, REPLACE function, TRIM function, remove extra spaces, replace text in cell, change text in cell, Excel text functions, serial number editing, clean up data, concatenate names, autofill, Find and Replace | | Text to Columns | TechHelp Excel text to columns, split list, separate list of text, comma delimited | | Timestamp | TechHelp Excel update date of transaction, update date in row, timestamp, date and time stamp, worksheet change event, target.row, target.column, named range, double-entry accounting, excel update transaction date column automatically, Excel Automatically | | Trig Functions | TechHelp Excel, trigonometry in Excel, Excel tangent function, Excel trigonometric functions, calculate building height Excel, radians and degrees Excel, Excel sine, Excel cosine, PI function Excel, DEGREES function, RADIANS function, right triangle Excel | | Values on Other Sheets | TechHelp Excel, referencing cells other sheets Excel, summary sheet Excel, paste link Excel, sheet name Excel, named ranges Excel, cross sheet formulas, name manager Excel, moving data between sheets, AutoSum Excel, AutoFill Excel, Excel dashboard basics | | Video Time Conversion | TechHelp Excel, video time conversion, Excel time index, time string manipulation, YouTube video chapters, Excel text functions, concatenate time, MID function, FIND function, LEN function, MOD function, QUOTIENT function, Excel time formatting, YouTube t | | View Window | TechHelp Excel, Freeze Panes, split worksheet, Excel View tab, large spreadsheets, freeze top row, freeze first column, unfreeze panes, split window, scroll bars, align columns, format paint, resize columns, data entry, sales tracking, window group | | VLOOKUP 2 | TechHelp Excel, VLOOKUP, Excel range lookup, grade lookup table, convert grades to letters, Excel IF function, nested IFs, ISBLANK, Excel named range, autofill Excel, convert to table Excel, assigning letter grades, Excel formulas for grades | | VLOOKUP 3 | TechHelp Excel, VLOOKUP, Excel timesheet, employee payroll, exact match VLOOKUP, Excel tables, employee ID lookup, pay rate calculation, automatic name fill, total pay formula, ISBLANK function, format as currency, Excel formulas, conditional formatting | | VLOOKUP Basics | TechHelp Excel, VLOOKUP, lookup functions, Excel lookup, Excel VLOOKUP, table array, absolute reference, named range, HLOOKUP, INDEX, MATCH, weekday function, Excel autofill, lookup table, column index, Excel sheet, Days of Week | | What is a PivotTable | TechHelp Excel, pivot tables, Excel pivot table, analyze data, data summary, cross-tabulation, data trends, sales analysis, filter data, summarize data, group data, sales by store, sales by product, subtotals, data relationships, data visualization, funct | | Working With Functions | TechHelp Excel, Excel functions, Excel formulas, AutoSum, function library, concatenate, string concatenation, text functions, Insert Function, formula bar, cell references, sum function, max function, average function, logical functions, categories | | Worksheet Change | TechHelp Excel vba worksheet change | | Worksheets | TechHelp Excel, insert worksheet, delete worksheet, rename worksheet, move worksheet, copy worksheet, change sheet tab color, Excel sheets, workbook organization, Shift F11, move or copy sheet, tab color, sheet tab names, Excel sheet management | | XLOOKUP 1 | TechHelp Excel, XLOOKUP, VLOOKUP, HLOOKUP, Excel 2019, Excel lookup functions, Excel exact match, Excel reverse search, Excel lookup table, Excel letter grades, WEEKDAY function, Excel autofill, Excel absolute reference, value not found Excel | | XLOOKUP 2 | TechHelp Excel, XLOOKUP multiple values, XLOOKUP match mode, XLOOKUP wildcard, XMATCH function, XLOOKUP search mode, XLOOKUP if not found, Excel employee lookup, return array XLOOKUP, Excel wildcard search, Excel binary search, XMATCH vs MATCH | | XLOOKUP 3 | TechHelp Excel, XLOOKUP, two-way XLOOKUP, double XLOOKUP, Excel combo box, Excel two-way lookup, Excel nested XLOOKUP, Excel grades lookup, XLOOKUP match mode, Developer tab, Excel form controls, Excel matrix lookup, Excel drop down list | | XLookup Function | TechHelp Excel XLookup |
| | FastTips Excel | | Concatenation | FastTips Excel #msexcel, #microsoftexcel, #microsoft excel, #excel, #exceltips, concatenation, concatenate | | Flash Fill | FastTips Excel flashfill, flash fill |
|
| |
|
