Search TeachExcel.com
TeachExcel.com
TE
Teach Excel MS Office Tutorials Excel Consulting Services Excel Forum
Excel Video Tutorials Excel Tips Free Excel Macros Excel Help Resources Contact TeachExcel
Video Tutorials
  • Free Macros
  • Excel Help Directory
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Excel Forum
  • Contact/About

Tutorials
Category View   List All Tutorials
Tutorial Rating Legend
          
    Easy Assumes no previous knowledge; good for beginners.
    Easy Trickier than other easy tutorials but still good for the beginner.
    Intermediate Difficult but no specific prior knowledge is needed to follow along.
    Intermediate Assumes some prior knowledge of excel and basic formulas.
    Intermediate These tutorials involve complicated topics which require a lot of knowledge of excel or which utilize basic functions in an inconventional or complicated way.
    Advanced These will be the toughest tutorials. They are usually the most involved in terms of building a model in excel or using complex formulas which can be very confusing.
Excel Macro VBA Tip 1 - How to Write Your Very First Macro in Microsoft Excel  (Easy)
- This is a great introduction to macros and vba and Microsoft Excel macros. You
Excel Macro VBA Tip 2 - Using The Range Property to Select Cells in Excel  (Intermediate)
- This Excel Macro VBA tutorial shows you how to select a range of cells in Excel
Excel Macro VBA Tip 3 - Using The Range Property in Excel Macros to Select Columns and Rows  (Intermediate)
- This Excel VBA Macro tutorial includes a description of how to selection entire
Excel Macro VBA Tip 4 - Find Cells in Excel with Macros using the Find Method  (Intermediate)
- This tutorial shows you how to find a cell with a certain value anywhere through
Excel Macro VBA Tip 5 - Learn How to Input Values, Text, Numbers, and Formulas into Cells in Excel  (Intermediate)
- This tutorial shows you how to input values, text, numbers, and formulas into ce
Excel Macro VBA Tip 6 - IF Then Statement in Excel Macros and VBA  (Intermediate)
- Learn how to create and use an IF Then Statement in Microsoft Excel Macros and V
Excel Macro VBA Tip 7 - Check if a Cell in Excel is Empty Using Macros in Excel  (Intermediate)
- Learn how to check if a cell in Excel is empty using Macros in Excel. This tuto
Excel Macro VBA Tip 8 - Hide UnHide Rows and Columns in Excel with a Macro  (Intermediate)
- Learn to hide and unhide columns and rows in Microsoft Excel using a macro. Thi
Excel Macro VBA Tip 9 - Enter Formulas in Excel with a Macro  (Intermediate)
- Learn to enter formulas and values into Microsoft Excel with a macro. This tuto
Excel Macro VBA Tip 10 - Enter Array Formulas into Cells in Excel with a Macro  (Intermediate)
- Learn to input array formulas into cells using a macro in Excel. This is import
Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel  (Intermediate)
- This Excel Video Tutorial shows you how to use the VLOOKUP() function with looku
Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel  (Intermediate)
- This Excel Video Tutorial will show you how to use the VLOOKUP() function in Exc
Excel Lookup/Search Tip 3 - Vlookup Explanation 2 - Vlookup to Search an Employee Database  (Intermediate)
- Learn how to use the VLOOKUP() function in Microsoft Excel in the second walk-th
Excel Lookup/Search Tip 4 - Vlookup Explanation 3 - Vlookup to Assign Grades to Students  (Intermediate)
- Traditional VLOOKUP() function example in Excel. This tutorial teaches you how
Excel Lookup/Search Tip 5 - Vlookup - IFERROR with Vlookup to Assign Values Instead of Errors  (Easy)
- Use the new IFERROR() function in Excel 2007 in conjunction with the VLOOKUP() f
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation  (Intermediate)
- Learn how to use the VLOOKUP function in Excel in conjunction with a data valida
Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it  (Intermediate)
- Learn how to use the VLOOKUP function in Excel to search a database or table arr
Excel Lookup/Search Tip 1 - Using Index and Match - It's Better than Vlookup  (Intermediate)
- Learn how to use the Index and Match lookup functions in Microsoft Excel. They
Excel Lookup/Search Tip 2 - Vlookup Explanation 1 - Display Product Suppliers from a List/Database  (Easy)
- Learn how to use the VLOOKUP() function in Microsoft Excel. This tutorial will
View Live Stock Quotes in Microsoft Excel - MSN MoneyCentral Investor Stock Quotes  (Easy)
- Learn how to view Live Stock Quotes in Microsoft Excel. This tutorial shows you
Combine/Merge Cells in Microsoft Excel - Make Better Headers  (Easy)
- This Microsoft Excel video tutorial shows you how to merge a cell in Excel. Thi
Count Cells That Only Contain Text in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to write a formula which will count the
Create Dynamic Named Ranges in Excel Across Rows Going Up/Down  (Intermediate)
- This is a great tutorial which shows you how to make a named range within Excel
Change Columns from Letters to Numbers in Excel 2007  (Easy)
- This free excel video tutorial shows you how to change the columns in excel 2007
Make Dynamic (Automatically Updating) References in Formulas and Functions in Excel  (Intermediate)
- This excel vidoe tutorial shows you how to make a truly dynamic range reference
Insert Macros into an Excel Workbook or File and Delete Macros from Excel  (Intermediate)
- This video tutorial shows you how to insert a macro you may find on the internet
Assign a Macro to a Button, Check box, or any object in Microsoft Excel  (Intermediate)
- This video tutorial shows you how to attach or assign a macro in excel to a butt
Generate Random Numbers with Decimals in Microsoft Excel  (Intermediate)
- This tutorial shows you how to generate random numbers which have decimals in ex
Dynamically Updated Vlookup Table in Microsoft Excel  (Intermediate)
- This Microsoft Excel tutorial shows you how to make a dynamically updating vlook
Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.  (Intermediate)
- This Microsoft Excel video tutorial shows you how to make a list in excel where
Generate Random Numbers (Integers) in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to generate random numbers (integers) in
Create a Drop Down Menu with Data Validation in Microsoft Excel  (Easy)
- The Excel video tutorial shows you how to create a drop-down list/menu in excel.
Quickly Copy/Paste Data, Formulas, Text in Excel Using the Quick Fill Handle  (Easy)
- This Excel video tutorial shows you how to quickly copy and paste data and formu
Allow only values contained in a list to be entered into a cell - Data Validation  (Intermediate)
- This Excel video tutorial shows you how to use Data Validation to prevent a user
Extract Text from cells in Excel - How to get any word from a cell in Excel  (Intermediate)
- This Excel video tutorial shows you how to extract text from cells. Specificall
Dynamically Update a Drop Down Menu/List  (Intermediate)
- This Excel video tutorial shows you how to create a dynamically updating drop-do
Extract Text from Cells - Intermediate Example  (Intermediate)
- This is a video tutorial that will show you how to use the FIND() LEN() LEFT() a
Remove #N/A Error Result from Empty VLOOKUP() Formulas  (Intermediate)
- This video tutorial will show you how to remove the #N/A error that results in a
Lookups With MATCH() and INDEX() Functions  (Intermediate)
- This video tutorial will show you how to use the MATCH() and INDEX() functions w
Introduction to Making Formulas in Excel  (Easy)
- Here, you will learn what formulas are and how they can benefit you in excel. Th
IF Statement Introduction & Using Nested IF's  (Easy)
- How to use a basic IF statement. If you've never used one before, this will show
HLOOKUP() Function - Introduction  (Intermediate)
- This is a video tutorial that shows you how to use the HLOOKUP() function in exc
Function and Formulas Lookup in Excel  (Easy)
- This video tutorial will show you how to use the insert function feature in exce
AND(), OR(), and IF() Statements/Formulas  (Intermediate)
- How to use AND() and OR() functions within and IF statement and also what the AN
Absolute and Relative Cell References
   - & INDIRECT() Function Introduction  (Easy)
- This is a video tutorial for Microsoft Excel which shows you how to make absolut
Link Cells Between Worksheets  (Easy)
- Here, you will see how to link cells between worksheets in excel. This will allo
Consolidate & Combine Data from Separate Worksheets or Workbooks(Excel Files)  (Intermediate)
- This video tutorial will show you how to combine data from separate worksheets,
How to record a Macro - And what One is  (Easy)
- This is an introduction to what Macros are and how they can make your life easie
Assign a Macro to a Button and Toolbar  (Intermediate)
- How to assign a recorded macro to a button and a toolbar at the top of excel. Al
Assign Keyboard Shortcuts to Macros  (Easy)
- How to assign a keyboard shortcut to a macro after is has been recorded. Good if
Formatting Worksheets for Printing in Excel  (Easy)
- This Excel video tutorial shows you how you can adjust how a worksheet will look
Printing Multiple Worksheets and Workbooks  (Easy)
- You will learn how to print multiple worksheets at one time, part of one workshe
How to 'Protect' a Worksheet and Workbook  (Easy)
- You can make it so that no one, or only a certain person or group of people, can
Password Protect Excel Workbook Files  (Easy)
- You can password protect your excel files and make it so that only one person or
Locking & Unlocking Cells to Protect Data in Excel  (Easy)
- This excel tutorial shows you how to lock and ulock cells in excel. This is a f
Hide Rows & Columns in Excel  (Easy)
- Here, you will learn how to protect data in your worksheets by hiding it. You ca
Goal Seek Feature in Excel  (Intermediate)
- The goal seek tool in Microsoft Excel allows you to use excel to figure out what
Net Present Value / Discounted Cash Flow Calculations  (Intermediate)
- This video tutorial for excel shows you how to compute the net present value and
FV() Find the Future Value of Cash Today
         -Savings/Retirement Plan Calculations  (Intermediate)
- This excel video tutorial shows you how to get the future value of a savings or
Bond Pricing Calculations for Simple Bonds
         - Future Value, Present Value, Interest Rate, etc.  (Intermediate)
- This video tutorial shows you how to value and price simple bonds through excel.
Make a Thermometer Style Chart in Excel  (Intermediate)
- This is a video tutorial which will show you how to make and modify a chart/grap
Excel Magic Trick #8: Text To Column
- Excel! Need to separate first and last name into two cells? Need to take a colum
Excel Magic Trick #7: Clear Formatting Only!
- Excel! See how to remove the formatting from the cell, but not the cell content!
Excel Magic Trick #6: Conditional Formatting for a Row
- Excel! See how to add Conditional Formatting to a whole row of data. See that th
Excel Magic Trick #5: Data Validation List & VLOOKUP
- Excel! See how to name a cell range, use data validation to add a drop-down list
Excel Magic Trick # 3: AVERAGE & Go To Blanks
- Excel! Learn how to use the Ctrl + Enter keyboard Trick to enter formulas or dat
Excel Magic Trick #12: Date Math!
- Excel! Learn how to calculate the time between 2 dates like invoices past due. L
Excel Magic Trick #11: How Good Is Your Average?
- Excel! Learn 3 types of Variation measures including Standard Deviation. See how
Excel Magic Trick #4: SUM function Keyboard Trick
- Excel! See how to add data or a formula to a range of cells by using Ctrl + Ente
Excel Magic Trick # 10: 3 types of Averages!
- Excel! 3 types of Averages! See how to use the AVERAGE, MEDIAN and MODE function
Excel Magic Trick # 9: Join 2 Cells into 1
- Excel! See how to take two columns of data and join them into one column! This p
Excel Magic Trick #17: Randomly Generate Whole Numbers
- See how to use the RANDBETWEEN function to randomly generate whole numbers. See
Excel Magic Trick #16: Randomly Generate Numbers (0-1)
- See how to use the RAND() function to randomly generate numbers between 0 and 1.
Excel Magic Trick #15: SUM or COUNT Above Some Limit!
- See how to use the SUMIF and COUNTIF functions to add and count above some limit
Excel Magic Trick #14: Amazing Find & Go To Trick!
- See how to use the Find command to go to all cells with a certain formatting, or
Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions
- See how to use the SUMIF and COUNTIF functions to add and count given a certain
Excel Magic Trick #22: NORMDIST function for Probability
- See how to use the NORMDIST function to calculate probabilities for a population
Excel Magic Trick #21: BINOMDIST function for Probability
- See how to use the BINOMDIST function to calculate probabilities for a binomial
Excel Magic Trick #20: Lightening Fast Copy Trick!
- See how to use the fill handle to copy a whole table or column with formatting,
Excel Magic Trick #19: Randomly Generate Words
- See how to use the CHOOSE and RANDBETWEEN functions to randomly generate words.
Excel Magic Trick #18: Randomly Generate Letters
- See how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate lett
The Beauty Of Excel #1: Formulas & Functions
- See how to create a Contribution Margin Income Statement across various units so
Insert Magibon Mririan into Speardsheet!
- See how to insert a photo of Magibon Mririan into your Favorite Excel spreadshee
What Is Art? What is Excel?
- What Is Art? What is Excel? What do you think?
Excel Magic Trick # 2: Chart Keyboard Trick
- Excel 2007 Chart! See how when formula input data is changed the formulas in the
Excel Magic Tricks # 1: Formulas & Cell References
- See Excel Magic! See how to build your spreadsheet smartly, so it updates automa
YouTubersLoveExcel#14: NOT function for logic formulas
- See how to use the NOT function for logical formulas. See the symbols used for N
YouTubersLoveExcel#13: Date Math and IF function
- See how to calculate the Maturity Date for a loan, how to calculate a running ba
YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF
- See how to average with criteria using a Pivot Table (PivotTable), the AVERAGEIF
You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS
- See how to add with multiple criteria using a Pivot Table (PivotTable), the SUMP
The Beauty Of Excel #2: Formulas, Functions & Charts
- Also, see how to use Input areas; create formulas; use functions; use the TRANSP
Excel Lookup Series #3: VLOOKUP Function 3rd Example
- See how to Use VLOOKUP to deliver a value to a formula. See how to deliver a lat
Excel Lookup Series #2: VLOOKUP Function 2nd Example
- See how to use the VLOOKUP function to deliver a value to cell from the 3rd colu
Excel Lookup Series #1: VLOOKUP Function 1st Example
- See how to use the VLOOKUP function to deliver a value to cell:1) Find app
YouTubersLoveExcel#16: Percent Number Formatting Tricks
- See how to solve one of the biggest problems in Excel by using the Percent Numbe
YouTubersLoveExcel#15: Mixed Number formulas and Format
- See how to use Fraction Number Format to make your numbers look just how you wan
Excel Lookup Series #7: LOOKUP Function
- See how to use the LOOKUP function! We all know how to use VLOOKUP, but how do w
Excel Lookup Series #6: HLOOKUP Function
- See how to use the HLOOKUP function! We all know how to use VLOOKUP, but how do
Excel Lookup Series #5: VLOOKUP Function 5th Example
- See how to create an array in a VLOOKUP formula, and see how to have the VLOOKUP
Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example
- See 3 VLOOKUPs in 1 formula! See how to Use 3 VLOOKUPs, an IF and the IFERROR fu
Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example
- See 3 VLOOKUPs in 1 formula! See how to Use 3 VLOOKUPs, an IF and the IFERROR fu
Excel Lookup Series #12: INDEX & MATCH functions Example 2!
- See how to use the INDEX & MATCH functions together when VLOOKUP or LOOKUP w
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
- See how to use the INDEX & MATCH functions together to lookup something in
Excel Lookup Series #10: INDEX function 2nd Example
- See how to use the INDEX function to look up a value from multiple tables. See h
Excel Lookup Series #9: INDEX function 1st Example
- See how to use the INDEX function to lookup something in a table given a row pos
Excel Lookup Series #8: MATCH Function
- See how to use the MATCH function! The MATCH function looks up a value and tells
Excel Finance Trick #3: PMT function Lender or Borrower
- See how to use the PMT function for the Lender or Borrower. Cash Flows matters i
Excel Finance Trick #2: Simple & Compound Interest
- See how to use the FV function. See the math formula for calculating Future Valu
Excel Finance Trick #1: FV PV & Time Value Of Money
- FV = Future Value. PV = Present Value. Learn about the Time Value of Money. See
Excel Lookup Series #14: CHOOSE function
- See how to use the CHOOSE function to select an item from a list. This function
Excel Lookup Series #13: INDEX & MATCH functions Example 3!
- See how to use the INDEX & 3 MATCH functions in one formula to look up a val
Excel Finance Trick #8: Complete Loan Analysis
- See how to use the PMT and RATE functions for a complete Debt/Loan Analysis.
Excel Finance Trick #7: EFFECT function (EAR Rate)
- See how to use the EFFECT function to calculate the Effective Annual Rate given
Excel Finance Trick #6: RATE function and Loan Points
- See how to use the RATE function to calculate an adjusted rate when there are Lo
Excel Finance Trick #5: PMT & FV function & Delayed Payments
- See how to use the PMT & FV function together to calculate a delayed PMT pay
Excel Finance Trick #4: PMT function & Balloon payment
- See how to use the PMT function & a Balloon payment. When you have to make P
Excel Finance Trick 13: PV function Capital Invest Decision
- When an asset has an annuity cash flow pattern, you can use the PV function for
Excel Finance Trick #12: SLN & DDB Depreciation functions
- See how to use the SLN & DDB Depreciation functions. The non-cash depreciati
Excel Finance Trick 11: How Long Pay Off Credit Card Balance
- See how to calculate HOW LONG IT TAKES TO PAY OFF A CREDIT CARD BALANCE using th
Excel Finance Trick #10: Interest Rate for Pay Day Loans
- See how to calculate the Interest Rates for Pay Day Loans. See how to calculate
Excel Finance Trick 9: Daily Interest But Monthly Deposits?!
- When your savings plans pays interest 365 days in a year and you make monthly de
Excel Finance Trick #18: CUMIPMT function for Interest
- See how to use the CUMIPMT function to calculate the cumulative Interest on a lo
Excel Finance Trick #17: Amortization Table w x Column
- See how to create an Amortization Table with an Additional Payment Column. Learn
Excel Finance Trick #16: Work Life & Retirement Finance
- For only about $100,000 earn millions of dollars!! See how to use the PMT and FV
Excel Finance Trick #15: PV & NPV don't work: XNPV function
- See how to use the XNPV function for non-periodic Cash Flows. This function will
Excel Finance Trick 14: NPV function Capital Invest Decision
- You can use the NPV function when the cash flows are of different amounts but th
YouTubersLoveExcel#21: Solver for Linear Algebra
- See how to use Solver to solve for the Maximum Profit possible given the number
YouTubersLoveExcel#20: Variable Growth Cash Flow Formula
- See how to create a Variable Growth Cash Flow Formula and then how to use the NP
YouTubersLoveExcel#19: Steady Growth Cash Flow Formula
- See how to create a Steady Growth Cash Flow Formula and then how to use the NPV
YouTubersLoveExcel#18: Logical Formula to Verify Patterns
- See how to verify that a pattern you observe in data is consistent. See how to u
YouTubersLoveExcel#17: Hide Bank Rec Formula
- Use 2 SUMIF functions to create to Bank Reconciling formula. Also:1) Add C
YouTubersLoveExcel#23: Add Time with Formula or Format
- See how to add a column of times with a formula or formatting. Learn about Excel
YouTubersLoveExcel#24: Add Time by Hour, Minute or Day
- See how to use formulas to add any unit of time that you would like. Add a colum
YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart
- See how to create a dynamic range for a Pivot Table & Pivot Chart with a Rep
YouTubersLoveExcel#26: Text To Column Trouble
- After you do Text To Column, if you copy and paste move text, it will automatica
Excel
- Excel! Excel Is Fun! Excel Is Power! See a long formula that uses the IF, AND, M
YouTubersLoveExcel#30: Keyboard Shortcut Tricks.
- Learn keyboard shortcuts for Row & Column Tricks: Hide, Delete, Insert, Sele
YouTubersLoveExcel 29 Conditional Formatting & LEFT function
- Apply Conditional Formatting with the LEFT function to add color to a cell depen
YouTubersLoveExcel#27: Data Validation From Different Sheet
- See how to add Data Validation to a cell with a list from a different sheet. See
YouTubersLoveExcel#26.2: Formulas do not like TEXT Time
- See how to use avoid formula trouble with TEXT Time. The TEXT function does not
YouTubersLoveExcel#22: EOM Terms with IF, DAY & EOMONTH fun
- See how to use The IF, DAY and EOMONTH functions to calculate EOM net 10 Due Dat
YouTubersLoveExcel#31: Dates, Cash Flow & Logic
- See how to use Date Math, EOMONTH, IF & AND functions to assign contractual
YouTubersLoveExcel#32: Delete Unique Records: MATCH & ROW
- Use the MATCH & ROW functions to create a logical test to find the First Occ
YouTubersLoveExcel#33: Extract Red Cells
- See how to Sort by color in Excel 2007 and then copy and paste to extract record
YouTubersLoveExcel#34: Hide Columns Copy Problem
- See how to Hide Columns, Select Visible Cells Only, Copy and then Paste just the
YouTubersLoveExcel#28: Complex & Amazing Excel Trick
- See how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions
Excel Name Trick #5: Names for Pivot Tables & more...
- See how to use names with Pivot Tables, Data Validation & the VLOOKUP &
Excel Name Trick #4: Names & Quick Formula Creation
- See how to use short Excel Names that will allow quick formula creation. See the
Excel Name Trick #3: Names in Formulas and Functions
- See how to use Names in Formulas and Functions AND how to edit Names. See how to
Excel Name Trick #2: Names for Go To Quick Navigation
- See how to use Names cells to navigate quickly for one location to another in a
Excel Name Trick #1: Names in Excel 2003 & 2007
- Learn the basics of how to create and use an Excel Name in Excel 2003 & 2007
Excel Name Trick #12 Part 1: F2 Key and Apply Names
- See how to apply names to formulas using the built-in Apply Name Feature. See ho
Excel Name Trick #10: Store Lookup Tables in Memory
- See how to store Lookup Tables in memory using a named array. See how to use a n
Excel Name Trick #9: Create Name Formulas
- See how to create name formulas that can be then used in cells.1) Se
Excel Name Trick 8: Names Relative Cell Reference for Sheet
- See how to Name cell ranges with Relative Cell References instead of the default
Excel Name Trick #6: Names COUNTIF & wildcards
- See how to use the Names & Wildcards with the COUNTIF function. Search throu
YouTubersLoveExcel#35: IF AND vs. VLOOKUP
- See how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bi
Excel Name Trick #12 Part 3: Paste Name List
- See how to Paste a list of all Names in the Workbook, both the name and the form
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
- THE most amazing Name Trick: See how to use Data Validation, the INDIRECT functi
Excel Name Trick #11: Global Percentage Change Formula
- This relative cell reference name formula can work on any and all sheets in a wo
Excel Name Trick #12 Part 2: Names & Excel 2007 Tables
- See how to use the built in dynamic range names in Excel 2007 Tables. This is th
Excel Array Formula Series 14.4: Stock Portfolio Analysis
- See how to create array formulas for Portfolio Return & Standard Deviation.
YouTubersLoveExcel#39: Formula for Sheet Name
- See how to use the RIGHT, LEN, FIND & REPLACE functions in a formula to deli
YouTubersLoveExcel#40: Extract top 5 scores
- See how to use the Filter and Advanced Filter to extract the top 5 values from a
YouTubersLoveExcel#37: Formula Input Efficiency
- See how to create a table of formulas and labels based on formula inputs in an a
YouTubersLoveExcel#36: VLOOKUP increase based on Rating
- See how to use the VLOOKUP function to determine the increase in salary based on
Excel Array Formula Series 12: MMULT function Matrix Algebra
- See how to use the array function MMULT to multiple Matrices in Matrix Algebra.
Excel Array Formula Series #13: LINEST function
- Do Multiple Regression and Linear Algebra with the Array LINEST function. Also s
Excel Array Formula Series 14.1: Stock Returns
- See how to create array formulas for individual stock return and standard deviat
Excel Array Formula Series #14.2: Beginning Stock Analysis
- See how to create array formulas for Portfolio Return & Standard Deviation.
Excel Array Formula Series 14.3 Portfolio Standard Deviation
- See how to create array formulas for Portfolio Return & Standard Deviation.
Excel Array Formula Series #7: Boolean Logic & Criteria
- See how to create array formulas for Summing and Counting when there are multipl
Excel Array Formula Series #8: FREQUENCY function
- See how to use the Array FREQUNCY function correctly. See how to use the FREQUNC
Excel Array Formula Series #9: Count Characters in Range
- See how to create array formula that counts all the characters in a range of cel
Excel Array Formula Series #10: Amazing Syntax Array Trick
- See how to create an array constant from values in cells. This is an amazing tri
Excel Array Formula Series #11: ROW & COLUMN functions
- See how to create array formulas with the ROW & COLUMN functions in order to
Excel Array Formula Series #2: TRANSPOSE function
- See how to use the Array function TRANSPOSE to transpose a table, switching rows
Excel Array Formula Series #3: Expected Return For Stocks
- See how to create array formula that will calculate the Expected Return for Stoc
Excel Array Formula Series #4: Find Largest Improvement
- See how to create array formula for finding the largest improvement in sales fro
Excel Array Formula Series #5: SUM 3 Largest Values
- See how to create array formula for adding the 3 largest or smallest values in a
Excel Array Formula Series #6: Statistics Bayes' Theorem
- Create an array formula for Bayes' Theorem in Statistics. See the Root (Prio
Excel Tutorial - Sort Columns
- ExcelExperts.com brings you training video on: Excel Tutorial - Sort Columns
Excel Tutorial - Camera Tool
- ExcelExperts.com brings you training video on: Excel Tutorial - Camera Tool
Excel Consultancy - Fast Search
- ExcelExperts.com brings you a training video one of the Excel Consultancy servic
VBA Tutorial - Convert Text To Number
- ExcelExperts.com brings you training video on: VBA Tutorial - Convert Text To Nu
VBA Tutorial - Turn Off Autofilter
- ExcelExperts.com brings you training video on: VBA Tutorial - Turn Off Autofilte
YouTubersLoveExcel#45: SUMPRODUCT & TEXT functions
- See how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum
YouTubersLoveExcel#46: VLOOKUP & Previous Bracket Trick
- See how to use the DOLLAR, VLOOKUP, INDEX and MATCH function and a Previous Brac
YouTubersLoveExcel#47: VLOOKUP & 2 Cost Formulas
- See how to calculate total plate cost for a print shop with the VLOOKUP function
YouTubersLoveExcel#48: VLOOKUP for TIME
- See how to use VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to l
Excel Array Formula Series #1: Basics of Array Formulas
- See how to create a basic array formula. Learn about the syntax, the Ctrl + Shif
Excel Tutorial - Keyboard Shortcut To Open Excel
- ExcelExperts.com brings you training video on how to setup a Keyboard Shortcut T
Excel Tutorial - Cause Of Big Excel Files
- ExcelExperts.com brings you training video on the Cause Of Big Excel Files
Teach Yourself Excel Lesson Enter Data - Enter Data
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Enter
Teach Yourself Excel Lesson Create Hyperlinks - Create Hyperlinks
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Creat
Teach Yourself Excel Lesson Create A Chart - Create A Chart
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Creat
Excel Magic Trick #90: Consolidation
- See how to use the Consolidating feature in Excel. Summarize data from a number
YouTubersLoveExcel#41: Prevent Duplicates COUNTIF Data Valid
- See how to use a True/False formula with the COUNTIF function and Data Validati
YouTubersLoveExcel#42: Format Negative Numbers
- See how to use Conditional Formatting to add red to negative Numbers and Green t
YouTubersLoveExcel#43: Data Validation & Conditional Format
- Use Data Validation Drop-down list to change conditional formatting in a table.
YouTubersLoveExcel#44: Convert Formula Text To Number
- See how to use 4 different tricks to convert a text formula or function to a num
Teach Yourself Excel Lesson Protection - Protection
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Prote
Teach Yourself Excel Lesson Create A Pivot Table - Create A Pivot Table
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Creat
Teach Yourself Excel Lesson Filter Data - Filter Data
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Filte
Teach Yourself Excel Lesson Sort Data - Sort Data
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Sort
Teach Yourself Excel Lesson Freeze Panes - Freeze Panes
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Freez
Excel Magic Trick #95: DOLLAR function
- See how to use the DOLLAR function to convert a number to a text string formatte
Excel Magic Trick #94: VLOOKUP Into Web Query
- See how to use a currency web query, and then link it to a data validation cell
Excel Magic Trick #93: Gantt Cell Chart Conditional Formatti
- See how to use Conditional Formatting to create a Gantt Cell Chart. See how to u
Excel Magic Trick #92: Two Chart Types In One Chart!
- See how to: Add Data Series To Chart, Change the Chart Type for just one Data Se
Excel Magic Trick #91: FORECAST function
- See how to use the FORECAST function for linear algebra. Formula and
Teach Yourself Excel Lesson Inserting And Renaming Worksheets
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Inser
Teach Yourself Excel Lesson Copy And Paste Special Values
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Copy
Teach Yourself Excel Lesson Find And Replace - Find And Replace
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Find
Teach Yourself Excel Lesson Absolute References - Absolute References
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Absol
Teach Yourself Excel Lesson VLOOKUP Formula - Vlookup Formula
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson VLOOK
YouTubersLoveExcel#49: Data Forms
- See how to use a Data Form in Both Excel 2003 and 2007.See how to ad
Excel Magic Trick 99 Instead of IF function use MAX and MIN!
- See how to use the IF and the MAX and the MIN functions to solve a basic problem
Excel Magic Trick #98: Conditional Formatting for Calendar
- See how to use a TRUE/FALSE formula and the TODAY function to format a calendar
Excel Magic Trick #97: AVEDEV function
- Basic Statistics. See how to use the AVEDEV function to measure the spread (vari
Excel Magic Trick #96: EXACT function
- See how to use the EXACT function to check to see whether two text strings are e
Teach Yourself Excel Lesson Sheet Navigation - Sheet Navigation
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Sheet
Teach Yourself Excel Lesson Enter Data - Enter Data
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Enter
Teach Yourself Excel Lesson Insert A Column - Insert A Column
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Inser
Teach Yourself Excel Lesson Copy A Formula - Copy A Formula
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Copy
Teach Yourself Excel Lesson Enter A Formula - Enter A Formula
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Enter
Excel Statistics 02: Calculations, Operators, Formulas
- See how to make calculations in Excel using formulas and cell references. Learn
Excel Statistics 01: Intro To Excel 2007 for Statistics
- Introduction to Excel 2007. See the Ribbon, Office Button and the Quick Access T
YouTubersLoveExcel#52: VLOOKUP & Workbook References
- See how to add a Workbook Reference to a VLOOKUP function formula. See how to ha
YouTubersLoveExcel#51: VLOOKUP & Variable Labels
- See how to use a VLOOKUP function inside a Text Formula to add a variable word:
YouTubersLoveExcel#50: Macro & Form Button
- See how to create a basic Macro and then assign the Macro to a Form button.
Teach Yourself Excel Lesson Dates - Dates
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Dates
Teach Yourself Excel Lesson Save A File - Save A File
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Save
Teach Yourself Excel Lesson Format Data - Format Data
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Forma
Teach Yourself Excel Lesson Data Validation - Data Validation
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Data
Teach Yourself Excel Lesson Change Column Width - Change Column Width
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Chang
Excel Statistics 07: Calculate Proportions and Percentages
- See how to Calculate Proportions and Percentages for a Frequency Table. Also see
Excel Statistics 06: Don't get tricked by Number Formatting
- Don't get tricked by Number Formatting in Excel!! See how to apply Accountin
Excel Statistics 05: Cell References in Formulas
- Learn about the Formula creation time-savers: Relative and Absolute Cell Referen
Excel Statistics 04: Frequency Pivot Table Chart Basics
- See how to create a Frequency Table and Percentage Frequency Table using a Pivot
Excel Statistics 03: Data Analysis Sorting & Pivot Tables
- See two of Excel's great Data Analysis tools: Sorting and Pivot Tables (Pivo
Teach Yourself Excel Lesson Definitions - Definitions
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Defin
Teach Yourself Excel Lesson How To Open Excel - How To Open Excel
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson How T
Teach Yourself Excel Lesson Course Outline - Course Outline
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson Cours
Teach Yourself Excel Lesson 1 - Why Should I Use Excel ?
- ExcelExperts.com brings you training video on: Teach Yourself Excel Lesson 1 - W
VBA Tutorial - Compare 2 Data Sets
- ExcelExperts.com brings you training video on: VBA Tutorial - Compare 2 Data Set
YTLE#53: Excel Pivot Table and COUNTIF function
- See how to use a Pivot Table (PivotTable) and the COUNTIF function to count uniq
Excel Statistics 11: Descriptive & Inferential Statistics
- See Excel Charts for Cross-Sectional Data and Time Series data. Learn about the
Excel Statistics 10: Data & Scales/Levels of Measurement
- Learn about data sets and the Nominal, Ordinal, Interval and Ration Scales/Level
Excel Statistics 09: What Is Statistics?
- Define Statistics as Art and Science, and then See examples of Statistics in Fin
Excel Statistics 08: Install Excel 2007 Data Analysis Add-in
- See how to Install Data Analysis Add-in using Excel Options and the Add-in Featu
Excel Tutorial - Insert Alternate Blank Lines
- ExcelExperts.com brings you training video on: Excel Tutorial - Insert Alternate
Excel Tutorial - Copy Charts To Powerpoint
- ExcelExperts.com brings you training video on: Excel Tutorial - Copy Charts To P
VBA Tutorial - Merge 2 Data Sets
- ExcelExperts.com brings you training video on: VBA Tutorial - Merge 2 Data Sets
VBA Tutorial - Analyse A Workbook
- ExcelExperts.com brings you training video on: VBA Tutorial - Analyse A Workbook
VBA Tutorial - Find Out If A Cell Is Within A Range
- ExcelExperts.com brings you training video on: VBA Tutorial - Find Out If A Cell
YTLE#59: Pivot Table for Age Account Receivable
- See how to create an Aged Accounts Receivable Report using a Pivot Table PivotTa
YTLE#58: Data Validation & Excel 2007 Tables
- See how to use the Excel 2007 Table Dynamic Range for a Data Validation Drop Dow
YTLE#57: NPER function and Infinity
- See how to avoid a #NUM! error when changing the formula input numbers for the N
YTLE#55: Excel 2007 Remove Duplicates and COUNTIF function
- See how to use Excel 2007 Remove Duplicates and the COUNTIF function to count un
YTLE#54: Excel Advanced Filter and COUNTIF function
- See how to use Advanced Filter Unique Records Only and the COUNTIF function to c
VBA Tutorial - Selecting Things Demo
- ExcelExperts.com brings you training video on: VBA Tutorial - Selecting Things D
VBA Tutorial - Inputbox
- ExcelExperts.com brings you training video on: VBA Tutorial - Inputbox
VBA Tutorial - Call Code From Another Workbook
- ExcelExperts.com brings you training video on: VBA Tutorial - Call Code From Ano
Excel Tutorial - Save As Web Page
- ExcelExperts.com brings you training video on: Excel Tutorial - Save As Web Page
VBA Tutorial - Email Workbook
- ExcelExperts.com brings you training video on: VBA Tutorial - Email Workbook
YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filter
- See how to use Advanced Filter "Unique Records Only" and the VLOOKUP,
YTLE#63.5: Range of Array Formulas
- See how to create an Array Formula to find the Vendor with the Maximum Rating an
YTLE#63: Array Formula: Vendor Max Rating Min Cost
- See how to create an Array Formula to find the Vendor with the Maximum Rating an
YTLE#62: VLOOKUP INDIRECT & Lookup in Different Tables
- Totally Amazing Trick! Use the VLOOKUP and INDIRECT functions together to look u
YTLE#60: Hide Columns by Grouping
- See how to hide columns using the Grouping feature. The Grouping feature will ha
VBA Tutorial - Create An Index Page
- ExcelExperts.com brings you training video on: VBA Tutorial - Create An Index Pa
Excel Tutorial - Display All Range Names
- ExcelExperts.com brings you training video on: Excel Tutorial - Display All Rang
Excel Tutorial - List Files In Folder
- ExcelExperts.com brings you training video on: Excel Tutorial - List Files In Fo
VBA Tips - Double Click
- ExcelExperts.com brings you training video on: VBA Tips - Double Click
VBA Tips - Pause Code
- ExcelExperts.com brings you training video on: VBA Tips - Pause Code
Excel Statistics 13: Column Chart From Frequency Distribution:
- See how to create a Column Chart from a Frequency Distribution for Categorical D
Excel Statistics 12: Categorical Frequency Distribution w Formulas
- See how to use Advanced Filter 'Unique Records Only" to extract a list
YTLE#64: D Function: DAVERAGE DSUM & more
- See how to use the D functions (Database functions) such as DSUM, DAVERAGE, DMAX
YTLE#66.5: 3 ways to Hide Formula Errors
- See 3 different ways to hide formula errors. IF, IF and ISERROR, and IFERROR fun
YTLE#66: VLOOKUP replaces IF, Again!
- See how to use the VLOOKUP function in a formula to replace a huge, long IF func
VBA Tips - List Files In A Folder
- ExcelExperts.com brings you training video on: VBA Tips - List Files In A Folder
VBA Tips - Import A Text File
- ExcelExperts.com brings you training video on: VBA Tips - Import A Text File
Excel Tips - Replace The * Character
- ExcelExperts.com brings you training video on: Excel Tips - Replace The * Charac
VBA Tips - Log An Audit Trail
- ExcelExperts.com brings you training video on: VBA Tips - Log An Audit Trail
VBA Tips - Write Your Own Excel Function
- ExcelExperts.com brings you training video on: VBA Tips - Write Your Own Excel F
Excel Statistics 19: Grouping Categories w Formula & Pivot Table
- See how to group Categories in a Frequency Distribution with a Formula (2 COUNTI
Excel Statistics 18: Pareto Chart for Categorical Data See how to create
- See how to create a Pareto Chart for Categorical Data.Chapter 02 Bus
Excel Statistics 17: Categorical Cross Tabulation with Formulas
- See how to create a Cross Tabulation & Percentage Cross Tabulation for Categ
Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart
- See how to use create a Frequency Distribution, Relative Frequency Distribution,
Excel Statistics 14: Categorical Relative & Percent Freq. Dist. w Formulas
- See how to create a Relative & Percent & Frequency Distribution with For
VBA Tips - Save A Copy Of A File Daily
- ExcelExperts.com brings you training video on: VBA Tips - Save A Copy Of A File
VBA Tips - Get A File Path
- ExcelExperts.com brings you training video on: VBA Tips - Get A File Path
VBA Tips - Track Changes By Adding A Time Stamp
- ExcelExperts.com brings you training video on: VBA Tips - Track Changes By Addin
Excel Tips - Multiply Formulas By 100
- ExcelExperts.com brings you training video on: Excel Tips - Multiply Formulas By
Excel Tips - Align Shapes
- ExcelExperts.com brings you training video on: Excel Tips - Align Shapes
YTLE#67: VLOOKUP & DGET functions
- See how to pull data from a table on one worksheet to another different workshee
Excel Statistics 16: Categorical Cross Tabulation with Pivot Table
- See how to create a Cross Tabulation & Percentage Cross Tabulation for Categ
Excel Statistics 22: Histogram & Ogive Charts & % Cumulative Frequency
- See how to create a Percent Cumulative Frequency Distribution with Formulas, a H
Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas
- See how to build labels and counting formulas for a Frequency Distribution, Rela
Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas
- See how to take raw Quantitative data (numerical) and figure out how to group th
Excel Tips - Transpose Turn Rows into Columns
- ExcelExperts.com brings you training video on: Excel Tips - Transpose Turn Rows
Excel Tips - Find Broken Links
- ExcelExperts.com brings you training video on: Excel Tips - Find Broken Links
VBA Tips - Turn Off Message Boxes Whilst Running Code
- ExcelExperts.com brings you training video on: VBA Tips - Turn Off Message Boxes
VBA Tips - Enable Events
- ExcelExperts.com brings you training video on: VBA Tips - Enable Events
Excel Tips - Remove Non Numeric Characters
- ExcelExperts.com brings you training video on: Excel Tips - Remove Non Numeric C
Excel Statistics 23: Skew in Histograms
- Learn about Skew in Histograms for Quantitative Data. Skew Left (Negative), Skew
YTLE#70 PivotTable & TRIM function & AVERAGES
- See how to clean a bad data set with the TRIM function before building a Pivot T
YTLE#71: Randomize Math Problems for Kids. Excel.
- See how to create random math problems for your kids with this amazing formula.
YTLE#69: Auto Fill Options (Dates Are The Best!!)
- See how to use the Auto Fill Options for 1) Numbers, Dates, Text, Text and Numbe
YTLE#68: 3 Ways To Use Fill Handle for Copying
- 3 Amazing copy tricks using the Fill handle.
Excel Tips - Select All Text In A Cell
- ExcelExperts.com brings you training video on: Excel Tips - Select All Text In A
Excel Tips - Format Text In A Cell
- ExcelExperts.com brings you training video on: Excel Tips - Format Text In A Cel
Excel Tips - Copy Sheet To New Workbook
- ExcelExperts.com brings you training video on: Excel Tips - Copy Sheet To New Wo
Excel Tips - Add a Link To Email
- ExcelExperts.com brings you training video on: Excel Tips - Add a Link To Email
Excel Tips - Toggle The Screen Lock In Function
- ExcelExperts.com brings you training video on: Excel Tips - Toggle The Screen Lo
Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table
- See how to create Quantitative Data Cross Tabulation using a Pivot Table.
Excel Statistics 28: Stem & Leaf Chart w REPT & COUNTIF functions
- See how to create Quantitative Data Stem & Leaf Chart using the REPT and COU
Excel Statistics 27: Dot Plot Chart w REPT & COUNTIF functions
- See how to create Quantitative Data Dot Plot using the REPT and COUNTIF function
Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total)
- See how to create Quantitative Data Cumulative Frequency Distribution with Pivot
Excel Statistics 25: % Freq. Dist.& Histogram w Pivot Table
- See how to create Quantitative Data Percent & Relative Frequency Distributio
Excel Tips - Nth Largest Value In A Range
- ExcelExperts.com brings you training video on: Excel Tips - Nth Largest Value In
Excel Tips - Put Chart On A New Sheet
- ExcelExperts.com brings you training video on: Excel Tips - Put Chart On A New S
Excel Tips - Get Tick Or Cross
- ExcelExperts.com brings you training video on: Excel Tips - Get Tick Or Cross
Excel Tips - Fix Corrupt Spreadsheet
- ExcelExperts.com brings you training video on: Excel Tips - Fix Corrupt Spreadsh
Excel Tips - Why Is My Excel File So Big ?
- ExcelExperts.com brings you training video on: Excel Tips - Why Is My Excel File
YTLE#74: CLEAN & TRIM functions to fix Bad Data
- See how to fix bad data with the CLEAN & TRIM functions. TRIM gets rid of ex
YTLE#73: Custom Number Format 00000
- See how to add Custom Number Formatting in the Format Cells Dialog Box for 00001
YTLE#72: Turn Off Auto Format
- See how to Turn Off Auto Format so that column and row formatting or formulas ar
Excel Statistics 24: Quantitative Freq. Dist. w Pivot Table
- See how to create Quantitative Data Frequency Distributions with Pivot Tables. S
Excel Statistics 30: Scatter Diagram for 2 Quantitative Variables
- See how to create a Scatter Diagram for 2 quantitative variables.Cha
Excel Tips - Helpful Hints On The StatusBar
- ExcelExperts.com brings you training video on: Excel Tips - Helpful Hints On The
Excel Tips - Dynamic Charting
- ExcelExperts.com brings you training video on: Excel Tips - Dynamic Charting
VBA Tips - Find The Last Cell
- ExcelExperts.com brings you training video on: VBA Tips - Find The Last Cell
Excel Tips - Copy And Paste The Same Formula
- ExcelExperts.com brings you training video on: Excel Tips - Copy And Paste The S
Excel Tips - Use Inverted Commas In Excel Formula
- ExcelExperts.com brings you training video on: Excel Tips - Use Inverted Commas
YTLE#79: Formula for Running Total (Inventory)
- See how to create an Inventory Template with a Running Totals formula that only
YTLE#78: Conditional Format for Entire Table
- See how to create a TRUE/FALSE formula to add conditional formatting to an entir
YTLE#77: INDEX INDIRECT MATCH functions for Payroll
- See how to do a complicated Payroll formula when tax data must be retrieved from
YTLE#76: Data Analysis & INDIRECT function
- See how to use the AVERAGE and INDIRECT functions to do statistical data analysi
YTLE#75: DV Drop-Down based on DV Drop-Down
- Dependent Drop Down lists: See how to use Names, the INDIRECT function and Data
Excel Tips - Display Excel File Path
- ExcelExperts.com brings you training video on: Excel Tips - Display Excel File P
VBA Tips Update Statusbar
- ExcelExperts.com brings you training video on: VBA Tips - Update Statusbar
VBA Tips - Run Code Every Hour, Minute or Second
- ExcelExperts.com brings you training video on: VBA Tips - Run Code Every Hour, M
Excel Tips -Show Formulae
- ExcelExperts.com brings you training video on: Excel Tips - Show Formulae
Excel Tips -Freeze Panes
- ExcelExperts.com brings you training video on: Excel Tips - Freeze Panes
YTLE#84: A Few Data Validation Tricks
- See how to use Custom True/False formulas for Data Validation and how to add an
YTLE#85: Isolate Unique Records w OR function
- See how to isolate Unique Records with the OR function. Then you can Sort or Fil
YTLE#86: Pivot Table Filtering & Functions
- See how to change the function in a Pivot Table and how to filter a Pivot Table
YTLE#81: Conditional Format CHART??
- See how to add conditional formatting to a chart by creating a new column of dat
YTLE#80: Conditional Format MATCH & INSUMBER functions
- See how to highlight an entire record (row) in a database that matches a bounced
Excel Tips - Separate Text
- ExcelExperts.com brings you training video on: Excel Tips - Separate Text
Excel Tips - Remove unwanted characters
- ExcelExperts.com brings you training video on: Excel Tips - Remove unwanted char
Excel For Finance Tips - What is Yield ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
Excel For Finance Tips - What is Quantitative easing ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
Excel For Finance Tips - Will interest rates go up or down ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - Will int
YTLE#92: AVERAGE function sees Zeroes but not Blanks!
- See how the AVERAGE function sees zeroes and uses them in calculating an average
YTLE#91: PivotTable: Average w MONTH criteria
- Create an Average with multiple criteria, including month criterion using a Pivo
YTLE#90: Formula: Average w MONTH criteria
- See a complicated Average calculation with multiple criteria using the MONTH fun
YTLE#82: Enter UPPER Case Text Only Into The Cell
- See how to use the UPPER & EXACT functions to create a TRUE FALSE formula to
YTLE#83: Two Or Fewer Decimals Only Into The Cell
- See how to use the MID, FIND, REPLACE, ISNUMBER and IF functions in one BIG form
Excel For Finance Tips What is RISK ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
Excel For Finance Tips - What is Present Value ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
Excel Tips -date problem
- ExcelExperts.com brings you training video on: Excel Tips - date problem
Excel For Finance Tips - What is Leverage ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
Excel For Finance Tips - What is IRR ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
YTLE#93: "Go To Special Blanks" Caveat
- See the fastest way to use "Go To Special Blanks". But be careful of t
YTLE#89 part 2: VBA Code for Relative & Absolute Macro
- Part 2Look at the code for the Macro created in YTLE#89: Relative & Ab
YTLE#89: Relative & Absolute Macro together
- Part 1See how to take data from a cell and move it to the next record (row
YTLE#88: Macro to Remove Rows, Absolute
- See how to remove rows of a table where the row has a blank in column A using a
YTLE#87: Remove Rows w Blanks Go To Trick
- See how to quickly remove rows of a table where the row has a blank in column A.
Excel For Finance Tips Discount Factors
- ExcelExperts.com brings you training video on: Excel For Finance Tips, Discount
Excel For Finance Tips What is a Basis Point ?
- ExcelExperts.com brings you training video on: Excel For Finance Tips - What is
Excel For Finance Tips - Linear Interpolation
- ExcelExperts.com brings you training video on: Excel For Finance Tips - Linear I
Excel For Finance Tips - Future Value
- ExcelExperts.com brings you training video on: Excel For Finance Tips - Future V
Excel For Finance Tips Continuous Compounding
- ExcelExperts.com brings you training video on: Excel For Finance Tips Continuous
YTLE#97: 5 Ways To Enter Formula in Excel
- For speed in Excel, learn all 5 ways to enter a formula.
YTLE#95.2: Identifying Customers in Database
- See how to use the IF and TODAY() functions to identify customers who have not o
YTLE#96: Names, Printing, AREAS function
- See how to name multiple tables one name, how to print the named area and how to
YTLE#95: Complex Advanced Filter Extract
- See how to use the OR, AND, NOT, & COUNTIF functions to extract records from
YTLE#94: Excel's Best Keyboard Shortcut
- See how to use Ctrl + Shift + Arrow Keys (Home & End too!) to do 8 different
Excel For Finance Tips Calculate Compound Interest, Find Cheaper Loans
- ExcelExperts.com brings you training video on: Excel For Finance Tips - Calculat
VBA Tips - Time Your Code
- ExcelExperts.com brings you training video on: VBA Tips - Time Your Code
VBA Tips - ScreenUpdating - Make your code run faster
- ExcelExperts.com brings you training video on: VBA Tips - ScreenUpdating - Make
VBA Tips Reset Used Range
- ExcelExperts.com brings you training video on: VBA Tips - Reset Used Range
VBA Tips - Remove Hyperlinks
- ExcelExperts.com brings you training video on: VBA Tips - Remove Hyperlinks
YTLE#101: Custom Number & Conditional Formatting - Excel
- In Excel, see how to use Conditional Formatting AND Custom Number Formatting to
YTLE#102: Count Dates given 2 Criteria - Excel
- From a list in Excel of dates see how to count the number of days between two da
YTLE#100: Array Formula Database Customer Evaluation
- See how to create an array formula to evaluate whether customers from a transact
YTLE#99: The Number e in Excel
- See how to create the Number e in Excel. Learn about the EXP function in Excel.
YTLE#98: Excel ADDRESS function
- See how to use the ADDRESS function to make labels in templates easier for user
VBA Tips - Finding things using VBA
- ExcelExperts.com brings you training video on: VBA Tips - Finding things using V
Excel Tips - Pivot Tables for Dummies
- ExcelExperts.com - Excel Tips - Pivot Tables for Dummies
Excel Tips - Last Friday of the month
- ExcelExperts.com - Excel Tips - Last Friday of the month
Excel Tips -Remove Dupes With Multiple Columns
- ExcelExperts.com brings you training video on: Excel Tips - Remove Dupes With Mu
Excel Tips -Small Numbers in Excel
- ExcelExperts.com brings you training video on: Excel Tips - Small Numbers in Exc
YTLE#109: Daily Interest RATE Schedule in Excel
- In Excel, see how to use the RATE function to calculate the daily interest rate
YTLE#108: Excel Number of Days In Year
- In Excel, see how to use the DATE and EDATE functions to calculate the number of
YTLE#107: Excel Time Across 2 Days Trouble
- In Excel, see how to calculate the number of hours worked for the night shift wh
YTLE#106: Alternatives To Pivot Tables - Excel
- In Excel, see two alternatives to the Pivot Table: 1) Advanced Filter & SUMI
YTLE#103: Excel Goal Seek
- In Excel, see how to use Goal Seek to change a formula input number so that the
Excel Tips - Difference between 2 dates
- ExcelExperts.com brings you a training video on: Excel Tips - Difference between
maths homework graphing tool
- ExcelExperts.com brings you a training video on - maths homework graphing tool
VBA Tips - Concatenate Range
- ExcelExperts.com - Training video - Concatenate Range using a customised VBA fun
4 in a row
- ExcelExperts.com - Training video - 4 in a row... connect 4 pieces together to w
noughts and crosses
- ExcelExperts.com - Training video - noughts and crosses
YTL Excel #112: VLOOKUP Problem (Sort Ascending)
- See how to solve a common VLOOKUP problem. If the lookup table for the VLOOKUP f
YTLE#104: Find 1st Positive# in Excel List
- In Excel, see how to use a TRUE/FALSE COUNTIF formula and an Array Formula with
YTLE#105: Excel OFFSET for Dynamic Range in Function
- In Excel, use the OFFSET function to deliver a variable range of values to a fun
YTLE#111: Excel AVERAGE w Multiple Criteria
- In Excel, see how to create an AVAERAGE & IF function array formula to avera
YTLE#110: Excel Forms Scroll Bar Linked To Cell
- In Excel, see how to add a Forms Scroll Bar Linked To a Cell.
redundancy planning
- ExcelExperts.com - redundancy planning training video
madoff ponzi scheme
- ExcelExperts.com brings you training Video on: madoff ponzi scheme
VAT calculator
- ExcelExperts.com brings you training video on: VAT calculator
Excel Tips - Center Text Across Cells
- ExcelExperts.com brings you training video on: Excel Tips - Center Text Across C
stag do, hen do, event planner
- ExcelExperts.com brings you training video on: stag do, hen do, event planner
YTL Excel #117: Select Sample Data from List
- See how to use the COUNTA, ROUNDUP, RAND and IF functions to select a sample of
YTL Excel #116: Edit Recorded Macro
- See how to record a MACRO to copy data to a new location, and then edit the code
YTL Excel #115: Time Delayed Formula TODAY & IF functions
- See how to have cell content appear in your workbook after a certain number of d
YTL Excel #114: Copy Table & Name to New Workbook
- See how to copy a named table and the Name stored in memory to a new workbook. A
YTL Excel #113: VLOOKUP RIGHT 5 characters only
- See how to use the VLOOKUP and RIGHT functions to look up only the 5 right chara
Share trading system
- ExcelExperts.com brings you a training video of the Share trading system
Excel Tips -Calculate the LAST Day of the month
- ExcelExperts.com brings you training video on: Excel Tips - Calculate the LAST D
Excel Tips - Select Current Region - CTRL + A
- ExcelExperts.com brings you training video on: Excel Tips - Select Current Regio
Excel Tips -Modify Array Formula
- ExcelExperts.com brings you training video on: Excel Tips Modify Array Formula
Excel Tips -Calculate the 1st Day of the month
- ExcelExperts.com brings you training video on: Excel Tips - Calculate the 1st Da
YTL Excel #122: Advanced Filter to a New Sheet (Formula Criteria)
- See how to use Advanced Filter to extract data from one sheet to another sheet.
YTL Excel #121: CHAR & CODE & MID functions
- Learn about the ASCII characters in Excel using the CHAR, CODE and MID functions
YTL Excel #119: Amazing Lookup Solution!
- See how to use the INDIRECT and SUBSTITUTE functions to create an amazing Lookup
YTL Excel #120: Formula To Wrap Text
- See how to create a formula that will join the content of six cells and create W
YTL Excel #118: Form Controls Linked To Cells
- See how to use the Form Controls Combo Box, Check Box, Spin Button and List Box
Excel Tips - Add 2 strings together in Excel
- ExcelExperts.com brings you training video on: Excel Tips Add 2 strings together
Excel Tips Enter Array Formula
- ExcelExperts.com brings you training video on: Excel Tips Enter Array Formula
Excel Tips Function debugging using F9
- ExcelExperts.com - Excel Tips Function debugging using F9
Excel Tips - Deleting Sheets
- ExcelExperts.com brings you training video on: Excel Tips - Deleting Sheets
Excel Tips - Data Validation for percentages
- ExcelExperts.com brings you training video on: Excel Tips - Data Validation for
YTL Excel #128: Set Default Chart
- See how to set the default chart in Excel 2003 and 2007. See the keyboard shortc
YTL Excel #127: AVERAGE When Hurdle Met
- See how to create a formula that will average only when the hurdle value is surp
YTL Excel #123: Array Formula To Count E-mails
- See how to Count E-mails given two criteria using an Array Formula.
YTL Excel #125: Array Formula w IF & AVERAGE functions
- See how to create an Array Formula using the IF & AVERAGE functions to calcu
YTL Excel #124: Pivot Table Bowling Average
- See how to create a Pivot Table to calculate bowling averages that require multi
Excel Tips - Does a cell contain a string
- ExcelExperts.com brings you training video on: Excel Tips Does a cell contain a
VBA Tips - Worksheet Events
- ExcelExperts.com brings you training video on: VBA Tips - Worksheet Events
Excel Tips - Reverse a name
- ExcelExperts.com brings you training video on: Excel Tips Reverse a name
Excel Tips - Ways to Calculate in Excel
- ExcelExperts.com brings you training video on: Excel Tips Ways to Calculate in E
Excel Tips - Using the LEN function in Excel
- ExcelExperts.com brings you training video on: Excel Tips Using the LEN function
YTL Excel # 126 part 2: VLOOKUP & INDIRECT & ROW
- WATCH Part 1 First!!!!!!VLOOKUP, INDIRECT, ROW, and IF functions.
YTL Excel # 126 part 3: Conditional Formatting w Formulas
- Watch Part 1 and 2 First!!!!! Conditional Formatting with Formulas.
YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functions
- See how to retrieve values from more than one table. See how to populate a templ
YTL Excel #130: Income Statement from Excel Table: Array For
- See how to create a small business Income Statement from an Excel Table using an
YTL Excel #129: Zip Code, VLOOKUP & TEXT functions
- See how to use the TEXT and VLOOKUP functions to retrieve Zip Codes with leading
Excel Tips - Capture Screen Shot of your Excel
- ExcelExperts.com brings you training video on: Excel Tips Capture Screen Shot of
Excel Tips - Launch Excel using the keyboard
- ExcelExperts.com brings you training video on: Excel Tips Launch Excel using the
Excel Tips - Toggle Date Format
- ExcelExperts.com brings you training video on: Excel Tips Toggle Date Format
Excel Tips - Copy Down
- ExcelExperts.com brings you training video on: Excel Tips Copy Down
Excel Tips - Worried about security? open Excel Safely
- ExcelExperts.com brings you training video on: Excel Tips - Worried about securi
Video For Carly: Chemestry 2 X Y Scatter Diagrams 1 Chart
- X Y Scatter Diagram and Trend Line for two data sets on one chart.
Excel Magic Trick #105: Extract Records Trick
- See how to Extract Records from one column that are not in another column using
Excel Magic Trick #106: Gantt Chart for Daily Schedule
- See how to use Conditional Formatting, the AND function, and cell references to
Excel Magic Trick #102: Conditional Formatting Duplicates
- See how to add formatting to duplicate records using a TRUE FALSE COUNTIF formul
Excel Magic Trick #101: IS Functions
- IS Functions. See how to use the following functions:ISBLANK functio
Excel Tips - How many times does a letter appear in a cell ?
- ExcelExperts.com brings you training video on: Excel Tips - How many times does
Excel Tips - Get Initials from a Name
- ExcelExperts.com brings you training video on: Excel Tips - Get Initials from a
Excel Tips - Introduction to Pivot tables
- ExcelExperts.com brings you training video on: Excel Tips - Introduction to Pivo
Excel Tips - Moving Averages
- ExcelExperts.com brings you training video on: Excel Tips Moving Averages
Excel Tips - Using Go To
- ExcelExperts.com brings you training video on: Excel Tips Using Go To
Excel Magic Trick #110: Partial Text Conditional Formatting
- See how to use the MID, SEARCH, FIND and LEN functions in a TRUE FALSE formula f
Excel Magic Trick #108: Exchange Rate Table From Web Query
- See how to do a Currency Web Query, the CHAR function and concatenation to creat
Excel Magic Trick #107: Array Formula For Monthly Sales
- See how to create an array formula to calculate monthly sales from a large set o
Excel Magic Trick #104: National Debt Web Query
- See how to run a web query to calculate the national debt that is incurred each
Excel Magic Trick #103: Pie Chart For Student Scores
- See how to use Advanced Filter Unique Records Only, COUNTIF function, Percent Fo
Excel Tips Create Range names quickly
- ExcelExperts.com brings you training video on: Excel Tips - Create Range names q
Excel Tips View, Edit and Delete range names well done XL 2007
- ExcelExperts.com brings you training video on: Excel Tips View, Edit and Delete
Excel Tips - Calculating proportions with COUNTIF
- ExcelExperts.com brings you training video on: Excel Tips - Calculating proport
Excel Tips - Easily change the print area
- ExcelExperts.com brings you training video on: Excel Tips - Easily change the pr
Excel Tips - Find and Replace across the whole workbook
- ExcelExperts.com brings you training video on: Excel Tips - Find and Replace acr
Excel Magic Trick #115: Find 2nd Positive Number
- See how to Find 2nd Positive Number using the COUNTIF & AND functions in one
Excel Magic Trick #114: GetPivotData ISERROR and IF function
- See how to use the GetPivotTableData function, as well as the ISERROR and IF fun
Excel Magic Trick #113: Nested IF & Short Term Loans
- Nested IF example. See how to use the TEXT function, concatenation using the Amp
Excel Magic Trick #112: Add Cumulatively
- See how to create a formula that adds cumulatively and a formula that calculates
Excel Magic Trick #111: Build A Questionnaire
- See how to put the IF function inside a VLOOKUP function, add Data Validation, u
Excel Tips - Data Validation
- ExcelExperts.com brings you training video on: Excel Tips - Data Validation
Excel Tips - Conditional formatting
- ExcelExperts.com brings you training video on: Excel Tips - Conditional formatti
Excel Tips - Paste values
- ExcelExperts.com brings you training video on: Excel Tips - Paste values
Excel Tips - Inserting rows and columns
- ExcelExperts.com brings you training video on: Excel Tips Inserting rows and col
Excel Tips - Remove Duplicates from a sorted list
- ExcelExperts.com brings you training video on: Excel Tips - Remove Duplicates fr
Excel Magic Trick #121: Count With More Than 1 Criteria Condition
- See how to Count With More Than 1 Criteria with four different formulas and func
Excel Magic Trick #120: ISNUMBER & SEARCH functions
- See how to add conditional formatting to a text string that contains some specif
Excel Magic Trick #116: Find Best Poker Game
- See how to find the Best Poker Game Results from a list using the MAX, INDEX and
Excel Magic Trick #117: Reverse 2-Way Lookup Part 1
- Really Hard formula!!! See the functions, IF, INDEX, MATCH, SMALL, ROW, ROWS, CO
Excel Magic Trick #118: Reverse 2-Way Lookup Part 2
- Watch Part 1 first. This Part 2 gets very complicated, but it is quite cool: See
Excel Tips Tell The Time in Excel
- ExcelExperts.com brings you training video on: Excel Tips - Tell The Time in Exc
Excel Tips - Find the last cell for non contiguous range
- ExcelExperts.com brings you training video on: Excel Tips - Find the last cell f
Excel Tips Useful Excel shortcuts
- ExcelExperts.com brings you training video on: Excel Tips - Useful Excel shortcu
Excel Tips index match
- ExcelExperts.com brings you training video on: Excel Tips - VLOOKUP limitations
Excel Tips Function to return the worksheet name
- ExcelExperts.com - Excel Tips Function to return the worksheet name
Excel Magic Trick #126: Macro: Advanced Filter Extract Text
- See how to create a macro that will do an Advanced Filter Movie Title Extract fo
Excel Magic Trick #125: Charting functions of X in Excel
- See how to chart functions of X in Excel. See how to create the Number e in Exce
Excel Magic Trick #124: Box Plot or Box & Whisker
- See how to create a Box Plot or Box & Whisker Statistics chart using a Stack
Excel Magic Trick #123: Date Data Validation
- See how to add data validation for dates. See how to create a table with Date Da
Excel Magic Trick #122: Sum With More Than 1 Criteria
- See how to Sum With More Than 1 Criteria with four different formulas and functi
Excel Tips Using the TODAY function
- ExcelExperts.com - Excel Tips Using the TODAY function.. a major cause of sluggi
Excel Tips Date formatting Show the day of the week
- ExcelExperts.com - Excel Tips - Date formatting Show the day of the week
Excel Tips Hiding sheets secret trick
- ExcelExperts.com - Excel Tips Hiding sheets secret trick
Excel Tips - Wrap Text for headings
- ExcelExperts.com - Excel Tips - Wrap Text for headings
Excel Tips IRR internal rate of return
- ExcelExperts.com - Excel Tips IRR internal rate of return
Excel Magic Trick #132: Borders For an Accounting Template
- See how to apply Borders in the Format Cells dialog box when Builing an Accounti
Excel Magic Trick #130: 3 Dimensional Database in Excel
- See how to use the Table and List feature with data Validation to create a 3-dem
Excel Magic Trick #129: More than 7 Nested IF functions
- See what to do if you must have more than 7 nested IF functions: 1) Use the Ampe
Excel Magic Trick #128: VLOOKUP Categories
- See when to use IF and when to use VLOOKUP depending on your category setup. See
Excel Magic Trick #127: Count Less Than 70% of Max
- See how to create two different formulas for counting items that are less than 7
Excel Tips - VLOOKUP
- ExcelExperts.com - Excel Tips - VLOOKUP
Excel Tips RANDBETWEEN
- ExcelExperts.com - Excel Tips RANDBETWEEN
Excel Tips - Change values on multiple sheets
- ExcelExperts.com brings you training video on: Excel Tips - Change values on mul
Excel Tips Get file path with an excel formula
- ExcelExperts.com - Excel Tips Get file path with an excel formula
Excel Tips Create all the days of the week in 5 seconds
- ExcelExperts.com brings you a training video on how to Create all the days of th
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH
- See how to do Two 2 way lookup with VLOOKUP & MATCH functions. Two way looku
Excel Magic Trick #135: Find Last Row & Column Dynamic Range
- Create a dynamic range when there are blanks in the data set. Use an array formu
Excel Magic Trick #134: Find Last Value In List
- See how to Find the Last Value in a list using three different formulas: See the
Excel Magic Trick #133: Import CSV Data (Comma Separated Values - Data)
- See how to import files with the extension .csv. See how to use the Text Import
Excel Magic Trick #131: Ranking w MIN IF OFFSET
- See the functions COUNTIF, MIN, IF, OFFSET, VLOOKUP functions formula used in a
Excel Tips Debugging large Excel Function calls
- Training Video from ExcelExperts.com - Excel Tips - Debugging large Excel Functi
Excel Tips - Display function arguments
- Training Video from ExcelExperts.com - Excel Tips - Display function arguments
VBA lesson 5 what does my recorded code mean
- VBA Training Video from ExcelExperts.com - what does my recorded code mean ?
Excel Tips Autofit selection
- Training video from ExcelExperts.com - Excel Tips - Autofit selection
Excel Tips Easily paste special values Hidden Menu
- Training Video from ExcelExperts.com from the Excel Tips section - Easily paste
Excel Magic Trick #141 part 1: Day Numbers to Dates
- See how to take the number 1 (for day one of the month) and use the DATE functio
Excel Magic Trick #140: Sheet Cell References in Formulas
- See how to save time in updating a system of data and information by using Sheet
Excel Magic Trick #139: HYPERLINK function & Drop Down List
- See how to use Data Validation List Drop-down and the hyperlink function to crea
Excel Magic Trick #138: Names Cell If Name in Cell
- See how to name individual cells a name that is the cell content (the name of th
Excel Magic Trick #137: Array Syntax for USA & Norway
- See how to figure out what array syntax you need to use when your computer is se
Excel tips create numbers 1 to 10
- ExcelExperts.com training Video on Excel tips demonstrates how to create numbers
VBA lesson 4 Record Macro
- VBA training Video from ExcelExperts.com on how to Record a Macro
VBA lesson 3 Subs and Functions
- ExcelExperts.com brings you a VBA training session explaining Subs and Functions
Expense tracker training video
- This training video from ExcelExperts.com teaches you how to use the Expense Tra
VBA lesson 2 for loops
- ExcelExperts.com brings you VBA lessons. This one is lesson number 2 on FOR loop
Excel MT 144 p1 Formula: Avoid Data Validation 1 Rule Limit
- See how to work around Data Validations one rule limit by creating a second shri
Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit
- See how to work around Data Validations one rule limit by getting VBA code to pr
Excel MT142 p2: Array Formula for Counting Dates
- See how to create a complex array formula that counts weekends between two dates
Excel MT142 p1: Custom Number Format & Conditional Formatting for Dates & Weekends
- See how to apply Custom Number Formatting and how to add conditional formatting
Excel Magic Trick #141 part 2: Series of Dates
- See how to generate a series of dates with the TODAY and ROW function that will
VBA training - create button
- ExcelExperts.com brings you this VBA training video on how to create a button in
Excel Training - paste as hyperlink
- ExcelExperts.com teaches you how to paste as a hyperlink.
sell or rent out calculator
- ExcelExperts.com brings you training video on: sell or rent out calculator
Buy or Rent advanced Training
- An advanced training session on the Buy or Rent Calculator from ExcelExperts.com
facebook texas holdem poker training video
- Facebook texas holdem poker training video from ExcelExperts.com
Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF
- Create a formula that will calculate the standard deviation when you have more t
Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel
- AVERAGEIF or AVERAGE IF, for Excel 2003, 2002, 2000, 1998, 1997 see how to creat
Excel Magic Trick #145 p2 MODE IF
- See how to create a formula that will calculate the mode when you have more than
Excel Magic Trick #145 p1 MEDIAN IF
- See how to create a formula that will calculate the median when you have more th
Excel MT 144 p2 Formula: Avoid Data Validations 1 Rule Limit
- See how to work around Data Validations one rule limit by creating a second shri
RSS feed
- Training video on how to get an live updates from ExcelExperts.com via an RSS fe
Question and Answer tutorial
- Video explaining how to add Excel Questions to ExcelExperts.com
Buy, Do Up and Sell Calculator
- ExcelExperts.com brings you training video on: Buy, Do Up and Sell Calculator
How Much Can I Spend On A House ? Calculator
- ExcelExperts.com brings you a training video on: How Much Can I Spend On A House
Buy Or Rent Worked Example
- Worked example of Buy or Rent calculator from ExcelExperts.com
Excel Magic Trick #148: Dynamic List from Table #3
- See how to how to extract records from non-standard table and put a record in a
Excel Magic Trick #147: Dynamic List from Table #2
- See how to how to extract records from standard table and put a record in a colu
Excel Magic Trick #146 part 2: Dynamic List from Table #1
- See how to how to extract records from table and put 1 record on each sheet with
Excel Magic Trick # 146 part 1: Dynamic List from Table #1
- See how to how to extract records from table and put 1 record on each sheet with
Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates
- This video is in response to the video: Excel Magic Trick #118: Reverse 2-Way Lo
Buy Or Rent Introduction
- An introduction to the Buy or Rent Calculator on ExcelExperts.com
Buy Or Rent Introduction
- An introduction to the Buy Or Rent calculator from ExcelExperts.com
Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates
- See how to take a value in a table and then return the row or column value when
Excel Magic Trick #151: DATEDIF function (between two dates)
- Calculate the days, months or years between two dates. See how to use the undocu
Excel Magic Trick #152: Extract records w Field Not Blank
- See how to use the advanced filter and a TRUE FALSE formula in a column to extra
Excel Magic Trick #153: Conditional Formatting for Incentive
- See how to apply conditional formatting to the MAX value in a set of three incen
Excel Magic Trick #154: Personal Budgets and VLOOKUP
- See how to create a personal budget based on past data, contract numbers, the SU
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria
- VLOOKUP & OFFSET function Amazing Trick! See what to do if we have VLOOKUP w
Excel Magic Trick 157 Conditional Format Part of Table
- See how to highlight just part of a table using both Conditional Formatting and
Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists
- This formula will check two tables and find the values that do not match and the
Excel Magic Trick # 155: VLOOKUP & TRIM function
- When the VLOOKUP function should work and it does not, try the TRIM function to
Excel Magic Trick #150 Formatting Guidelines (Eye Candy)
- Format Formatting Spreadsheets. Learn how to apply formatting efficiently and wi
Excel Magic Trick 163 Formula Return Descending Sorted List
- Using an array formula, return a descending sorted list of country names based o
Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria
- See how to how to extract the 10 largest values based on three criteria and then
Excel Magic Trick # 161: Go To Tricks Complete Story
- See how to highlight all occurrences of an item or Excel element and then change
Excel Magic Trick # 160: Find & Replace Format or Formula
- Find all the occurrences of a word, number, format or formula and then change or
Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column
- Solve Duplicate VLOOKUP function problem with COUNTIF formula that creates a col
Excel Magic Trick 167p2 IF function formula: 12 Examples!
- Part 2. See 12 different examples of how to use the IF function. This video star
Excel Magic Trick # 166: CONCATENATE function & Ampersand
- Advantages and disadvantages of the Ampersand symbol and the CONCATENATE functio
Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days
- Part 2 shows the MACRO and Advanced Filter and the Forms button.See the IN
Excel Magic Trick 165p1 MACRO Advanced Filter Extract B-days
- Part 1 Shows TRUE FALSE formula for a Series of Dates using the ROW and INDIRECT
Excel Magic Trick # 164: CEILING function in Price Formula
- See how to how to use the IF and CEILING functions in one formula to calculate t
Excel Basics #20: Data Analysis Pivot Tables PivotTables
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #21: Data Analysis Filter &Dynamic Ranges
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #22: IF function formula made easy!
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #23: VLOOKUP function formula
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Magic Trick 167p1 IF function formula: 12 Examples!
- Part 1. See 12 different examples of how to use the IF function. This video star
Excel Basics #15: Date & Time Format & Calculations
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #16: Chart Basics - Excel Charts
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #17: Page Setup
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #18: Data Analysis Sort
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #19: Data Analysis Subtotals
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #10: Formulas: Copy Vs. Cut
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #11: Spreadsheet Setup & Cell References
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #12: Stylistic & Number Formatting
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #13: Percentage Number Format
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #14: ROUND function & Number Formatting
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #5: Formulas Operators and Math
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #6: Names Cell Ranges and Functions
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #7: Range Functions
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #8: Cell References Relative & Absolute
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #9: Mixed Cell References in Formulas
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Magic Trick #168: Cross Tabulation For a Survey
- See how to summarize survey results with a Pivot Table (PivotTable) or a Formula
Excel Basics #1: What Is Excel?
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #2: Keyboard Shortcuts
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #3: Formulas w Cell References
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Basics #4: Formulas and Functions
- The Excel Basics Series shows a systematic description of what Excel can do from
Excel Magic Trick #174: Smartest Excel People In The World
- See an incredible Excel Trick From Aladin at the Mr Excel Message Board. See how
Excel Magic Trick #172: Running Total Formula or Pivot Table
- See how to create a Running Total with a Formula or a Pivot Table.For form
Excel Magic Trick #171: MACRO Data Validation from 3 lists
- Create a MACRO using Relative and Absolute cell references in order to create a
Excel Magic Trick #170: Conditional Format To Hide Items
- See how to use conditional format to hide or show items in a list using a TRUE F
Excel Magic Trick #169: Randomly Select Employee From List
- See how to randomly select employee from list using the INDEX and RAND and INT f
Excel Magic Trick #177: Data Validation Trouble
- See how to format a column with the Text Number Format to avoid Data Validation
Excel Magic Trick #182: Workbook References
- See how to create formulas with workbook references. See how to make a formula t
Excel Magic Trick #176 Get Last Item in Column on Diff Sheet
- See how to get the last number or word from a column on a different sheet. See h
Excel Magic Trick #175: Count Between Upper & Lower Value
- See how to use the SUMPRODUCT function and an array of TRUE & FALSE to count
Excel Magic Trick #173: Time Over or Under (Negative Time)
- See how to show Negative time with the "Use 1904 date system". See how
Excel Magic Trick #184: Setup Database in Excel
- See how to create a simple database in Excel using the List or Table feature.
Excel Magic Trick #183: Income Statement by Year & Month
- See how to sum revenue from a table of data by year and month using the SUMPRODU
Excel Magic Trick #181: Count Words Case Sensitive
- See how to Count Words Case Sensitive using the SUM and EXACT functions in an ar
Excel Magic Trick #179: Are All Four Word The Same?
- Determine whether four words in four cells are exactly the same (case sensitive)
Excel Magic Trick #178: Best Value Per 1 Unit Of Stats Value
- Excel Magic Trick #178: Best Value Per 1 Unit Of Stats Value.See how to ca
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
- This formula will extract records that meet two conditions (criteria) and list t
Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter
- Macro and Advanced Filter. See how to use Advanced Filter to extract records fro
Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria
- Create a formula to extract part of a table from a larger table. Similar to a qu
YTLE#56: Excel Count Unique Values Greater Than $30
- See SUMPRODUCT and COUNTIF together in one amazing Array Formula from Aladin at
Excel Magic Trick #180: COUNTIF function formula 21 Examples
- See methods for counting: specific words, specific numbers, numbers greater than
Excel Magic Trick #190: Rearrange First Last Name w Formula
- See how to rearrange three parts in a text string (Last, First, Middle name) usi
Excel Magic Trick #189: Count Days Not Sunday
- From a start date and an end date, see how to count all the days except for Sund
Excel Magic Trick #188: Page Setup Across Multiple Sheets
- Page Set Up Across Multiple Sheets Or To Another Workbook. Headers and Footers.
Excel Magic Trick #187: Unique List w Dynamic Formula
- Create a unique list of items for a large list that contains duplicates with 2 a
Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria
- See how to use Advanced Filter to extract records from a table with 2 criteria.
Excel Magic Trick #195: Grade Book That Subtracts Lowest Score
- Use the SUM, MIN and VLOOKUP functions to create a Grade Book Based on Total Sco
Excel Magic Trick #194: Grade Book Based on Percentages
- Use the SUM, VLOOKUP and ROUND functions to create a Grade Book Based on Percent
Excel Magic Trick #191: Extract Middle Name Formula
- See how to extract part of a text string (middle name in quotes) from Last, Midd
Excel Magic Trick #193: Grade Book Based on Total Score
- Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score th
Excel Magic Trick #192: Extract Middle Name Text To Column
- See how to extract the middle name in quotes from a cell that has last, middle a
Excel Magic Trick #200: 2007 Table Formula Nomenclature
- See how to use the new Excel 2007 Table Nomenclature in formulas. See 9 examples
Excel Magic Trick #199: Histogram w Conditional Formatting
- See how to use the New Excel 2007 Conditional Formatting for a Vertical Histogra
Excel Magic Trick #198: 3 Formulas For Frequency Distribution
- Excelisfun is conducting a FAVORITE FORMULA SURVEY! Watch the 3 different Formul
Excel Magic Trick #197: Grade Book with Weights
- Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score an
Excel Magic Trick #196: Grade Book That Subtracts Two Lowest
- Use the SUM, SMALL and VLOOKUP functions to create a Grade Book Based on Total S
Excel Magic Trick #210: Formula Not Calculating Stuck
- If your formula does not calculate and is showing the equal sign and the rest of
Excel Magic Trick #203: SUMIF function formula 21 Examples
- See methods for summing with criteria: specific words, specific numbers, numbers
Excel Magic Trick #204: Adding w Case Sensitive Criteria
- See how to use the SUMPRODUCT and EXACT functions in an array formula to add the
Excel Magic Trick #202: Calculate Vacation Days
- Create a formula that calculates the number of vacation days an employee gets ba
Excel Magic Trick #201: Custom Number Format For Pro ID
- See how to use a Custom Number Format (Format Cells Dialog box) to add part of a
Excel Magic Trick #204: Scatter & Bar Chart Together
- See how to add the Mean Value as a Scatter diagram Data Series to a Box Plot or
Excel Magic Trick #206: Artists Commissions & VLOOKUP
- See how to calculate Commissions with the VLOOKUP function when the Lookup value
Excel Magic Trick #207: Business Math Word Problem Setup
- See how to setup and solve a business math word problem in Excel. See 3 (three)
Excel Magic Trick #208 Ctrl + Enter 6 Examples Of Efficiency
- See how to use the keyboard shortcut Ctrl + Enter to gain efficiencies when crea
Excel Magic Trick #209: Formula Or Function Confusion
- Learn about the differences and similarities between a formula and a function! S
Excel Magic Trick #212: Filter Copy Paste Data Extract
- See how to Extract records from an Excel Database / Table / List with a Filter a
Excel Magic Trick #211: Advanced Filter Extract ID Variable
- See how to extract records from an Excel Database / List / Table when the first
Bill Mr Excel Jelen is Here At YouTube
- Bill Mr Excel Jelen is here at YouTube. This is a great Excel Resource.
Excel Magic Trick #205: Get C21 Values From Across Sheets
- Amazing Trick with INDIRECT function! See how to get the values from all the C21
Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function
- See how to create sequential numbers in formulas using the ROWS function. See t
Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1
- See how to use an Excel 2007 Table to create a Dynamic Range so a Macro to Creat
Excel Magic Trick #215: Dynamic Print Range
- See how to create a named formula with OFFSET & COUNTIF functions that defin
Excel Magic Trick 216 Pivot Table 4 Variable Cross Tabulatio
- See how to create a Pivot Table with 4 variable Cross Tabulation. 4 Fields in a
Excel Magic Trick #217: IF Function Text Logical Test
- See how to create a simple If function formula that uses a logical test that inv
Excel Magic Trick #213: Dynamic Data Extract w Formula
- See how to create a non-array formula to extract data dynamically with two formu
Excel Magic Trick #223 Count Single Character In Text String
- How many "X"s are ther in that word? See how to count individual lette
Excel Magic Trick #222: Find and Count Longest Word / Text
- See how to Find and Count Longest and Shortest word / test string. MAX, MIN and
Excel Magic Trick #221: LEN function Counts Spaces
- See how to use the LEN function to count charters including spaces. Then see how
Excel Magic Trick #220: Count Dates In Each Month
- From a List of dates, see how to create a formula with the SUMPRODUCT and EOMONT
Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2
- See how to create a Dynamic Range with the OFFSET function so a Macro to Create
Excel Magic Trick #228: Text Formula & Forced Wrap Text
- Amazing Text Formula Trick. See how to use the CHAR (10) function to add hard li
Excel Magic Trick #229: Dump Data Pivot Table Macro
- This video is in response to Excel Magic Trick #219: Pivot Table Macro w Dynamic
Excel Magic Trick #226: Apply Names To Formulas
- See how to Apply Names to Formulas and replace existing cell ranges. See How To
Excel Magic Trick #225: 2 Way Lookup With Duplicates
- See how to do a Two Variable Lookup When There are duplicates. See the INDEX, IF
Excel Magic Trick #224: Extract Prefix From Product ID
- See how to extract prefix from product id when there is no dash or space to esta
Excel Magic Trick #233: 2 Business Math Tricks
- See how to create an efficient Checkbook Balance Formula and see when to use ROU
Igor's Physics Class Linear Regression Tricks
- Linear RegressionX-Y Scatter Diagram Chart GraphX Y Scatter diagram
Excel Magic Trick #232: Add w 3 Criteria OR 2 Criteria
- Amazing Array Formula that allows 3 or 2 criteria into an array formula based on
Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets
- See how use VLOOKUP when there are 3 tables on 3 different sheets. See how to us
Excel Magic Trick #230: Dynamic Stock Chart Excel Table List
- See how to use the Excel List Table feature to make a dynamic Stock Price Line C
Excel Magic Trick #238: Round Times To 5 Minutes
- See how to round times to 5 minutes using the CEILING and MROUND functions.
Excel Magic Trick #237: ROUND to Digit or Multiple
- Learn how to use the functions MROUND, CEILING, FLOOR, ROUND, ROUNDUP, ROUNDDOWN
Excel Magic Trick #236: Excel For Home Improvement
- See how to create a database for keeping carpentry measurements, then see Advanc
Excel Magic Trick #235: Custom Number Format for Inches
- See how to create a custom number format for inches that will allow you to type
Excel Magic Trick #234: Trig functions PI RADIANS DEGREES
- See how to convert Degrees to Radians with functions and formulas. See how to co
Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)
- See how to use Advanced Filter to extract records from a Database (Table or List
Excel Magic Trick #242: Excel Sudoku Puzzle
- See how to create a Sudoku Puzzle using array formulas, INDEX function with crit
Excel Magic Trick #243: MEAN MEDIAN MODE STDEV Histogram
- See how to calculate and interpret Mean Median Mode Standard Deviation in Excel
Excel Magic Trick #240: Dynamic Range New Data At Top
- OFFSET function. See how to create a dynamic range with the OFFSET function and
Excel Magic Trick #239: Graphing Functions of X Scatter Diag
- See how to create a chart for a linear function of X in Excel. Learn about a tex
Excel Busn Math 05: Functions & Formulas
- See how to use the built-in Excel functions: SUM, AVERAGE, PRODUCT, LCM, QUOTIEN
Excel Busn Math 06: Relative & Absolute Cell References
- Learn About the importance of Cell References in Excel formulas and functions. L
Excel Busn Math 07: When ROUND function Is Required
- See when to use the ROUND function for Math Calculations:1)You are multipl
Excel Magic Trick #241: Data Validation w Shrinking List
- See how to create Data Validation Drop Down Cell List where the List shrinks as
Excel Magic Trick #245: Matching 2 Lists w IF & OR functions
- Check to see if values in one list are in another list with the IF and OR functi
Excel Magic Trick 250 Pivot Table Unique List in Unique List
- See how to create a Unique List of Customers within a Unique List of Sales Reps
Excel Busn Math 01: What is Excel?
- What is Excel? Learn some Excel basis:1) What a spreadsheet Excel workbook
Excel Busn Math 02: Formulas and Math Operators
- See how to create Math formulas in Excel using Addition, Subtraction, Multiplica
Excel Busn Math 03: Math Order Of Operations
- See how to create Math formulas in Excel and how the Math Order Of Operations af
Excel Busn Math 04: The Importance Of Formatting In Math
- Learn about formatting in Excel and how it affects Math Calculations. See Curren
Excel Busn Math 15: Large Math Word Problem
- See how to set up and solve and write conclusions for Math Word Problems In Exce
Excel Magic Trick #246: Waterfall Profit Chart
- See how to create a Waterfall Profit Chart using a Stacked Column Chart, some fo
Excel Magic Trick 251 Formula Unique List within Unique List
- See how to create a Unique List of Customers within a Unique List of Sales Reps
Excel Magic Trick #248: PERCENTILE QUARTILE functions Decile
- See how to use the PERCENTILE and QUARTILE functions to calculate percentiles, q
Excel Magic Trick #249: Data Extract To New Workbook
- See how to use Advanced Filter to extract records from a database Excel Table /
Excel Busn Math 09: ROUNDING Numbers In Excel
- Learn about when you must use the ROUND function in Excel. Round to the penny, R
Excel Busn Math 10: Adding and Subtracting
- See that the SUM function works better the just using the Plus Symbol. See why y
Excel Busn Math 12: Multiplying & Dividing In Excel
- See how to Multiply and Diving whole numbers and Decimals in Excel. See some tri
Excel Busn Math 13: Math Word Problems #1
- See how to set up and solve and write conclusions for Math Word Problems In Exce
Excel Busn Math 14: Math Word Problems #2
- See how to set up and solve and write conclusions for Math Word Problems In Exce
Excel Magic Trick # 256: 162 Excel Keyboard Shortcuts
- See how to do 162 Excel Keyboard Shortcuts (Not really, I just give you a list a
Excel Magic Trick 255: Data Table 2 Variable What If Analysis
- See how to create a 2 Two Variable Data Table in Excel (What If Analysis). See t
Excel Magic Trick 253: Data Table 1 Variable What If Analysis
- See how to use a Data Table for 1 variable for what if analysis. See the PMT fun
Excel Magic Trick # 252: Text Cell Range In A Function
- See how to use a cell range typed into a cell in a function. If I was counting t
Excel Busn Math 08: Whole, Decimal Numbers & Formatting
- Learn about Whole and Decimal Numbers. See how to write words to represent numbe
Excel Magic Trick # 259: Dynamic DV List Based On DV List
- See how to create a dynamic data validation drop down list based on another dyna
Excel Busn Math 11: Order Of Operations For Math
- Learn about the order of operations for Math and For Excel. See examples with Fo
Excel Magic Trick # 260: Delete All Invoices w TBO
- Delete All Invoice Records That Contain an ID with "TBO" using the SEA
Excel Magic Trick # 258: Chart From Noncontiguous Data
- When Making Charts, The data series do not have to be next to each other, and th
Excel Magic Trick 257 Convert Dates as Text to Dates As No.
- Dates As text will cause problems in a Pivot Table (PivotTable). See how to conv
Excel Magic Trick 261: Random Num 1- 100 Not Divisible By 3
- See how to create random numbers between 1 and 100 that are not divisible by 3 w
Excel Magic Trick # 262: Dynamic Weekly Chart
- See how to create a Weekly Chart that can show data from any week in a large dat
Excel Magic Trick # 263: Math Function of X & Dynamic Charts
- See how to create a completely dynamic Math Equation System (Function of X) with
Excel Magic Trick # 264: Absolute & Relative Macro Fix Data
- Learn How To Use A Macro With Relative and Absolute References to Deal With Data
Excel Magic Trick # 254: Data Table Creates 100 Formulas
- See how to create a Contribution Margin Income Statement Analysis across various
Excel Formula Efficiency 10: Automatic & Manual Calculation
- See how to use Manual Calculation for huge spreadsheets so that recalculation on
Excel Formula Efficiency 11: Pivot Table Faster Than Formula
- See how creating a Pivot Table is faster than using Formulas. For multi-conditio
Excel Formula Efficiency 12: Fastest Formula In Excel
- See why you must go out and buy Excel 2007. See a comparison amongst six (6) mul
Excel Magic Trick # 266: Count Words Only w COUNTIF ?*
- See that COUNT and COUNTA have trouble counting only words or text. Learn how th
Excel Magic Trick # 267: Percentage Change Formula & Chart
- Learn about the universal formula for Percentage Change: (End Value)/Beg Value)
Excel Formula Efficiency 5: Helper Cell Speed Up Calculation
- See how to use a Helper Cell to remove a time consuming (expensive) section of y
Excel Formula Efficiency 6: Concatenated Field Speeds Up Formula
- See how a Helper Column with Concatenated Fields can dramatically reduce the tim
Excel Formula Efficiency 7: Helper Column Speeds Calculation
- Count Unique Records with Formulas / Formula. See how to use a Helper Column to
Excel Formula Efficiency 8: Custom VBA Function Can Be Fast
- See how a custom Function (User Defined Function) can speed up calculations. See
Excel Formula Efficiency 9: Faster Running Total Formula
- See two Running Total formulas, one that is faster than the other. SUM function
Excel Busn Math 21: Fraction Word Problem
- Learn about:1)Formatting Fractions as Decimals up to 15 digits2)Divi
Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples
- Learn about the basics of SUMPRODUCT function and why some people use double neg
Excel Formula Efficiency 2: Time Your Formulas For Speed
- See how to compare alternative formulas to see which is faster. Learn how to cop
Excel Formula Efficiency 3: Database D Functions Are Fast
- See how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, D
Excel Formula Efficiency 4: SUMIFS & COUNTIFS Are Fast
- SUMIFS blows SUMPRODUCT away when it comes to calculating Speed. See how the Exc
Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression - Ron's Class
- See how to do Linear Regression for determining what part of a mixed cost is a F
Excel Busn Math 16: Fractions & Fraction Formatting
- Learn about the basics of Fractions and how to format a fraction using Custom Nu
Excel Busn Math 18: Decimal Into Fraction
- See how to go from a decimal to a fractionSee how to go from a fraction to
Excel Busn Math 19: Multiplying & Dividing Fractions
- See how to multiply and Divide Fractions using ExcelKey Points:1.Mul
Excel Busn Math 20: Adding & Subtracting Fractions
- See how to add and subtract fractions and Mixed numbers. See how to find the Low
Excel Magic Trick # 271: Conditional Format w DATEDIF function
- See how to use Conditional Formatting and the DATEDIF function to add formatting
Excel Magic Trick # 273: Extract Top 5 Records w Formula
- Extract top (max high) 5 records w formula where duplicates are allowed. See how
Excel Magic Trick # 274: Probabilities Binomial Distribution
- See how to calculate various probabilities for a Binomial Distribution (Binomial
Excel Magic Trick # 275: Reduce Column Of Numbers By 35%
- See how to reduce a column of numbers by 35% quickly! See twp methods: 1) Copy V
Excel Busn Math 17: Primes & Reducing Fractions
- Learn about Fractions:1.Define Prime Number2.Determine Prime Factors
Excel Magic Trick 284 Create Line Chart W Two Number Series
- See how to create a line chart from years and percentage change. See how Excel m
How To Post Questions At The Mr Excel Message Board
- The smartest Excel People In The World? Some of them hang out at the Mr Excel Me
Excel Magic Trick # 268: Conditional Formatting Max In Row
- See how to apply a conditional format that will highlight the maximum value in a
Excel Magic Trick # 269: COUNTIF & Ampersand
- See how to get criteria from four (4) different cells and combine (join) them in
Excel Magic Trick # 270: Conditional Format Based On Diff Cell
- See how to create conditional formatting based on a different cell. See how to h
Excel Magic Trick # 278: Return Every 10th Value w Formula
- Use INDEX and ROWS functions in formula to Return Every 10th Value w Formula and
Excel Magic Trick # 279: Create the Series AA, AB, ZZ w For
- Use the ADDRESS, LEFT, ROW, ROWS, and COLUMN functions to create the series AA,
Excel Magic Trick # 280: Calculate the Year You Retire
- See how to Calculate the Year You Will Retire with the function YEAR in a formul
Excel Magic Trick # 281: Formula For Vest Date
- See how to use the EDATE function in a formula to calculate the Vest Date for a
Excel Magic Trick # 282: Lookup Name When Today Is Birthday
- See how to use the TODAY function and the TEXT, INDEX, and MATCH functions to re
Excel Magic Trick # 272: Count Unique Or Duplicate Records
- See how to Count unique records and Duplicate records using the SUMPRODUCT, COUN
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
- See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a
Excel Magic Trick # 283: Lookup Vendor Name With Low Bid
- See how to use the INDEX, MATCH and MIN functions to retrieve vendors name when
Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions
- See how to download and install MoreFunc. See new functions like:EVAL eval
Excel Magic Trick # 277: Add 01-12-13-14-15 Text String From
- See how to use the SUBSTITUTE and Morefunc EVAL functions to take a text string
Excel Busn Math 30: Rate Of Change Business Problems
- See how to solve Business Math Word Problems that involve Rate Of Change, Increa
Excel Busn Math 31: Increase & Decrease Math Problems
- See how to solve Increase and Decrease (Rate and Percentage) Business Math Word
Excel Busn Math 32: Markup & Markdown Math Problems
- See how to solve Markup & Markdown Business Math Problems.Excel math f
Excel Busn Math 33: Stock Values Web Query & Rate Of Change
- See how to add current stock prices to your Stock Analysis Table in Excel using
Mr Excel & excelisfun Excel Trick #2: Decrease Values By 35%
- See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a colum
Excel Busn Math 24: Fraction and Percent Equivalents
- See how to build a table of Decimal and Fraction and Percent Equivalents. See ho
Excel Busn Math 25: Part = Rate * Base = Percent Formula
- Learn the basics of the Percent Formula. See a great memorization Trick. See how
Excel Busn Math 26: Solve For Part in Percent Formula
- See how to solve for Part in percent formula. See how to solve Math word problem
Excel Busn Math 27: Solve For Base in Percent Formula
- See how to solve for Base in percent formula. See how to solve Math word problem
Excel Busn Math 28: Solve For Rate in Percent Formula
- See how to solve for Rate in percent formula. See how to solve Math word problem
Excel Magic Trick 294: Filter Pie Chart w Formula & Pivot Table
- See how to filter a Pie Chart so that only the Account Manager's Sales Repre
Excel Magic Trick 295: DV Dropdown From Diff Workbook
- See how to create a data validation dropdown list in 1st workbook when source li
Excel Busn Math 29: Rate Of Change Formulas
- See how to solve for Rate, Amount Of Change and Rate Of Change.Excel
Excel Busn Math 22: Convert Decimals & Fractions To Percent
- See important Formula and Formatting Tricks for Decimals and Percents. Learn wha
Excel Busn Math 23: Rules For Percents In Excel - Percentage
- Learn the three important rules for dealing with Percents in Excel:1
Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks
- Count Words Separated by Commas with LEN & SUBSTITUTE functions in a formula
Excel Magic Trick 290: Count Codes From Column of Text Strings
- See how to count codes from a column of text strings that hah multiple codes. Fo
Excel Magic Trick 291: Add Nums Associated w Codes From String
- See how to count and then add values associated with codes from a column of text
Excel Magic Trick 292: Reverse Last & First Name Tricks
- See how to Extract First and Last Names and rearrange them using a formula. For
Excel Magic Trick 293: Dynamic Count Unique Words In Column
- See two cell formulas and a named formula that will dynamically count unique wor
Excel Magic Trick #247: Add Leading Zeroes w Formula
- See how to add leading zeros to a text string with an array formula. See the fun
Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)
- See how to calculate hours worked for a night shift where workers start at 9 PM
Excel Magic Trick 285: Markup On Sell Price Formula
- See how to calculate Sales Price given Cost and Markup On Sales Price.
Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula
- See how to check a range of cells for codes and then add associated numbers. See
Excel Magic Trick 288: Count Character or Nums. In Text String
- See how to count the number of characters or numbers in a text string with a for
Excel Magic Trick 297.5: Conditional Sum for Varying Columns
- Learn with formula is best from amongst five different formulas for conditionall
Excel Magic Trick 298: MOD function Formula for Total Time Worked
- See how to use the SUMPRODUCT and MOD function to add up all hours in one cell w
Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula
- Use the INT function to calculate total days worked and the TEXT function to cal
Excel Magic Trick 300: YEAR DATE TEXT functions for Date Label
- See how to use the YEAR, DATE and TEXT functions and the ampersand (concatenatio
Excel Magic Trick 301: 1900 Date Problems and Fixes
- See how to enter 1900 dates into cells. See how to change Regional Settings to f
Highline Excel Class 03: Names, Cell References, Formula Inputs
- Learn about:How to Name a range of cellsUse Names in FormulasC
Highline Excel Class 04: Style & Number Format & ROUND
- Learn about:Style FormattingNumber Formatting (Date, Time, Currency,
Highline Excel Class 05: Charts, Page Setup, Data Analysis
- Learn about:See 7 different Charts: X-Y Scatter diagram, Pie Chart, Column
Excel Magic Trick 297: Add Certain Column Only
- See how to select varying columns for summing adding with:1.OFFSET functio
Excel Magic Trick 296: Conditional Format Intersection Row & Column
- See how to add Conditional Formatting to a row, a column and the intersection of
Highline Excel Class 09: SUMIF Function Formula 3 Examples
- See three examples for SUMIF function:1)SUMIF where you want to add only a
Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase
- See how to create projections for sales numbers from a database using the SUMIF,
Mr Excel & excelisfun Trick #3: Wildcard Count
- See Mr Excel and excelisfun demonstrate three methods to count words that contai
Highline Excel Class 01: Back To Basics
- Learn about:How Excel is setupRibbonsQuick Access Toolba
Highline Excel Class 02: Excel Formulas & Excel Functions
- Learn about:1) The different elements of formulas: equal sign, cell
Excel Busn Math 37: Bank Reconciliation
- Learn about Bank Reconciliation.
Mr Excel & excelisfun Trick #4: Comparative Charts
- See Mr Excel and excelisfun create charts to compare data values:1) Bar Ch
Highline Excel Class 07: VLOOKUP function formula 7 Examples
- Learn about:1)VLOOKUP to lookup an exact match2)VLOOKUP to lookup an
Highline Excel Class 06: Worksheet & Workbook References
- Learn how to create worksheet and workbook references in formulas.Th
Highline Excel Class 08: 3-D Cell References Add Across Sheets
- Learn about how to add across sheets using 3-D cell References and the SUM funct
Excel Magic Trick 304: Charts: Add Secondary Axis To Frequency Column Chart
- See how to Add a secondary axis to a chart so that you have axes on the left and
Excel Magic Trick 305: SUM digits from string
- See how to put 112.1 in a cell and add the digits = 1+1+2+1 = 5 using the SUMPRI
Excel Magic Trick 306: MCONCAT LOOKUP functions (CAT = 593)
- See how to use MCONCAT & LOOKUP functions to lookup values from a table and
Excel Busn Math 34: Bank Checks
- Learn all about checks: Terms and elements of bank checks.
Excel Busn Math 36: Bank Service Terms & Credit Card Calculations
- Learn Bank Service Terms and see how to make Credit Card Calculations, including
Highline Excel Class 11: Logical formulas, IS & IF functions
- Learn about:1.Comparative Operators2.Logical TRUE FALSE formulas
Highline Excel Class 12: DATE functions & Formulas
- See how to use the functions: TODAY, NOW, DATE, YEAR, MONTH, DAY, EDATE.
Highline Excel Class 13: Text functions & AMPERSAND
- See how to transform data into useful data using formulas and Text functions suc
Excel Busn Math 35: Check Accounts: Service Charge & Balance
- See how to calculate the service charge for a checking account and see how to cr
Excel Magic Trick 303: VLOOKUP from middle of text-string
- See how to use VLOOKUP function formula when the lookup item is in the middle of
Highline Excel Class 18: Subtotals
- See these 5 Subtotal examples:1. Basics of the Subtotal Feature including
Highline Excel Class 19: Advanced Filter Extract Data 9 Examples
- Learn about using Advanced Filter to extract data from an Excel List / Table / D
Highline Excel Class 20: Pivot Tables 20 Examples
- See these 20 PivotTable Pivot Table examples:1 Proper Format2 Unders
Excel Magic Trick 302: Randomly Select Names No Repeats
- See how to use the INDEX & MRAND functions to randomly select names without
Mr Excel & excelisfun Trick #5: Horizontal Subtotals
- See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set.
Mr Excel & excelisfun Trick #6: Get Last Value In Row
- See Mr Excel and excelisfun try and retrieve the last value in a row. See the IN
Highline Excel Class 14: How To Setup Data in Excel
- See how to set up data in Excel so sorting, filtering, subtotals and PivotTables
Highline Excel Class 15: Excel 2007 Tables 7 Examples
- See the Amazing Excel 2007 Tables do these things:1. Keyboard shortcut to
Highline Excel Class 16: Sort, Sorting 10 Examples
- See these 10 Sorting Examples:1. Sort 1 column with buttons2. Add an
Highline Excel Class 17: Filter, Filtering 8 Examples
- See these 8 Filtering Examples:1. Keyboard shortcut: Ctrl + Shift + L
Excel Busn Math 41: Payroll Deductions With Ceilings (FICA)
- Learn how to calculate deductions from paychecks when there is a ceiling or max
Excel Busn Math 42: Federal Income Tax Payroll Deduction
- Learn about the Wage Bracket Method and the Percentage Method for calculating Fe
Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?
- See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table a
Highline Excel Class 22: Budgets, Scenarios & Scenarios Report
- Create a Budget with Formula Inputs in an assumption area and formulas. Then do
Highline Excel Class 23: Import Different Types of Data
- See how to import data into Excel from text files, web sites, Excel files and Ac
Highline Excel Class 25: Fix Problems & Errors In Spreadsheet
- Learn about:1.Nine errors & what they mean and how to fix them: ####,
Highline Excel Class 24: Order Of Precedents
- See exactly how Excel calculates / evaluates formulas including things like inte
Excel Busn Math 39: Incentive Rate Formulas: 8 Examples
- See Excel formulas for these Incentive Pay Calculations:1.Piecework for on
Excel Busn Math 38: Gross Pay and Overtime: 5 Examples
- Learn about:1.Calculating Gross pay using the ROUND function2.Overti
Excel Busn Math 40: Equivalent Earning Formulas: 12 Examples
- See how to calculate equivalent earnings for different pay periods:Convert
Excel Busn Math 46: Cash Discounts
- See how to calculate Cash Discounts (Incentive for paying Invoices Early) with t
Excel Busn Math 47: Partial Invoice Payment w Discount
- Determine credit given for partial payment of an invoice.This is a H
Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)
- With Formulas: see how to Count Unique Values, List Unique Value, Concatenate ra
Highline Excel Class 27: Custom Number Format & TEXT function
- See how to use Custom Number Format for Cells and the TEXT function:1)Form
Highline Excel Class 26: Fixing Other Peoples Spreadsheets
- See a spreadsheet with 16 problems. See how to use Spreadsheet Construction guid
Excel Magic Trick 307: Invert Range With Formula
- See how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 diff
Mr Excel & excelisfun Trick 8: Top 10 Filter Trouble
- See Mr Excel and excelisfun try to deal with the Top 10 Filter with Two Criteria
Excel Busn Math 43: Invoices & Trade Discounts
- Learn about:1.Invoices2.Complete an Invoice3.Common shipping T
Excel Busn Math 44: Series Trade Discounts
- Learn about:1)Series Trade Discountsa.Discounts separately method
Excel Busn Math 45: Trade Discount Word Problem
- Solve a Trade Discount Word Problem with Excel.This is a Highline Co
Excel Magic Trick 312: Extract Date & Time From Text String
- Use the DATE, MID, LEFT, and TIME functions to extract dates and times from a da
Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples
- Learn about array syntax with the OR function. See three different ways to check
Excel Magic Trick 310: D Functions & Date Criteria
- See how to use DSUM and DMAX (Database functions D Function) with Date Criteria.
Excel Magic Trick 309: Partial Text Match: Why 2^15?
- See how to check to see if an item in first list is second another list, even if
Excel Magic Trick 308: Extract Data To New Workbook W Formula
- See how to Extract Data To New Workbook With Array Formula. See the functions: I
Highline Excel Class 31: Histogram & LARGE SMALL functions
- Topics for this video:1)COUNTIF function formula to build Frequency Table
Highline Excel Class 32: More Charts & SUMIFS & AVERAGEIFS
- Topics for this video:1)Difference between a Line Chart and a Scatter Diag
Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arrays
- Learn about the limitations of the SUMIF function it cannot accept arrays, only
Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0
- See 4 methods for converting TRUE and FALSE to 1 and 0 (zero) using double negat
Excel Magic Trick 313: Some Facts About Array Formulas
- Learn theses important Facts about Array Formulas:Point #1: Formulas that
Mr Excel & excelisfun Trick 9: Data In Columns VBA or Clipboard?
- See Mr Excel and excelisfun take a table of data and create a column of values t
Excel Magic Trick #119: Is Item In List? 2 Examples
- See how to determine if a particular item is in a list of items using two formul
Highline Excel Class 28: More Excel Basics Review
- Topics for this video:1)Learn about the functions: ROUND, ROUNDDOWN, ROUND
Highline Excel Class 29: Basic Statistics Numerical Measures
- Topics for this video:1)Averages such as; Mean Median and Mode2)Lear
Highline Excel Class 30: SUMIF, RANK & Bonuses
- Topics for this video:1)SUMIF function to add with one criteria2)RAN
Excel Busn Math 48: Basics Of Markup (Cost & Selling)
- Learn about the Basics of Markup on Cost and Markup on Selling Price. Markup on
Excel Busn Math 49: Markup On Cost
- Learn how to make calculations for Markup on Cost. See 3 examples of Markup on C
Excel Busn Math 50: Markup On Selling Price
- Learn how to make calculations for Markup on Selling Price. This is
Excel Busn Math 51: Convert Markups & Perishable Sell Price
- Learn how to Convert Markup on Cost to Markup on Selling Price. Learn how to Con
Excel Busn Math 52: Markup & Markdown
- Learn how to make calculations for Markup & Markdown.This is a H
Excel Magic Trick 317: MID function: Pattern Recognition
- See how to Extract Data (substring from string) using the MID Function. They key
Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble
- Extract data with MID and use VLOOKUP to retrieve a date. See how to lookup the
Excel Magic Trick 321: Match Text Substrings
- See how to Match All Text Substrings with an array formula that uses the AND ISN
Excel Magic Trick 322: NOT Advanced Filter Data Extract
- See how to create an Advanced Filter Data Extract with an AND and NOT criteria.
Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)
- Two formulas: VLOOKUP function with wild card criteria for the lookup_value and
Highline Excel Class 35: IF Function Vs. VLOOKUP Function
- Topics for this video:1)See an efficient IF function formula get beat by a
Highline Excel Class 33: IF AND OR Customer Credit Analysis
- Topics for this video:1)Credit Analysis for Customers with IF, AND, OR, NO
Highline Excel Class 34: IF function Formula Payroll Formula
- Topics for this video:1)See how to create a formula that will calculate th
Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF
- See how to use the SUMPRODUCT & SUMIF functions together to Lookup multiple
Excel Magic Trick 319: VLOOKUP - Lookup Table In Descending Order Use INDEX & MATCH
- See how to do VLOOKUP in reverse order using the INDEX & MATCH functions and
Highline Excel Class 36: Array Formulas Basics
- Topics for this video:1)Learn about the basics of array formulas2)En
Highline Excel Class 37: SUMPRODUCT function
- Topics for this video:1)Learn about the basics of SUMPRODUCT2)The SU
Highline Excel Class 38: Array Functions TRANSPOSE FREQUENCY
- See how to use the array functions:1)TRANSPOSE2)FREQUENCYThis
Highline Excel Class 39: Forcing Functions To Become Arrays
- If an array or range is put into a function argument that is expecting a single
Mr Excel & excelisfun Trick 10: Turn Column / Row Upside Dow
- See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) w
Excel Magic Trick 325: Aggregate Daily Cost to Monthly Cost
- See a formula that takes a fixed daily cost and calculates the monthly total for
Excel Magic Trick 326: Hyperlink Worksheet To Worksheet
- See how to create a hyperlink from one sheet to another sheet in the same workbo
Excel Busn Math 53: Simple Interest & Loans / Notes
- Learn how to make various calculations for Simple Interest NotesSee these
Excel Busn Math 54: Simple Interest Part & Base & Rate
- Solve for Part, Base, or Rate for Simple Interest Loan problems.This
Excel Busn Math 55: Simple Interest Discount Note
- Learn how to make calculations for:1.Discount Notes2.Bank Discount
Excel Busn Math 57: Future Value Calculations
- Learn how to make calculations for Future Value and Total Interest Earned
Excel Busn Math 58: Present Value Calculations
- Learn how to make calculations for Present.This is a Highline Commun
Highline Excel Class 21: Conditional Formatting 12 Examples
- See how to add conditional formatting for:1)Data Bars to show relative siz
Excel Magic Trick #214: Circular Reference in Formula
- See how to deal with a Circular Reference Warning in a formula.
Excel Magic Trick 324: Dynamic Data Validation List of Dates
- See how to create a dynamic list of dates for a Data Validation Drop Down List.
Highline Excel Class 44: Basics of INDEX & MATCH functions
- Learn 1-way, 2-way & 3-way lookup using the INDEX and MATCH functions see th
Highline Excel Class 46: CHOOSE function 4 Examples
- See 4 examples for the CHOOSE function:1.Randomly CHOOSE names (where valu
Excel Magic Trick 328: VLOOKUP Without 1st Column
- See how to use VLOOKUP when you do not have a first column to use for lookup. Al
Mr Excel & excelisfun Trick 11: Randomly Select A Name
- See Mr Excel and excelisfun create a formula that will randomly select a name fr
Excel Busn Math 56: Compound Interest & Future Value
- Learn how to make calculations for Future Value and Total Interest Earned
Highline Excel Class 45: INDEX function & MATCH function 12 Unusual Examples
- INDEX function & MATCH function. See 12 examples for the INDEX and MATCH fun
Highline Excel Class 40: VLOOKUP 11 Unusual Examples
- See these 11 VLOOKUP tricks:1.VLOOKUP algorithm2.VLOOKUP, Named Rang
Highline Excel Class 41: HLOOKUP ROWS Horizontal Lookup
- Learn how to use the HLOOKUP and ROWS function to retrieve multiple values from
Highline Excel Class 42: Versatile LOOKUP function 10 Examples
- See these 10 LOOKUP tricks1.LOOKUP: 1) 1st column sorted ascending, 2) onl
Highline Excel Class 43: MATCH function
- Match function tricks:1)Find ordinal position (relative position) of an it
Excel Magic Trick 327: Gantt Chart with Weekends and Holidays
- See how to create a Gantt Chart that will include highlight the workdays one col
Excel Busn Math 59: Annuities Math & Excel
- Learn what an annuity is and how to make calculations for annuities. Future Valu
Excel Busn Math 60: Future Value Annuities FV & PMT function
- See how to use the Excel functions FV and PMT to make a future value calculation
Excel Busn Math 61 Present Value Annuities PV & PMT function
- See how to use the Excel functions PV and PMT to make a present value calculatio
Excel Busn Math 62: Sinking Funds
- See how to use the Excel functions FV and PMT to make a future value calculation
Highline Excel Class 48: Interest Rates 6 Examples
- See the Excel functions RATE, EFFECT, NOMINAL, NPER solve these problems:1
Highline Excel Class 49: Spreadsheet To Compare Loans
- Debt Analysis with input variables: % Down Payment, APR, Years, Points, Extra Fe
Highline Excel Class 50: Value Asset: PV NPV & XNPV function
- See how to value an asset, Discounted Cash Flow Analysis, with the Excel functio
Highline Excel Class 51: Life Time Savings Plan
- See a full life time savings plan using the FV and PMT functions and other formu
Mr Excel & excelisfun Trick 12: Sort Numbers With Formula
- See Mr Excel and excelisfun create formulas that will take an unsorted list and
Highline Excel Class 54: Excel VBA code From Internet
- Learn about:1.Formatting a simple Static Report (Common Macro task in the
Excel Magic Trick 329: Frequency Polygon With 2 Or More Line
- See how to create a Frequency Table. Then see how to calculate the midpoint of e
Excel Magic Trick 330: DCOUNT DSUM between 2 Numbers
- See how to use the DSUM and DCOUNT functions to sum or count between an upper an
Excel Magic Trick 331: EXTRACT Numbers without Leading Zeros
- See how to extract individual characters without extracting the Leading Zeroes u
Highline Excel Class 47: PMT function 5 Examples
- See 5 examples for the PMT function:1.Monthly loan payment at the end of e
Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions
- IF & ISERROR or IFERROR functions for errors? See how to fix errors with the
Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice
- See how to use VLOOKUP & Data Validation to make an Invoice when the Product
Highline Excel Class 52.5: Macro Security
- Learn about:1.Macro SecurityThis is a beginning to advanced Excel cl
Highline Excel Class 52: Recorded Macro Basics
- Learn about:1.How to Record a Macro2.Macro = VBA code3.Macros
Highline Excel Class 53: Relative & Absolute Macro Recorder
- Learn about:1.Relative & Absolute button in the Developer Ribbon
Mr Excel & excelisfun Trick 14: Trending Up Down Arrows
- See Mr Excel and excelisfun create formulas and Conditional Formatting that will
Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes
- See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excl
Excel Magic Trick 335: VLOOKUP & Data Validation for Recipes
- See how to take recipes listed in a column, set them up in rows, then create a d
Excel Magic Trick 336: Incrementing Numbers In Formulas
- Learn about the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions :to:1)Inc
Excel Magic Trick 332: Insert Text with REPLACE function
- Insert Text into Test String with REPLACE function See how to insert a part of p
Excel Magic Trick 339: Sum Differences with 2 Criteria SUMPRODUCT
- See how to use the SUMPRODUCT function to add the difference between two columns
Excel Magic Trick 340: Weighted Percent without 2 Lowest (SMALL & LARGE functions)
- Learn about the SMALL and LARGE functions and array syntax for retrieving more t
Mr Excel & excelisfun Trick 15: Frequency Distribution
- See Mr Excel use a Pivot Table with Grouping and a Count function to create a Fr
Excel Magic Trick 337: RANK function 10 Examples
- See how to Rank numbers in Excel:1.Rank Smallest To Biggest (Ascending)
Excel Magic Trick 338: Extract Records By E-mail Extension
- See how to use the REPLACE and FIND functions in a new column to extract e-mail
Excel Statistics 33: Measures Of Location
- Learn about Mean, Median Mode, Percentile, Quartile, Percentile Rank and Rank. S
Excel Statistics 32: Frequency Distribution Summary (Pivot Table & Formula)
- This video summarizes the seven videos on Grouping Quantitative Data to make Fre
Mr Excel & excelisfun Trick 16: Scroll Bar For Percentage
- See Mr Excel and excel is fun create scroll bars that will control a percentage
Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magic
- See how to Delete Blanks rows:1.Highlight Column A2.F5 key (Go To)
Excel Magic Trick 341 Extract Data w OFFSET & INDEX function
- See the INDEX and MATCH function work together to retrieve a cell reference that
Excel Statistics 37: PERCENTILE & QUARTILE
- Learn about Percentiles and Quartiles. See how to use the PERCENTILE and QUARTIL
Excel Statistics 36: Trimmed Mean
- See how to calculate a Trimmed Mean, which is used when there are extreme values
Excel Statistics 35.2: Geometric Average V Arithmetic Mean - Finance Example
- Compare and contrast Geometric Average and Arithmetic Mean in Finance. See the G
Excel Statistics 35: Weighted Mean & Geometric Mean
- See how to calculate Weighted Mean, Geometric Mean, and see how to use the GEOME
Excel Statistics 34: MEAN, MEDIAN, MODE (Averages)
- Learn about MEAN, MEDIAN, MODE. These measures give us a typical value, a measur
Excel & Statistics 42: Coefficient of Variation
- Learn how to calculate the Coefficient of Variation.Chapter 03 Busn
Excel & Statistics 41: Sample Standard Deviation (Variability)
- Calculate Deviations, Variance and Standard Deviation for a sample and a populat
Excel & Statistics 40: Range & Interquartile Range (Variability)
- See how to calculate Range & Interquartile Range for Variability. See the MA
Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread)
- Learn about Variability, or Dispersion, or Spread. Create an X-Y Scatter Diagram
Excel Statistics 38: Data Analysis Add-in Rank & Percentile
- Learn about Ranking and Percent Rank. See how to use the RANK and PERCENTRANK fu
Excel & Statistics 47: Empirical Rule (Bell Shaped Curve)
- Learn about the basics of the Empirical Rule (Bell Shaped Curve) and how to appl
Excel & Statistics 46: Chebyshev's Theorem
- Learn about Chebyshev's Theorem and how to apply it in three different ways.
Excel & Statistics 45: Z-Score (# Standard Deviations From Mean)
- See how to calculate a z-sco 1) Number of Standard Deviations a particular
Excel & Statistics 44: Skew & SKEW function
- Learn how to use the SKEW function to calculate the skew in a distribution of da
Excel & Statistics 43: Data Analysis Add-in Descriptive Statistics
- See how to use the Excel Data Analysis Add-in Descriptive Statistics tool. Quick
Excel Statistics 51: Probability Basics with Excel
- Learn the basics of probability:1.Probability2.Experiment & Expe
Excel Statistics 50: Probability Basics (by hand notes)
- Learn the basics of probability:1.Probability2.Experiment & Expe
Mr Excel & excelisfun Trick 17: Count Times Greater Than 5 M
- See Mr Excel and excelisfun create 5 formulas to count times greater than five m
Excel & Statistics 49: Outliers & Box Plot with Median and Mean
- See how to find Outliers with the +/- 3 Z-score rule and the ABS function. See h
Excel & Statistics 48: Empirical Rule vs. Chebyshev's Theorem
- See a comparison of Chebyshev's Theorem (Not Bell Curve) and the Empirical R
Mr Excel & excelisfun Trick 18: IF function with FIND SEARCH AND OR ISERROR & ISNUMBER functions
- See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMB
Excel Statistics 54: Joint Probability Table and More!
- See how to create a Joint Probability Table and then calculate these various pro
Excel Statistics 55: Probability Pivot Table
- See how to calculate these probabilities with a Pivot Table (PivotTable):1
Excel Statistics 53: Probability Laws with Excel
- Learn these Probability Laws:1.Venn Diagram2.Complement Rule3.
Excel Statistics 52: Probability Laws (by hand notes)
- Learn these Probability Laws:1.Venn Diagram2.Complement Rule3.
Excel Statistics 59: Discrete Probability Mean & Standard Deviation SUMPRODUCT function
- See the formulas for calculating Mean and Standard Deviation for a Discrete Prob
Excel Statistics 58: Discrete Probability Chart with 2 Data Sets
- Topics for Discrete Probability Distributions::1.Create a Column Chart for
Excel Statistics 57: Build Discrete Probability Distribution & Chart
- Topics for Discrete Probability Distributions:1.Define Random Variable
Excel Statistics 56: Discrete Probability Distributions (Basics)
- Topics for Discrete Probability Distributions::1.Discrete Random Variables
Excel Statistics 55.5: Bayes Theorem Posterior Probabilities
- See how to calculate Posterior Probabilities using Bayes Theorem and the SUMPROD
Excel Statistics 65: POISSON function Poisson Probability Distribution
- Learn how to use the POISSON function to calculate probabilities for a Poisson P
Excel Statistics 63: BINOMDIST & Mean & Standard Deviation For Binomial Probability Distribution
- Learn how to calculate Binomial Probabilities and the mean and standard deviatio
Excel Statistics 62: Binomial Experiments & Probabilities
- Learn all about the BINOMDIST Excel function for calculating a Binomial probabil
Excel Statistics 61: Stock Expected Return & Standard Deviation (Probability)
- Finance Stock example using Mean and Standard Deviation for a Discrete Probabili
Excel Statistics 60: Budget Income Statement (Probability) SUMPRODUCT function
- Create a Budgeting Income Statement from a Frequency Distribution for units sold
Excel Statistics 69: #1 Normal Probability Excel Functions & Area Charts
- Calculate Probability (area) for Normal Curve for less than or equal to an X val
Excel Statistics 68: Normal (Bell) & Standard Normal Characteristics
- Topics for Continuous Probability Distributions::1.See Dynamic Chart exam
Excel Statistics 67: Uniform Probability Distributions
- Topics for Uniform Probability Distributions:1.Uniform Probability Distrib
Excel Statistics 66: Continuous Probability Distributions (Normal, Uniform, Exponential)
- Topics for Continuous Probability Distributions::1.Compare Discrete and C
Excel Statistics 64: Cumulative BINOMDIST with IF Function for Cumulative Distribution Charts
- See how to use the IF function and the BINOMDIST function to show cumulative Pro
Mr Excel & excelisfun Trick 19: VLOOKUP to Left (MATCH & INDEX or LOOKUP)
- See Mr Excel and excel is fun try to use VLOOKUP to the left. Mr Excel shows how
Excel Statistics 73: Exponential Probability EXPONDIST function
- Learn about the Exponential Probability Distribution and the EXPONDIST function.
Excel Statistics 72: Find X Given Normal Probabilities NORMINV & NORMSINV functions
- For the Normal and Standard Normal Curves, see how to calculate an x value given
Excel Statistics 71: #3 Normal Probability Excel Functions & Area Charts
- Calculate Probability (area) for Normal Curve between 2 X values. Topics for Nor
Excel Statistics 70: #2 Normal Probability Excel Functions & Area Charts
- Calculate Probability (area) for Normal Curve for greater than or equal to an X
Excel Statistics 75: Point Estimates & Sample Error
- Topics for:1.See how to take a sample from a data set using the INT, RAND,
Excel Statistics 76: Sampling Distribution Of Sample Mean & Central Limit Theorem
- Topics for:1.Learn how to construct a Sampling Distribution Of Sample Mean
Excel Statistics 77: Probabilities for Sampling Distribution Of Sample Mean
- Topics for:1.NORMDIST function for Sampling Distribution Of Sample Mean
Excel Statistics 78 Relationship Standard Error & Sample Size
- Learn about the Relationship Between Standard Error & Sample Size and see ho
Excel Statistics 79: Proportions Sampling Distribution
- Calculate the probability that a sample proportion will be with a given amount o
Excel Magic Trick 346: EXPONENTS Formula and Formatting in Excel
- See how to format your numbers to show exponents and see how to create a formula
Excel Magic Trick 347: Magic Moments In Excel! MROUND v ROUND functions
- What To Do When No MROUND. IncongruentBalance sends in a trick that will help ro
Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick
- See a formula that will take invoice information for inventory quantity sold and
Mr Excel & excelisfun Trick 20: Summarize Survey Pivot Table
- See Mr Excel and excel is fun summarize survey data with a Pivot Table (Grouping
Excel Statistics 74: Taking a Sample with RAND & VLOOKUP
- See how to take a Simple Random Sample using the RAND and VLOOKUP functions
Excel 2010 Preview #3: New Percentile Function PERCENTILE.EXC
- Amazing new Percentile function that blows the old one away! See the new Excel 2
Excel 2010 Preview #2: Copy & Paste Special Magic
- See the new Copy and Paste options in Excel 2010. Right-clicking will provide Li
Excel 2010 Preview #1: New Rank Function RANK.AVE
- RANK.AVE will average the rank score when there is a tie!! See the new Excel 201
Excel Magic Trick 344: MAX IF & RANK functions without Zeros
- Max value when there is more than one criteria. See how to extract the maximum w
Excel Magic Trick 345: Find 1st Positive number and assign 1 MATCH & COUNTIF functions
- See how to find the first positive number in a list and assign the number 1. See
Excel Statistics 84 Confidence Interval Data Analysis Add-in Descriptive Statistics
- See how to construct Confidence Intervals When Sigma in NOT Known using the Desc
Excel Statistics 85: Confidence Intervals for Proportions #1
- See how to construct Confidence Intervals for Proportions using NORMSINV functio
Excel Statistics 86: Confidence Intervals for Proportions #2
- See an advertising Example for Confidence Intervals using Proportions. See how t
Excel Statistics 87: Sample Size for Confidence Intervals
- See an how to calculate Sample Size for Confidence Intervals.Busn 21
Excel 2010 Preview #4: Pivot Table Slicer (Report/Page Filter Slicer)
- The new Slicer feature for the Pivot Table Report / Page Filter is beautiful and
Excel 2010 Preview #5: Conditional Formatting Negative Data Bars
- See the new Conditional Formatting for Cell Data Bars in Excel 2010. It will sho
Excel Statistics 80: Confidence Interval Sigma Known
- See how to construct Confidence Intervals When Sigma Known. See CONFIDENCE and N
Excel Statistics 81 Confidence Interval Sigma Known From Raw Data
- See how to construct Confidence Intervals When Sigma Known from Raw Data. See CO
Excel Statistics 82: Confidence Interval Sigma Not Known TINV function
- See how to construct Confidence Intervals When Sigma in NOT Known using the TINV
Excel Statistics 83: Confidence Interval For Advertising TINV function
- See how to construct Confidence Intervals When Sigma in NOT Known using the TINV
Excel Magic Trick 350: Conditional Format Values Listed 3 Times COUNTIF function Trick
- COUNTIF and Conditional Formatting. See how to use the Conditional Formatting an
Excel Magic Trick 351: Dynamic Area Chart (Plot x & f(x) on Area Chart)
- See how to create an Area Chart for an X and F(X) data and then use the IF funct
Excel Magic Trick 352: English and Math Comparative Operators
- Greater than or equal to, at least, no less than, X or more, less than or equal
Excel 2010 Preview #7: Confidence Intervals for T-Distribution CONFIDENCE.T function
- The new Excel 2010 Statistics function CONFIDENCE.T will calculate the Margin of
Excel 2010 Preview #6: Normal Distribution Statistic Functions NORM.DIST & NORM.S.DIST
- See the new NORM.DIST and NORM.S.DIST functions. They have new screen tips to he
Excel Statistics 91: TINV & TDIST functions for Critical Value and P-value 6 examples
- How to use TINV and TDIST functions. See 6 examples of T functions for Critical
Excel Statistics 92: Hypothesis Test T Distribution
- How to use TINV and TDIST functions. See 6 examples of T functions for Critical
Excel Statistics 93: Hypothesis Test Proportions
- See how to use NORMSINV and NORMSDIST to complete a hypothesis test about a popu
Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!)
- See Mr Excel and excelisfun demonstrate Excel 2010 Sparklines! Sparklines are sm
Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data
- See how to create a chart for the last 9 weeks of data the automatically changes
Excel Magic Trick 353: Date VLOOKUP for Seasons
- Use VLOOKUP approximate Match with Dates. See Data Validation and Conditional Fo
Kid Empties Bottle - Funny Waterfall
- Kid Empties Bottle Of Water and it looks like a waterfall.
Excel Statistics 88: Confidence Interval & Hypothesis Tests
- See the Excel functions NORMSINV for critical value and NORSDIST for p-value. Co
Excel Statistics 89: Hypothesis Testing With Critical Value & p-value
- See the Excel functions NORMSINV for critical value and NORSDIST for p-value. De
Excel Statistics 90: NORMSINV for Critical Value NORMSDIST for P-value 6 examples
- See 6 examples of NORMSINV for Critical Values NORMSDIST for P-values for Hypoth
Excel 2010 Preview #8: Five New T Distribution Functions that Replace TINV & TDIST
- T.INV, T.INV.2T, T.DIST, T.DIST.RT, T.DIST.2T replace the old T functions: TIN
Mr Excel & excelisfun Trick 22: Conditional Formatting VBA or OFFSET?
- See Mr Excel use VBA code for Conditional formatting and see excelisfun use the
Excel Magic Trick 356: Dynamic Two-Way Look Form Different Workbook
- See how to create a Dynamic Two-Way Look Form Different Workbook. See these topi
Excel Magic Trick 355: VLOOKUP for Mortgage Calculator
- See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 differe
Excel Magic Trick 354: 2 Criteria Counting for Blood Sugar Levels
- See how to count blood sugar levels that fall into specified Categories using SU
Excel Magic Trick 366: Lookup Adding For Accounting Estimate
- See how to use SUMPRODUCT and SUMIF functions to lookup multiple values for expe
Excel Magic Trick 367: Any Number Not Zero = TRUE
- See that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE. See th
Excel Magic Trick 368: Count Unique Items With More Than One Criteria
- Amazing use of the FREQUENCY and MATCH functions! Array formula for counting uni
Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice
- See array formula that will extract records that are not listed twice. See the f
Excel Magic Trick 357: Excel Efficiency: Proper Data Setup, Then Lookup From Different Sheet
- Move football betting data from master sheet to individual sheets when the data
Excel Magic Trick 361: Line Chart Diastolic & Systolic Blood Pressure
- See how to create a dynamic two data series line chart for blood pressures. This
Excel Magic Trick 362: 12 Amazing Counting Formulas
- See the functions, FREQUENCY, SUMPRODUCT, COUNTIF, COUNTA, COUNT, ISNUMBER, ROWS
Excel Magic Trick 363: Return Cell Address of First Non-Blank
- Array Formula for returning cell address for first non-blank cell that uses the
Excel Magic Trick 364: Return First Non-Blank (Array Formula)
- Array formula for returning cell content from first non-blank cell in a row that
Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)
- Amazing non-array formula to returns the cell content from the first non-blank c
Excel Magic Trick 370: Conditional Formatting Odd & Even Numbers
- See how to Conditional Format Even and Odd numbers using a TRUE / FALSE formula
Mr Excel & excelisfun Trick 23: Excel 2010 New Functions
- See Mr Excel and excelisfun show off the new Excel 2010 functions: NETWORKINGDAY
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
- Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winn
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
- Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
- Duplicate Lookup or Lookup 1 value, return many for a row Part 3. See a formula
Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words)
- See how to select 3 numbers from 50 with no repeats. See how to select 3 names f
Excel Magic Trick 375: Keyboard Shortcut For Copying Columns
- See how to copy non-contiguous columns of data and then paste all the columns at
Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers
- See how to to create an array formula for a Stem and Leaf Chart for numbers that
Mr Excel & excelisfun Trick 25: Extract Records NOT Swim or Ski (Filter or Formula?)
- See Mr Excel and excelisfun extract records from database that are NOT Swim or S
Mr Excel & excelisfun Trick 24: VLOOKUP, MAX, Boolean, IF, Which is Best?
- See Mr Excel and excelisfun throw out 5 different methods for calculating a bonu
Excel Magic Trick 379: Round to Nearest 1/10th Hour for Payroll
- See how to round the hours worked to the 1/10th of an hour using ROUND and MROUN
Excel Magic Trick 380: Negative Numbers Round To Nearest 5
- See that MROUND will not round to a multiple for negative numbers. Instead will
Excel Magic Trick 374: COUNT Odd or Even Numbers
- SUMPRODUCT and MOD function in formula to count either odd or even numbers. See
Excel Magic Trick 371: Average Time Between Customer Orders AVERAGEIF & AVERAGE IF
- See how to calculate the average time between orders for individual customers by
Excel Magic Trick 372: WORKDAY function - Find Date in Future
- See how to find the school evaluation end date with the WORKDAY function given a
Excel Magic Trick 385: Generate Random Letters without RANDBETWEEN function
- See how to Generate Random Letters without RANDBETWEEN function using the formul
Excel Magic Trick 386: Less Than the Letter M Conditional Formatting
- See how to add conditional formatting for letters less than the letter M. Yes! C
Mr Excel & excelisfun Trick 26: Randomize Between 2 Dates
- See Mr Excel and excelisfun create random dates between upper and lower dates us
Excel Magic Trick 377: Add Every Other Number In Range of Cells
- See how to add every other number with the SUMPRODUCT, MOD and ROW functions in
Excel Magic Trick 378: Field Names Should Be Formatted
- If field names have formatting, Excel understands that they are field names and
Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!
- See Mr Excel and excelisfun use 10 different methods for counting with more than
Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature
- See how to merge two lists into one list while keeping unique items from List 1
Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List
- Match date in List 1 with List 2, if there is a match take second column from ea
Excel Magic Trick 383:Conditional Formatting Between a Max and Min
- See how to add conditional formatting to values that lie between a max and a min
Excel Magic Trick 384: Keyboard Shortcut To Highlight 1000 Cells
- See a Keyboard Shortcut To Highlight 1000 Cells using Go To and Shift Enter.
Excel Magic Trick 389: Ctrl + Period Keyboard Shortcut
- See how to Use Ctrl + Period to move the active cell in a selected range.
Excel Magic Trick 390: Increment Word & Number 2 Methods.
- See how to do create a column of words and numbers quickly with two different fo
Excel Magic Trick 391: Custom Number Format to Insert Symbol Automatically
- See how to use custom number format to insert symbol automatically. So that ever
Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank
- See how to randomly generate 1, 0 or blank with CHOOSE function and the RAND, RA
Excel Magic Trick 393: Remove Last Two Words From Column Of Data
- See how to remove last two words for column of data using LEN, SUBSTITUTE, FIND,
Excel Magic Trick #395: When ROUND function Must Be Used
- Learn about when the ROUND function must be used:1) Operation is multiplyi
Excel Magic Trick #396: COUNTIF function and Multiplying
- See how to use the COUNTIF function to count criteria and then use the function
Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria
- See Mr Excel and excelisfun find the record with the earliest date given three c
Excel Magic Trick 387: Data Validation Drop-Down List & Cell References
- See how to create three different Data Validation Drop-Down Lists at one time us
Excel Magic Trick 388: Conditional Formatting and the Active Cell
- Learn about why the Active Cell is so important when using a TRUE / FALSE formul
Mr Excel & excelisfun Trick 31: Word Wrap Problem: Formula or VBA solution?
- excelisfun does 15 tricks in one to go from a bad data set to a good data set:
Mr Excel & excelisfun Trick 30: Count Bills for Money Transaction
- See Mr Excel and excelisfun create formula that will take a dollar amount and co
Mr Excel & excelisfun Trick 29: Existing Customers In Prospect List?
- See Mr Excel and excelisfun compare a customer list and prospects list to see if
Excel Magic Trick #394: IF Function and Conditional Formatting
- See how to use the IF function and Conditional Formatting to show the words Warn
Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)
- See how to use an Approximate Match VLOOKUP function and lock the cell reference
Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)
- See how to use a Pivot Table to create a Report that shows the differences in Sa
Excel Magic Trick 402: Monthly Comparative Report - Pivot Table
- See how to use a Pivot Table to create a Report that shows the differences in Sa
Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table
- See how to use a Pivot Table to create a Report that shows the differences in Sa
Excel Magic Trick 404: Quarterly Comparative Report SUMIFS function
- See how to use the SUMIFS function to create a Report that shows the differences
Excel Magic Trick 405: Quarterly Comparative Report SUMPRODUCT function
- See how to use the SUMPRODUCT function to create a Report that shows the differe
Excel Magic Trick 414: Retroactive Dynamic Ranges!
- See how to create dynamic ranges after you have built all your formulas, Data Va
Excel Magic Trick 406: Add 1 Extra For Each Deposit
- See how to add numbers in range plus one extra for each cell with a deposit usin
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values
- See how to use the VLOOKUP function when you have two lookup values for each rec
Excel Magic Trick 399: NA Error Trouble in Array Formula
- See how to fix an array formula that cant handle the NA error with the ISNUMBER
Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down
- See how to use Data Validation Drop-Down List to show a list of values in cells
Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record
- See how to find the Max statistics in each category and return the names associa
Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900
- See how to use the VLOOKUP, LEFT and RIGHT functions to convert the web query re
Excel Magic Trick 411: Expandable Ranges In SUMIFS function.
- See how to create a running total in a column based on two criteria using the SU
Excel Magic Trick 412: Data Validation Drop Down List & OFFSET function
- See how to use Data Validation Drop Down List, Relative Cell References and the
Excel Magic Trick 413: Copied Web Site Data Trouble CLEAN TRIM Text To Columns
- Web Site Copied Data Has Extra Characters? Use CLEAN function. Use the TRIM func
Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value
- See how to create conditional formatting with a TRUE FALSE formula that will alw
Excel Magic Trick 422: Conditional Formatting 1st Two Rows Regardless of Sort
- See how to Conditional Formatting the first two rows of a data set regardless of
Mr Excel & excelisfun Trick 32: Three Methods for 2-Way Look
- See Mr Excel and excelisfun do two-way lookup three different ways:1.INDEX
Excel Magic Trick 407: Amortization Table W Variable Rate
- See how to create a Amortization Schedule / Table with a variable interest rate.
Excel Magic Trick 408: VLOOKUP MIN Value
- See how to use the VLOOKUP function to look up the name associated with the mini
Excel Magic Trick 416: Add Invoices w Same Prefix (Number v Text problem examined)
- See how to look through a list of Invoice numbers and add only the ones that hav
Excel Magic Trick 417: Get Last Value from Multiple Sheets
- See how to get the last value in Column B from across many sheets using the LOOK
Excel Magic Trick 418: Reference Every Third Value
- See how to use the INDEX and ROWS function to list every third value from a colu
Excel Magic Trick 419: Add Two Largest, But Skip Columns C & E
- See how to add the two largest values in a range with the requirement that we sk
Excel Magic Trick 420: VLOOKUP w SUM function in 3rd argument (Football Betting Table)
- See how to lookup a betting score based on the difference between points and whe
Excel Magic Trick 429: Count IDs that Are the Equivalent (DELTA function)
- See how to count how many IDs are equivalent using the IF, DELTA or SUMPRODUCT f
Excel Magic Trick 430: Count Sales Numbers Greater Than Hurdle (GESTEP function)
- See how to count how many Sales are above a hurdle using the IF, GESTEP or SUMPR
Mr Excel & excelisfun Trick 33: First Monday For Reporting Period
- See Mr Excel and excelisfun show three formulas for finding first Monday of repo
Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun
- See how to use the excelisfun YouTube channel:1) Search For Videos
Excel Magic Trick 415: Summarize Survey Results 2 Different Methods
- See how to summarize survey results (Psychology test) with:1) Array Formul
Excel Magic Trick 424: Conditional Formatting For Dynamic Range
- See how to conditionally format a range of cells by selecting items from a drop
Excel Magic Trick 425: Functions That Can Handle Array Syntax - But Are Not Array Formulas/Functions
- Learn about 7 functions that can handle array sytax. These are not array formula
Excel Magic Trick 426: VLOOKUP to Assign Category To A Sales Number
- See how to use VLOOKUP to assign a category like OK, Good, Great to a sales numb
Excel Magic Trick 427: Determine Day Name For Future Date
- See how to find the name of the day of the week given an input date. See the fun
Excel Magic Trick 428: Trouble Entering Dates - Date Syntax
- See how to enter dates into Excel properly.
Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position
- See how to use Custom Number Format to show values as rounded to thousands posit
Excel Magic Trick 432: Find & Extract Duplicate Records
- See how to use the COUNTIF function, Sort, Advanced Filter Extract Unique Record
Excel Magic Trick 431: Excel 4 GET.CELL Macro Function
- See how to count cells with a custom number format using the Excel 4 GET.CELL Ma
Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methods
- See Mr Excel and excelisfun add a range of values that is dynamic in two directi
Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function
- See how to add dynamically without the OFFSET function see an amazing use for t
Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)
- See how to Count Workdays given a stat and end date, a number of holidays and th
Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdays
- See how to use the NETWORKDAYS Function for Counting Workdays when Saturday and
Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns
- See how to use VLOOKUP when the first four columns of the lookup table must be u
Excel Magic Trick 435: Extract Duplicate Records with Formula
- See how to take duplicate records listed vertically and list them horizontally u
Excel Magic Trick 434: Extract Completed Records with Formula
- See how to create an array formula to extract transaction records that have been
Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup
- Learn about some common confusion between lookup and data extraction. See the LE
Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table
- See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table
Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation
- This 50 minute video shows 15 examples of how to use Cell References:1)Rel
Mr Excel & excelisfun Trick 35: 3 Way Lookup INDEX or OFFSET function?
- See Mr Excel and excelisfun do a three way lookup. Compare a method that uses IN
Excel Magic Trick 439: NETWORKDAYS.INTL function Excel 2010
- See how to use the new Excel 2010 NETWORKDAYS.INTL function that can deal counti
Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Function
- See how to Multiply a Column Times a Row With TRANSPOSE Function.
Excel Magic Trick 445: Complicated Criteria for MODE calculation LOOKUP
- Advanced Array Formula. See how to calculate the MODE and use the MODE to lookup
Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formula
- See how to create a formula for calculating time worked when the time in and tim
Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet
- See how to use the AND and OR functions to test to see which records should be e
Excel Magic Trick 448: OFFSET Function To Avoid #REF! Error
- See how to use the OFFSET function to avoid the #REF! error when rows are delete
Excel Magic Trick 440: Array Formulas Advanced Tips
- We will try to answer the questions:1.What is the Difference Between Array
Excel Magic Trick 449: Excel Data Analysis Abbreviated Notes
- Abbreviated notes about Excel Data Analysis Raw Data, Sort, Filter, Subtotals, a
Excel Magic Trick 450: Number Formatting Abbreviated Notes (House Paint or Halloween Mask)
- Abbreviated notes about Number Formatting. See how Number Formatting is like Hou
Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)
- See how to count the number of times in a list of times that begin with 7. Examp
Excel Magic Trick 443: SUMIF Cumulative Sales Formula & Pivot Table Cumulative Sales Table
- See how to construct a monthly cumulative sales total with a SUMIF function form
excelisfun Search For Excel Videos and Playlists & Download Workbooks
- 1)Learn how to search for the Excel videos that answer your questions2)Lea
Excel Magic Trick 452: IF Function Formula 16 Examples
- 1-4) IF function To Put Label on Income Statement. See four different Logical Te
Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table?
- See Mr Excel and excelisfun take daily transactional data and create Weekly Summ
Mr Excel & excelisfun Trick 37: Evalualte Text Math VBA, Excel 4 Macro Function, MoreFunc add-in?
- See Mr Excel and excelisfun take math formulas stored as text and evaluate then
Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods
- Learn about Pivot Tables, SUMIF function, COUNTIF function and SUMPRODUCT functi
Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also)
- See how to calculate commission on sales when there is more than one level of co
Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions
- See 4 formulas using LOOKUP function to look up last number, or last word, or la
Excel Magic Trick 455: Advanced Filter Macro: Extract Grant Records Under A Cumulative Total
- See how to extract grant records with highest point value and only extract enoug
Excel Magic Trick 456: Add Only Integer Part SUM & INT functions
- See how to use SUM and INT functions in array formula to add only the integer pa
Excel Magic Trick 457: SUMPRODUCT & OR Criteria
- See how to count all the Fridays and Mondays in a list of dates using the SUMPRO
Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELL
- See how to use the Excel 4 Macro Function GET.CELL to create a formula that will
Excel Magic Trick 461: Progress Toward Goal Chart or Thermometer Chart
- See how to create a Thermometer Chart that fills and un-fills as you slide a For
Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions
- See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and
Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks
- Learn about how the IF Functions logical_test interprets any non-zero number as
Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math
- See how to extract records from a data set with 4 AND criteria and 3 OR criteria
Excel Dynamic Chart #3: Table Feature (Excel 2010 / 2007) List Feature (Excel 2003)
- THE BEST dynamic chart trick around: If you setup data with the Excel 2010 / 200
Excel Dynamic Chart #2: Filter & Sort Feature
- See how to use the Filter and Sort feature to dynamically change the chart.
Excel Dynamic Chart #1: Hide / Unhide Rows
- See how to filter your chart by hiding contiguous or non-contiguous rows. Simple
Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation
- Cake Difficulty Score Calculations for manufacturing company. Learn three import
Excel Magic Trick 463: 4 ways to Add New Data To A Chart
- See how to add data to a chart after the chart has already been created: 4 metho
Excel Dynamic Chart #8: SUMPRODUCT function (Excel 2003 substitute for SUMIFS)
- See how to use the SUMPRODUCT function to aggregate data for a dynamic Chart.
Excel Dynamic Chart #7: SUMIFS function
- See how to use the SUMIF & SUMIFS functions to aggregate data for a dynamic
Excel Dynamic Chart #6: PivotTable PivotChart
- See how to use the Pivot Table and Pivot Chart feature to create the ultimate Dy
Excel Dynamic Chart #5: Dynamic Chart Labels using TEXT function and Ampersand &
- See how to create dynamic chart labels for a chart that is filtered. Learn about
Excel Dynamic Chart #4: Advanced Filter
- See how to use the Advanced Filter to filter data for a dynamic Chart.
Excel Dynamic Chart #13: Web Query Stock Percent of Target Chart
- See how to make a chart based on a dynamic Stock Price Web Query.
Excel Dynamic Chart #12: INDEX function as Alternative to OFFSET function for Dynamic Ranges
- See how to use the INDEX function to create a dynamic range for charts as an alt
Excel Dynamic Chart #10: OFFSET Function Dynamic Range
- See how to use the OFFSET function for two different types of dynamic ranges for
Excel Dynamic Chart #11: Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics
- See how to use the IF function in a column to create a dynamic range for an area
Excel Dynamic Chart #9: 4 Week Chart Dynamic Formula & Dynamic Data Validation Formula
- See a formula setup to create a dynamic 4 month chart. Learn about:1)Data
Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays)
- See Mr Excel and excelisfun show how to do a VLOOKUP to 3 different tables using
Mr Excel & excelisfun Trick 39: Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT
- See Mr Excel and excelisfun lookup a row of data using VLOOKUP & OFFSET wrap
Excel Dynamic Chart #16: Dynamic Average Hurdle Line for Bar Chart. Scatter and Bar Chart Together.
- Bar chart with scores and a dynamic Hurdle line that shows average score. Learn
Excel Dynamic Chart #15: Array Formula & Table Nomenclature for Top 10 Wrestling Score Chart
- See how to make a dynamic chart that shows the top ten wrestlers names and score
Excel Dynamic Chart #14: Progress Chart Linked to Stock Market (Stock Prices Vs. Target Sell Price)
- See how to make a Progress Chart that shows stocks from a Web Query as a percent
Excel Magic Trick 470: Formula For Days In Any Given Month
- Days in Any Given Month Excel 2007 / 2010 Formula=DAY(EOMONTH(TODAY(
Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples
- See how to Sort Horizontally with 3 different formulas that uses LARGE, SMALL, C
Mr Excel & excelisfun Trick 41: VBA or Formula Extract Prefix for VLOOKUP
- See Mr Excel and excelisfun do VBA and an array formula to extract a varying len
Mr Excel Banned From YouTube
- Bill Mr Excel Jelen Banned From YouTube
excelisfun Search for Excel Videos, Playlists & Download Workbooks
- See how to find the Excel video that you want to see. See how to search for Exce
Excel Magic Trick 472: Count Spaces at Beginning & End of Text String Simple Formula
- Learn a better formula than the previous formula seen in: Excel Magic Trick 468:
Excel Magic Trick 466: SUM every Nth value SUMPRODUCT, MOD & ROW functions
- See how to SUM every Nth value using SUMPRODUCT, MOD and ROW functions. See two
Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format)
- See how to Conditional Formatting every Nth value using SUMPRODUCT, MOD and ROW
Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula)
- See how to Count Spaces at Beginning & End of Text String in an Array Formul
Excel Magic Trick 469: VLOOKUP for Horsepower Calculation
- See how to use VLOOKUP to lookup appropriate percentage for Horsepower calculati
Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculation
- See how to enter number of bills in deposit and quickly calculate the total for
Excel Magic Trick 477: 13 Digit Number ID Shows Scientific Notation!?
- See how to prevent Excel from displaying a 13 Digit Number ID in Scientific Nota
Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?
- See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a
Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)
- See how to:1)Extract a unique list of records with a formula and display i
Excel Magic Trick 474: Conditional Format At Every Change In Value
- See how to Conditional Format At Every Change In Value. Steps1Highlight ra
Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations
- See a robust formula that can handle any duplicate situation when doing a Revers
Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers
- See how to take a table of schedule information and return all the dates and tim
Excel Magic Trick 480: Percentage Of Total - Formula or PivotTable (Pivot Table)
- See how to calculate a percentage of total from a database data set when the var
Mr Excel UnBanned From YouTube
- Mr Excel's YouTube Channel is back online. It appears that YouTube came to t
Excel Magic Trick 476: SUMPRODUCT Function for Weighted Average Cost From Transaction Data
- Calculate Weighted Average Cost from a transactional data set using SUMPRODUCT f
Law Class Excel #2: Child Support Payments Template - Jessica's Law Class
- Learn how to create a template for Child Support Payments that shows formulas fo
Mr Excel & Excelisfun Trick43: End Inventory Value From Transactional Records SUMPRODUCT SUMIF
- Mr Excel is on hiatus to finish his new Excel 2010 books. Excelisfun shows how t
Excel Magic Trick 481: Change Operator in Formula from Drop-Down Using CHOOSE function
- See how to change operator in formula from drop-down using CHOOSE function. See
Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet
- See how to have two Pivot Tables (PivotTable) on same sheet with one grouping da
Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers
- Learn how Sort only sees serial numbers for dates, but Filter can see the serial
Excel Magic Trick 486: Avoid #DIV/0! Error in Formula 4 Examples (Divide By Zero Error)
- See how to avoid the Divide By Zero Error in formula when formula input cells ar
Excel Magic Trick 485: Create Shorthand to speed up typing using AutoCorrect
- See how to use Excel AutoCorrect to create shorthand to speed up typing. For exa
Excel Magic Trick 484: Stop Automatic Copyright symbol ©
- See how to turn off the AutoCorrect feature for the Copyright symbol.
Law Class Excel #1: Create Comparative Budget - Jessica's Law Class
- Learn how to create a Comparative Budget using Proper Setup, Formulas, Formattin
Law Class Excel #3: Statistics For Age Discrimination Case - Jessica's Law Class
- Learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistica
Excel Magic Trick 100: Instead of Long IF, Use MEDAIN function Commission W Hurdle Calculation
- Formula from Mr Excel Challenge at Mr Excel web site. You will not believe your
Excel Statistics 31: Histogram using Data Analysis Add-in
- See how to create a Frequency Distribution, a Cumulative Freqency Distribution,
Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula
- See an amazing Array Formula from Domenic and Ron Coderre at the Mr Excel Messag
Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors
- Formula for VLOOKUP with Two Lookup Values that must return all values in a tabl
Excel Magic Trick 487: Hyperlink That Opens Different Workbook or Goes To Different Sheet
- See how to use a hyperlink to open a different workbook, or a different file, or
Excel Magic Trick 494: Active Cell Keyboard Shortcut Selection Trick
- See how to Select cells in a spreadsheet or for a function using keyboard shortc
Excel Magic Trick 490: Conditional Format for Budget Less Than $500.
- See how to add conditional formatting: 1) based on cells value and 2) based on a
Excel Magic Trick 491: Count Matches in Individual Cells
- See how to use SUMPRODUCT to count the number of matches of values entered into
Excel Magic Trick 492: Count Matches in Single Cell
- See how to use SUMPRODUCT, MID, SUBSTITUTE, and array constant in a formula to c
Excel Magic Trick 493: Repeat a List of Names 7 times
- See how to use 1) Copy, Paste and Sort and 2) an INDEX formula using MOD and ROW
Excel Magic Trick 499: Does Cell Have Number or Text Formula Solution
- See how to use the OR, ISNUMBER and ISTEXT function to check to see whether a ce
Excel Magic Trick 498: 6 PivotTable Calculation Tricks (Pivot Table)
- Use PivotTable to Group Numbers, calculate Frequency, % Total, Cumulative Total,
Excel Magic Trick 497: Unit Inventory Total For Each Store SUMIFS or SUMPRODUCT functions
- See a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice in
Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting
- See how to create a basic Attendance Sheet for a classroom in Excel. See THESE T
Excel Magic Trick 495: Print Labels On Each Page For Large Spreadsheet
- See how to Print labels at the top of each page or to the left of each page. See
Excel Magic Trick #503: Custom Number Format For Turnover Ratio
- See how to add custom number format to a cell that will show the word times or p
Excel Magic Trick #504: 3D Formatting For Cells Using Borders
- See how to use the Borders tab in the Format Cells dialog box to create a 3D eff
Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble
- See how to use the INDIRECT, TEXT, SUBSTITUTE, Named Ranges, Create Name From Se
Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)
- Learn about:1.What time is in Excel2.Time in Excel is a decimal betw
Excel Magic Trick 500: Years Worked Formula YEARFRAC, INT, DATEDIF functions
- See how to use the YEARFRAC, INT, and DATEDIF functions to calculate how many ye
Excel Magic Trick 512: Frugal Bargain Hunters - Series Discounts to Calculate Total Savings
- See how to calculate the total savings on a transaction where there are two perc
Excel Magic Trick 513: Equivalent Earnings Simple Formula
- See how to calculate Weekly, Bi-weekly, Semi-monthly, Monthly and Yearly equival
Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Report
- See how to take badly setup data (not in database / table format) and summarize
Excel Magic Trick #506: Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register
- Take Checkbook Register data from multiple sheets and for multiple banks account
Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)
- See how to:1.Dates in Excel are whole numbers - called serial numbers. Exa
Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creation
- See how to create an amortization table that will update when you pay extra prin
Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function
- See how to create a dynamic table for the VLOOKUP function as well as a dynamic
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature
- See how to create a dynamic table for the VLOOKUP function as well as a dynamic
Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed
- See how to create an Amortization table that can handle variable year inputs. Se
Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters
- See how to use Find and Replace, Text To Columns, and the function SUBSTITUTE an
Excel Magic Trick 518: Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX
- See how to use INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to e
Excel Magic Trick 519: SUBSTITUTE & REPLACE Functions
- See how to REPLACE requires a starting position in the text string and the
Excel Magic Trick 522: 30 Days In Each Month Calculations
- See how to make calculations for companies that use 30 day months. See Date Math
Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number
- See how to use Go To Special Blanks to highlight all cells with Blanks. Then use
Excel Magic Trick 514: Conditional Formatting Duplicate Values (3 Methods)
- Methods: 1) Excel 2007 built-in method, 2) COUNTIF functions, 3) COUNTIF functio
Excel Magic Trick 529: Count Sales Over Last 7 Days For Given Product
- See how to use SUMPRODUCT or COUNTIFS Functions to count how many sales you made
Excel Magic Trick 530: Does Text String Contain Repair OR Rework? OR SEARCH ISNUMBER functions
- See how to use OR, SEARCH, and ISNUMBER functions to see if the descriptions in
Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding
- See how to Round numbers two different ways:1.School Rounding: 5 or greate
Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References
- See how to use Conditional Formatting and a COUNTIF True / False Logical Formula
Excel Magic Trick 517: Vendor Name For Low Bid & % Cheaper Than Next Lowest Bid Formula
- See how to use INDEX and MATCH functions to show vendor name associated with low
Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions
- See how to check two data sets (lists tables) to see if there are Discrepancies
Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods
- See how to extract records with Partial Text NOT CRITERIA 4 different ways:
Excel Magic Trick 525: Advanced Filter With Wild Cards
- See how to extract records using Advanced Filter and criteria that uses Wild Car
Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functions
- See how to create a formula that will grade Pass / Fail or Letter grade using th
Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH
- See how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN fu
Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays
- See how to use the OR and WEEKDAY functions to create a logical true / false for
Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions
- See how to count blanks in a dynamic range using COUNTIF, INDEX, MATCH, COUNTA a
Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)
- See two for