Excel Forum
Excel Macros 1 - What is a Macro?   (Easy)
- I explain what a Macro in Excel is, why you might want to use Macros in Excel, a
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 formulas that will remove leading and trailing letters in order to extra
Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekends
- See create a formula to calculate the Difference Between Start Date/Time & E
Mr Excel & excelisfun Trick 44: Count Mondays Between 2 Dates WEEKDAY or TEXT?
- See Mr Excel and excelisfun count the number of Mondays between two dates using
Mr Excel & excelisfun Trick 45: + or with Formula or Custom Number Formatting Math Plus or Minus
- See Mr Excel and excelisfun: 1) create a formula to extract a number from a tex
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
- See how to create a dynamic array formula quickly using the Drill Through Method
Excel Magic Trick 537: Drill Through Spreadsheets -- Formatting, Formulas, Editing
- See how to drill through a spreadsheet to speed up formatting, formulas creation
Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function
- See how to use calculate MODE (statistics) when there is more than one Mode:
Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL
- See how to use NETWORKDAYS NETWORKDAYS.INTL WEEKDAY ROW INDIRECT and SUMPRODUCT
Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computer
- See how to analyze data dump from server computer to see when each file was last
Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet
- See how to:1)Add drop down by typing values in2)Add drop down by sel
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?
- See how to create a Dynamic Data Validation Drop-Down List in a cell using eithe
Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Drop-Down
- See how to create a Drop Down List that is based on another drop down list using
Mr Excel & excelisfun Trick 46: Lookup a value and Retrieve the two items to the Right INDEX & MATCH
- See Mr Excel and excelisfun: lookup a value and the retrieve the values 1 and 2
Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document
- See how to take a word document and extract all the words and get them into a co
Excel Magic Trick 543: Build Time Schedule With 15 Minute Intervals
- See how to Build Time Schedule With 15 Minute Intervals using the Fill Handle.
Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columns
- See how to Conditional Formatting Row When record contains date between begin an
Excel Magic Trick 545: Count Between Dates with 3 Criteria COUNTIFS & DCOUNTA & SUMPRODUCT
- See how to count records that have a date between the begin and end date and a s
Excel Magic Trick 546: Is Item List? Case Sensitive OR & EXACT functions
- See how to use the OR and EXACT functions to check if an item is in a list where
Excel Magic Trick 551: Count Mondays or Sundays or Tuesdays, etc. Between Start & End Date
- See a great non-array formula for counting Mondays between a start and end date
Mr Excel & excelisfun Trick 48: Screen Tip & Excel Is Broken
- See Mr Excel and excelisfun show how to break Excel by moving a data validation
Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method
- See how to use the MATCH function, the Join Symbol (& Ampersand), and the Fi
Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method
- See how to check two 2 lists of records and extract only the new records (record
Excel Magic Trick 541: Get Last Price In Column Based On Criteria In Other Columns
- See how to get last price in column based on criteria in two other columns using
Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table)
- See how to change the PivotTable source data:1)Excel Table Feature2)
Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculations
- See how to use the IF and VLOOKUP to make one of two commission calculations bas
Excel Magic Trick 554: Conditional Formatting for Weekends and Holidays Better than EMT 534
- See how to Conditional Formatting for Weekends and Holidays with the NOT and NET
Excel Magic Trick 553: SUMIF for Dollars and Euros
- See how to use the CELL and SUMIF functions to sum Dollar and Euro amounts from
Excel Magic Trick 552: Display VLOOKUP Results Vertically
- See how to look up and retrieve a row of data from a table and display lit verti
Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font White
- See how to use Conditional Formatting and Data Validation to select OK from a dr
Excel Magic Trick 561: Wildcards * and ?
- Learn about the wild cards * and ? using the COUNTIF function.
Excel Magic Trick 562: Extract Names - Some Names In List Have Middle Name Some Do Not
- See how to extract first, middle and last names when the list contains names whe
Mr Excel & excelisfun Trick 47: Unlink Chart
- See Mr Excel and excelisfun unlink a chart:1.Paste Special Picture2.
Excel Magic Trick 557: CHOOSE function to lookup Formula or Function (2 Examples).
- Select function or formula from drop-down using the CHOOSE function. See how thi
Excel Magic Trick 566: Conditional Format A Chart Student Grades
- See how to use the IF functions and a bar chart to create a conditionally format
Excel Magic Trick 567: Collapsible Expandable Cell Ranges
- See how to create: Collapsible & Expandable Cell Ranges in formulas & fu
Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions
- See how to use the WORKDAY & WORKDAY.INTL Excel 2010 Functions to calculate
Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table
- See how to check if a record is in a table using VLOOKUP. See how to do this for
Excel Magic Trick 559: Extract Nth Word In Text String
- See how to Extract First, Last or Nth Word In Text String using the following fu
Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Feature
- See how to remove duplicate records using the Remove Duplicate Feature which was
Excel Magic Trick 568: SUMIFS function Monthly Running Total from Transaction Data
- See how to create a monthly Running Total from Transaction Data using the SUMIFS
Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula
- See how to create an array formula that will extract loan records that are past
Excel Magic Trick 565: Excel 2010 Daily Gantt Chart
- See how to create a cell chart using conditional formatting with Logical TRUE FA
Excel Magic Trick 564: Daily Gantt Chart
- See how to create a cell chart using conditional formatting with Logical TRUE FA
Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists
- See how to create a formula to grade student answer where more than one possibil
Excel Magic Trick 573: VLOOKUP & OR functions For Filtering Data With Categories of Criteria
- See how to streamline filtering when you have categories of criteria using VLOOK
Excel Magic Trick 574: Array Formula For Filtering Data With Categories of Criteria
- See how to streamline filtering when you have categories of criteria using an ar
Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax
- Learn that comparative operators for COUNTIF and SUMIFS functions must be text a
Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import
- See how to Import Data From Access, use VLOOKUP to populate data into a Printabl
Excel Magic Trick 580: Extract Digits To Right Of Decimal Into Individual Cells
- See how to use the REPLACE, MID, COLUMNS and SEARCH functions to Extract digits
Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter
- See how to use Advanced Filter with criteria to extract a unique list of employe
Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes
- See how to count records that match 3 criteria and add conditional formatting to
Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functions
- See how to Add a point and a dynamic label to a Break Even Chart that marks the
Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records
- See how to use SUMPRODUCT and the Join Symbol (& Ampersand) to group duplica
Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Names
- See how to use the OFFSET function and Defined Names to create dynamic ranges fo
Excel Magic Trick 582: Excel Errors 9 Types - What They Mean - How To Fix Them
- Learn about these errors in Excel: #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!,
Excel Magic Trick 583: AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentage
- See how to use the AVERAGEIF & IFERROR functions with Absolute and Mixed Cel
Excel Magic Trick 585: Deleting Content, Cells, Formatting & The Problem with Right-Click Delete
- Learn how to delete the cell contents only, formatting only, the entire cell, or
Excel Magic Trick 579: MOD function and Date Math Each Successive Date Is Repeated Twice
- See how to use the MOD function and Date Math to create a column of dates where
Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables
- VLOOKUP used in IF function logical test argument to determine whether an employ
Excel Magic Trick 590: Nested IF function Convert From Actual Days to Billed Days
- See how to use the IF function and Date Math to Convert From Actual Days to Bill
Excel Magic Trick 589: Stem & Leaf Chart for Decimals - Array Formula - Statistics
- See how to to create an array formula for a Stem and Leaf Chart for decimal numb
Excel Magic Trick 587: Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria
- Add Conditional Formatting to entire row when 3 criteria are met including conta
Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function
- Add Conditional Formatting to entire row when 3 criteria are met including conta
Excel Magic Trick 596: Counting With 4 Criteria Including All Criteria As A Possibility
- See how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 cri
Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula
- See how to extract word that occurs most frequently from a column of survey resu
Excel Magic Trick 594: How Old Are You? DATEDIF Function
- See how to calculate age in years using the TODAY and DATEDIF functions.
Excel Magic Trick 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record
- Learn about a problem that the DGET function and Advanced Filter have with crite
Excel Magic Trick 591: Paste Special Operations Add & Multiply
- See how to add $600 to a lot of numbers all at once by using Paste Special Opera
Excel Magic Trick 599: ROUND Only The Total Column Using SUM & ROUND Array Formula
- See how to ROUND only the total column using SUM & ROUND functions array for
Excel Magic Trick 600: Convert Hours to Days & Hours using MOD & INT functions
- See how to convert hours to days & hours using MOD & INT functions.
Excel Magic Trick 601: VLOOKUP & IF functions for Bonus Based On Years Worked
- See how to use the VLOOKUP & IF functions for Bonus Based On Years Worked.
Excel Magic Trick 603: Why 100*1.1 = 110 Means Increase by 10%
- See the math behind why 100*1.1 = 110 Means Increase by 10%.100 * 10% = 10
Excel Magic Trick 593: Mondays Only Data Validation using Custom Formula with WEEKDAY function
- See how to add Data Validation to allow only Monday Dates in a cell using the Cu
Excel Magic Trick 606: INDEX & MATCH Two Lookup Values
- See a formula that can lookup two 2 lookup values using the INDEX & MATCH fu
Excel Magic Trick 605: IF Function to Fill In Column With Missing Values Paste Special Values
- See how to use the IF function to fill in column with missing values then use Pa
Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula
- See how to Use Boolean Math and the SUMPRODUCT function to add with 4 criteria,
Excel Magic Trick 602: SUMIF Does Lookup? Total Sales Array Formula w 1 Criteria SUMIF Function
- See how to create a compact array formula that can total sales with 1 criteria w
Excel Magic Trick 598: Hours Worked In Day Including Lunch Breaks
- See how to create a formula to calculate hours worked given an In time, an Out t
Excel Magic Trick 614: Extract Full Date from Monthly Dates Listed As Text -- Pivot Table
- See how to Extract Full Date from Monthly Dates Listed As Text using the REPLACE
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods
- See a formula that can lookup and return all the student names based on the blan
Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free
- See a formula that can lookup and return all the class periods based on the blan
Excel Magic Trick 604: Mixed Cell References In Formulas - Budgeted Income Statement
- How to learn about Mixed Cell References In Formulas. See how to create a Budget
Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice
- See how to Match three lists using 2 VLOOKUP functions and the AND function. Mat
Excel Magic Trick 622: Array Formula to Return Even Row Data Only
- See an Array Formula to Return Even Row Data Only that uses the SUMPRODUCT, MOD,
Excel Magic Trick 610: Pivot Table Year Over Year Sales Calculation From Daily Transactional Data
- Create a Pivot Table to calculate Year Over Year Sales showing Percentage Change
Excel Magic Trick 611: Array Formula Year Over Year Sales Calculation From Daily Transactional Data
- Create an Array Formula to summarize sales for Year Over Year Sales using the SU
Excel Magic Trick 612: Pivot Table Year Over Year Sales Calculation From Dates Listed As Text
- See how to create a Year Category for a Pivot Table from Dates Entered as Text u
Excel Magic Trick 613: Array Formula Year Over Year Sales Calculation From Dates Listed As Text
- Cool Array Formula to add sales for the year from dates entered as text using th
Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas
- See a SUMIFS and SUMPRODUCT functions formula to add the Fiscal Year sales when
Excel Magic Trick 618: Keyboard Shortcut For Date And Time In Same Cell
- Dave "Excel Master" from Florida sends in this cool trick for adding t
Excel Magic Trick 619: Space in Cell Causes Trouble in Formulas. Replace, COUNTA, CLEAN, TRIM
- See how spaces in cells cause trouble in formulas. Learn about these topics:
Excel Magic Trick 620: Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks
- Aladin at the Mr Excel Message Board has great advice about the robustness of fo
Excel Magic Trick 621: Conditional Formatting Unique Items With One Criteria
- See how to add a logical formula that uses the AND and COUNTIFS functions with M
Excel Magic Trick 624: Hours Worked Part Day Shift & Part For Night Shift MEDIAN Function for Hurdle
- See how to break apart the hours worked into one part for the Day Shift and one
Excel Magic Trick 623: PayDay LoansAre Bad Finance -- APR & EAR & Amortization Table
- Learn how to see the painful near-extortion that Pay Day Loans inflict on people
Excel Magic Trick 625: INDIRECT SUBSTITUTE SUBSTITUTE Silly Two Way Lookup Formula
- See an inefficient formula to do Two Way Lookup when the Named Ranges are differ
Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard
- See how to add all the sales for products that contain the word "Box"
Excel Magic Trick 616: LARGE & SMALL Functions (8 Examples)
- Learn how to use the LARGE and SMALL functions in these ways:1. Retrieve t
Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas
- Learn how to build Logical Formulas for counting with criteria or Conditional Fo
Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions
- See how to find a perfect match of 6 successive items using the AND and IF funct
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks
- See how to use the excelisfun YouTube channel:1) Search For Videos
Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)
- Topics about FREQUENCY array function is this video:1. Basics of FREQUENCY
Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas
- See how to create a Gantt Chart to show the amount of time a projects takes duri
Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods)
- See the functions VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT, and INT to lookup
Excel Magic Trick 630: Drag Formula Without Dragging Keyboard Shortcuts Through Huge Range
- See how to copy formula through a huge range using keyboard shortcuts:1) M
Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due
- See how to add conditional formatting to a transactional record when the date is
Excel Magic Trick 632: Count Dates Within Given Year From A List Of Dates With Different Years
- See how to create a formula using the SUMPRODUCT and YEAR function to count 2009
Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Years
- See how to create Conditional Formatting that will highlight the dates within a
Excel Magic Trick 636: Dynamic Frequency Table & Histogram Chart
- See how to create a dynamic frequency table and histogram chart using Defined Na
Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures
- See how to lookup a chart using Defined Names, Data Validation List, and a formu
Excel Magic Trick 638: Two Horizontal Axes for A Chart.
- See how to add two horizontal axes for a chart.
Excel Magic Trick 639: Approximate Match Lookup with Unsorted Column Across Multiple Columns
- See how to create a formula that will do an approximate match lookup with an uns
Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template
- Great Excel Basics to Intermediate Video:1. VLOOKUP to look up a price for
Excel Magic Trick 647: Dynamic Line Chart For Cash Balance using OFFSET function
- See how to create a Dynamic Line Chart that will show any updates to the cash ac
Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank
- See how to create a logical TRUE / FALSE formula for conditional Formatting usin
Excel Magic Trick 641: Create PivotChart in 1 click (Great Keyboard Shortcut for Charts)
- See how to create a PivotChart based on a PivotTable in one click. Pivot Table P
Excel Magic Trick 642: SUMIFS function or PivotTable For Household Budget Summary Table
- See how to create a budget summary table that adds by Month and Payee. See the b
Excel Magic Trick 643: IF Function to Pull Data From A Different Column
- See how to create an IF function formula that will pull data from column C based
Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data
- Advanced Filter & Logical Formulas to Extract Sample Data. For Audit Samples
Excel Magic Trick 660: Advanced Filter Unique Records Only
- See to extract a unique list from a data set using Advanced Filter.
Excel Magic Trick 644: Recorded Macro And Formulas To Re-Arrange Data Set
- See how to create a Recorded Macro that uses formulas to rearrange a proper data
Excel Magic Trick 645: CUMIPMT Function: Cumulative Interest For A Loan
- See how to use the CUMIPMT function to calculate the total interest paid for two
Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set
- See how to create a formula to add a column of categories using the functions VL
Excel Magic Trick 654: Charts: Line & X Y Scatter
- Learn when to use the Line chart and when to use an X-Y Scatter diagram. See the
Excel Magic Trick 655: Frequency Polygon Line Chart
- See how to create a Statistics Frequency Polygon using a line chart. Also, see h
Excel Magic Trick 656: Excel Will Talk To You
- Add the Speak Cells On Enter button to Excel. See how to add a button to the Exc
Excel Magic Trick 657: EOMONTH function For Invoices, Financials, and Quarterly Reports
- See how to calculate Invoice Due Dates & Financial Statement Dates using the
Excel Magic Trick 658: COUNT Vs. COUNTA function
- See how to use the COUNT & COUNTA functions correctly. COUNT counts numbers.
Excel Magic Trick 649: Formula to increment number pattern 1,1,1,2,2,2,3,3,3...
- From Aladin and Hot Pepper at the Mr Excel Message Board see two great formulas
Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function
- See an amazing formula to take all records from a data set and place them into o
Excel Magic Trick 651: Comparative Operators & Logical Formulas
- See how to use all the different Comparative Operators for Logical Formulas (TRU
Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas
- See how to create Boolean Logic formulas for AND and OR Logical Formulas. See Lo
Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function
- Replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE =
Kid Pretends To Plant Garden with Rock Seeds and Water & Then Tells You All About It!
- Kid Pretends To Plant Garden with Rock Seeds and Water & Then Tells You All
Kid's Mud Hold Turns Into Sink Hole (1:40)
- Watch careffully at 1:40 -- Kid Plays in mud hold and then everyone is surprised
4 Year Old's First Drum Lesson
- See kid at first drum lesson!
4 Year Old - Future Rock & Roll Drummer
- See kid make up song while drumming - 4 Year Old - Future Rock & Roll Drumme
Excel Magic Trick 648: Interesting Formula To Create A Data Set ROWS, COLUMNS and CAR functions.
- See the functions ROWS, COLUMNS, and CHAR in a formula that will create a data s
Excel 2010 Magic Trick 671: AGGREGATE function Array Formula #5 Extract Records 2 criteria
- See how to use the AGGREGATE function to create a formula for extracting records
Kid Digs Up Grass With Toy Diggers To Install Grainage Pipes
- Kid plays with toy diggers (Tonka Dump Truck, Front End Loader, Excavator, Bull
Kid Adds Drainage Pipe To Puddle While Playing With Toy Diggers
- Kid Adds Drainage Pipe To Puddle While Playing With Toy Diggers
4 Year Old Follows Dad While Mowing With Toy Mower.
- 4 Year Old Follows Dad While Mowing With Toy Mower.
Kid Makes Jelly Bean Soup
- Kid Makes Jelly Bean Soup with pots and pans. He pretends to cook in the kitchen
Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formula
- See how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal a
Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values
- See how to calculate the five largest values for each sales representative using
Excel 2010 Magic Trick 668: AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores
- See the amazing new AGGREGATE function calculate the 90th percentile CPA score f
Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References
- See that the AGGREGATE function cannot handle 3-D cell references.Do
Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterion
- See how to use the AGGREGATE function to create a formula for extracting records
Excel 2010 Magic Trick 661: AGGREGATE function Contains 19 different functions
- Learn about the new Excel 2010 AGGREGATE function that can calculate these 19 di
Excel 2010 Magic Trick 662: AGGREGATE function Ignores Hidden Rows for Calculations
- Learn about the new Excel 2010 AGGREGATE function that can make calculations tha
Excel 2010 Magic Trick 663: AGGREGATE function Ignores Error Values for Calculations
- Learn about the new Excel 2010 AGGREGATE function that can make calculations tha
Excel 2010 Magic Trick 664: AGGREGATE function Ignores Nested SUBTOTALs for Calculations
- See how to make a calculation on a column of values that contain Subtotals that
Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations
- See how to use the AGGREGATE function to make calculations on filtered data. SUB
Excel Magic Trick 679: Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples)
- See 2 examples of how to summarize yearly totals from monthly totals when there
Excel Magic Trick 680: Add A Scenario Button To Toolbar or Ribbon Excel 2010
- See how to Add A Scenario Button To Toolbar or Ribbon in Excel 2010.
Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula
- See how to use the MIN and IF functions to find smallest number that is greater
Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula
- See three methods to averaged times values that were exported from a database as
Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula
- See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMAL
Excel Magic Trick 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF
- See three formulas for counting blanks or Not Started (OR criteria):1. COU
Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation
- See how create a data validation using Custom Logical Formula with 2 VLOOKUP fun
Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function
- See how to create a Defined Name formula for a dynamic range (columns can vary)
Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula
- See a great array formula from pgc01 and Aladin at the Mr Excel Message Board th
Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function.
- See how SUM only the Values After the Deadline using a Dynamic Range formula usi
Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods
- Extract Month Year Records From Transactional Data using:1. Filter2.
Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format
- For Data Analysis learn about AND & OR criteria and Boolean and see how to:
Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUP
- See how to do 1 Condition Lookup Adding for both the VLOOKUP and HLOOKUP functio
Excel Magic Trick 685: Conditional Format For Alternative Rows
- See how to use the MOD and ROW functions for Conditionally Formatting Alternatin
Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!
- See how to use the SUMPRODUCT formula to calculate commission amounts based on v
Excel Magic Trick 692: More About Incrementing Numbers In Formulas
- See how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3
Excel Magic Trick 693: HOW Long To Double Your Money: NPER function or Rule of 72.
- See how to calculate how long it will take to double your money using the NPER f
Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Work
- Learn about how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If
Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Pennies
- See how to allocate $950 across 7 days including the extra penny with a single f
Excel Magic Trick 696: Identify First Occurrence In Column (5 methods)
- Create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occu
Excel Magic Trick 698: Extract Unique Items For Data Validation Drop-Down List
- See how to create an Expanding Data Validation Drop-down List from Table With Du
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
- Complex text extract formula that extracts text to use in VLOOKUP to lookup val
Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function
- See how to create a formula that will retrieve every other cell in a row as you
Excel Magic Trick 701: Take Table Of Values and Place In Column With Formula
- See how to place table of values in 1 column with INDEX function and Number Incr
Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells
- See how to lookup two values at once and return then both to:1. One Cell u
Excel Magic Trick 710: average with 3 Criteria Using PivotTable Pivot Table
- See how to : average with three Criteria Using PivotTable Pivot Table.
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter
- Comprehensive Video that shows how to extract records from a table covering thes
Excel Magic Trick 704: Analyzing Problem and Building Robust Solution.
- See how to analyze a problem and find all the possibilities that exist, then bui
Excel Magic Trick 705: Keyboard Shortcut for Finding Formula Dependents and Precedents
- See how to use:1. Ctrl + ] for dependent cells in a formula2. Ctrl +
Excel Magic Trick 706: Extract Number From Cell With A Time, A Dash and A Number
- See how to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a tex
Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic!
- See how to count the max number of items in succession in a column of data using
Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)
- See how to lookup and then add values with three criteria using 2 methods:
Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT
- See how to rank values based on one criteria using the SUMPRODUCT function. Anot
Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution
- See how to take transaction records with rows of numbers, math a single criteria
Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract
- See how to create an Excel solution that allows user to type in an area code and
Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text)
- See a formula to compare two list of numbers and see what happens (and how to so
Excel Magic Trick 720: Show Records Between 2 Dates: Filter, Logical Formula, Conditional Formatting
- See how to use Filter, Logical Formula (AND, TODAY and EDATE functions) and Cond
Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM
- See Mr Excel Message Board Barry Houdini's cool short formula trick to go fr
Excel Magic Trick 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF
- See how to use the SUMPRODUCT and COUNTIF functions together to count how many e
Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail
- Take bad data set up in one column and make a proper table of data for mail merg
Excel Finance Class 07: Stylistic Formatting
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Excel Magic Trick 715: Take Number with Spaces and Convert to Number
- See how to:1. Take a number with spaces, remove spaces and convert text to
Excel Magic Trick 716: Max of Absolute Values MAX & ABS functions Array Formula
- See how to find the Absolute Value Max of a set of integers (positive, zero and
Excel Magic Trick 717: List 2 Same Order as List 2? MATCH and ROWS functions
- See how to check to see if List 2 is in the same order as list 1 using the MATCH
Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch
- We have In Time & Out Time for either Day or Night Shift and we must subtrac
Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 03: Math Operators and Order of Operations
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Excel Magic Trick 723: COUNTIF Error With Workbook References, Use SUMPRODUCT Instead
- Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how
Excel Magic Trick 724: VLOOKUP Check If Quantities Are Equal In Two Lists Show Differences If Not
- Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how
Excel Magic Trick 725: Which Quartile Are You In? INPUT your Score, Formula Says Quartile You Are In
- Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htmLearn abou
Excel Magic Trick 726: Count 1 For Each Item in List 1 That Is In List 2 No Double Count for Dups
- Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how
Excel Finance Class 01: Intro To Excel 2007 & 2010
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 10: Income Statement, Non Cash Depreciation Expense, Matching Principal
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 11: Finance Cash Flow From Accounting Information
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 08: Intro To Corporate Financial Management
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Magic Trick 722: Calculate Gross Pay For Week From Time Values In Range & Hourly Wage
- Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how
Excel Magic Trick 732: SERIES Chart Function
- Download file: http://people.highline.edu/mgirvin/Learn about the SERIES C
Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell LOOKUP & SEARCH functions
- Download file: http://people.highline.edu/mgirvin/Learn how to lookup an i
Excel Magic Trick 728: COUNTIF & AND Functions Check Whether 3 Specific People Worked Together
- Download file: http://people.highline.edu/mgirvin/Learn how to check to se
Excel Magic Trick 727: Calculate Hours Worked Night or Day Shift With Break For Lunch
- Download file: http://people.highline.edu/mgirvin/Learn how to Calculate H
Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market Value
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 15: Common Sized Financial Statements
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 14: Financial Statement Ratio Analysis - #1 Trick For Ratio Analysis
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 13: Banks, Fundamental Problem With Banks, & The Big Short
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Magic Trick 731: Retrieve Cell Address Of Minimum Value In Column
- Download file: http://people.highline.edu/mgirvin/Create a Formula that wi
Excel Magic Trick 730: SUMIF with Approximate Criteria
- Download file: http://people.highline.edu/mgirvin/Learn how to use the SUM
Excel Finance Class 20: Growth Ratios and Market Value Ratios
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 19:Profitablility Rations: Return On Equity & Return On Assets & DuPont Analysis
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 18: Asset Efficiency Ratio and Cash Cycle In Days
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 17: Leverage & Solvency Ratios: Debt To Equity, Equity Multiplier, more...
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 16: Liquidity, Current Ratio and How Current Ratio Can Be Manipulated
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 22: Present Value Lump Sum Calculations and PV Function
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 23: Solve For Total Number Of Periods When You Know PV, FV and Period Rate
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 24: Solve For Period Rate & Annual Rate When You Know PV, FV and # of Periods
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 25: Future Value For Lender Or Borrower
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Mr Excel & excelisfun Trick 50: SUM Non - #N/A errors SUMIF or AGGREGATE?
- See Mr Excel and excelisfun create formulas to add a column of numbers and ignor
Excel Finance Class 43: Business Amortized Loans
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 44: Deep Discount Loans
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Mr Excel & excelisfun Trick 51: Extract Dates from Cell With Dates and Words
- See Mr Excel and excelisfun Extract Dates from Cell With Dates and Words using t
Excel Finance Class 18.5: Ratios For Cash Cycle In Days.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 21: Future Value Lump Sum Calculations, Simple & Compound Interest
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 38: Calculate APR and EAR Given Cash Flows From Annuity
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 41: Interest Only Loan Schedule.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 42: Consumer Amortized Loans
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 33: Full Life Retirement Plan PV Annuity & FV Annuity PV & PMT Functions
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 34: Present Value Of Annuity For Asset Valuation
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 35: Calculate PMT for Present Value of Annuity PMT Function for Loan Payment
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR with Points and RATE function
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 37: How Much Do I Get Each Month During Retirement?
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis and PV Function
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 29: Calculate Future Value Of An Annuity (FV Function)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 31: Calculate PMT for Future Value of Annuity (PMT Function)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 32: Calculate Present Value of Annuity (PV Function)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 55: Tax Advantage of Muni Bond
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmT
Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula?
- See Mr Excel and excelisfun lookup a value given two criteria. You will see thre
Excel Magic Trick 733: Expected Returns For Portfolio SUMPRODUCT & MMULT functions
- Download file: http://people.highline.edu/mgirvin/Learn how to create a ro
Excel Magic Trick 734: Downloaded Decimal (Percentage) Grades into Actual Integer Grades
- Download file: http://people.highline.edu/mgirvin/Learn how to use the Pas
Excel Finance Class 26: Multiple Cash Flow Valuation Future Value and Present Value FV PV Functions
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 50: Bond Rates Are Inversely Related To Bond Price (Scatter Diagram Excel Chart)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 51: Par - Discount - Premium Bonds
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 52: Bond Discount Or Premium Amortization Table.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 53: Bond Discount Or Premium Journal Entries
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 54: Bonds & Interest Rate Risk
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 45: Interest Rates: Real, Nominal, Inflation and the Fisher Effect
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 46: Bonds: Just Set Of Cash Flows Discounted At Market Rate, Coupon or Zero
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 47: Selling Bond When Coupon Rate Is Different Than Discount Rate (YTM Rate)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 48: Calculate YTM and Effective Annual Yield From Bond Cash Flows RATE & EFFECT
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 49: Bond Quoted Price & Yield To Market
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 67: Irregular Dividend Payments, Followed by Constant Growth -- Stock Valuation.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Mr Excel & excelisfun Trick 53: Extract State When Text String Has Varying Number of Commas
- See Mr Excel and excelisfun show how to do a VBA and an array formula method to
Excel Finance Class 58: After Tax Cash Flows & After Tax Interest Rates
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 56: Tax Implications For Zero Coupon Bonds.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 57: Compare Cash Flows For a Coupon & A Zero Coupon Bond
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmC
Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 63: Stock Valuation with Dividend Growth Model
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 64: Chart How Stock Value Changes for Dividend Growth Model as Inputs Change
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmC
Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmI
Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Items
- See Mr Excel and excelisfun create solution to do an approximate lookup to retur
Excel Finance Class 59: Common & Preferred Stock
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 60: Basics Of Financial Markets
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 73: Investment Criteria: Internal Rate Of Return IRR Function Plot Chart
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 74: IRR and Non-conventional Cash Flows, Plot Chart To See Multiple IRR
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 75: IRR and Mutually Exclusive Projects - Plot Chart To See Cross Over Rate
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 77: Investment Criteria: Profitability Index
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 78: NPV For Irregular Cash Flows and Time Periods XNPV, NPV and PV functions.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 68: Net Present Value, NPV Excel Function & Capital Budgeting
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 69: Net Present Value Profile -- Build Table and Chart in Excel NPV Function
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 70: Investment Criteria: Net Present Value
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 71: Investment Criteria: Payback Rule
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 72: Investment Criteria: Average Accounting Return
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 89: Sensitivity Analysis For Cash Flow & NPV Calculations
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 76: Investment Criteria: MIRR - Modified Internal Rate of Return
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Mr Excel & excelisfun Trick 55: Calculate Grade & Exclude Scores When Student Is Absent.
- See Mr Excel and excelisfun use SUMPRODUCT, ISNUMBER, and SUMIF functions to cal
Excel Magic Trick 735: Find Max Running Three Week Totals SUBTOTAL / OFFSET Array Formula
- Download file: http://people.highline.edu/mgirvin/Learn how create a formu
Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 84: Undoing Accrual Accounting to Discover Cash Flows For Estimating NPV
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 85: MACRS Depreciation & Asset Sale Impacts on NPV Cash Flows
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 86: Estimating Cash Flows For NPV calculation Comprehensive Example.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmC
Excel Finance Class 87: Cost Savings Example Estimating Cash Flows For NPV calculation
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmE
Excel Finance Class 88: Scenario Analysis For Cash Flow & NPV Calculations
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Magic Trick 739: Three Ways To Do Double Underline in Excel
- Download file: http://people.highline.edu/mgirvin/See Three Ways To Do Dou
Excel Finance Class 80: Recognizing Patterns of Cash Flows For Discounted Cash Flow Analysis
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 82: Relevant Costs For Discounted Cash Flow Analysis = Incremental Cash Flows
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm1
Excel Finance Class 83: Estimating Cash Flows For NPV calculation
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Magic Trick 691: Look At Cell C2 No Matter How Many Rows Or Columns You Insert Or Delete
- See how to use the INDEX or INDIRECT functions to create a formula that will alw
Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar
- Download file: http://people.highline.edu/mgirvin/Learn how to create a fo
Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem
- Download file: http://people.highline.edu/mgirvin/See what happens when a
Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment
- Download file: http://people.highline.edu/mgirvin/Learn how to use Goal Se
Plot F(x) Function & Chart In Excel - Gregory's Physics Class Acceleration of Block Up Down Ramp
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Excel Magic Trick 686: Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick
- See how to create a new column of values joining a value from the 1st column th
Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!
- Amazing use of the functions FREQUENCY, LARGE, ROW, INDIRECT to exclude values l
Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add
- See how to use the SUMPRODUCT, INDEX and MATCH functions to Lookup All Values In
Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo
- See 2 methods to quickly fill a column with the numbers 1 to 1000:Series M
Excel Finance Class 98: Stock Return Variation Measured with Standard Deviation (Risk of Stock)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills.
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Mr Excel & excelisfun Trick 56: Copy Formula Down, Have Range Move Across
- See Mr Excel and excelisfun create formulas that can be copied down across the r
Excel Finance Class 92: Period (Holding) Returns For Zero Bond
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 93: Period (Holding) Returns For Preferred Stock
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 95: Using Past Period Holding Returns to Estimate Future Returns Arithmetic Mean
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 96: Comparing Geometric Mean with Arithmetic Mean For Average Stock Returns
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Mr Excel & excelisfun Trick 57: Extract Many Years from Just Two Years
- See Mr Excel and excelisfun take the text string "1997-2000" and creat
Excel Finance Class 102: In The Short Run Financial Markets Can Be Inefficient Mispriced Assets
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmI
Excel Finance Class 90: Period (Holding) Returns For Stock
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 106: Unexpected Information, Market & Asset Specific Risk, Diversification, Beta
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 108: Reward To Risk Ratio - Treynor Index
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 109: Beta For Portfolio
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM)
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 111: Treynor Index & CAPM
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmC
Mr Excel & excelisfun Trick 58: Sorting Formula For Biggest Sales and Sales Rep Names with Ties
- See Mr Excel and excelisfun create formulas for sorting biggest to smallest (des
Excel Finance Class 107: Calculating Beta (2 Methods) & Chart Beta, SLOPE CORREL & STDEV functions
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmL
Excel Finance Class 103: 2 Ways To Calculate Geometric Mean
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmU
Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock -- Estimating Future
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio -- Estimating Future
- Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htmS
Excel Magic Trick 748: Count Weekends With No Events Scheduled Formula
- Download file: http://people.highline.edu/mgirvin/See how to Count Weekend
Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function
- Download file: http://people.highline.edu/mgirvin/See how to Add Yearly To
Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula
- Download file: http://people.highline.edu/mgirvin/See how to add Condition
Excel Magic Trick 751: Freeze Panes For Large Workbooks Freeze either a Row, Column, or Both
- Download file: http://people.highline.edu/mgirvin/See how to use Freeze Pa
Excel Magic Trick 752: Fill Column With Categories Using Approximate Lookup Formula
- Download file: http://people.highline.edu/mgirvin/See how to Fill Column W
Excel Magic Trick 743: Conditional Formatting To Match Items In List On A Different Sheet
- Download file: http://people.highline.edu/mgirvin/See how to add Condition
Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart
- Download file: http://people.highline.edu/mgirvin/See how to do Break Even
Excel Magic Trick 745: Allocating Indirect Expenses to Calculate Departmental Net Income Accounting
- Download file: http://people.highline.edu/mgirvin/See how to Allocate Allo
Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic
- Download file: http://people.highline.edu/mgirvin/For the Investment Crite
Excel Magic Trick 747: Expected Returns and Standard Deviation Single Cell Array Formula
- Download file: http://people.highline.edu/mgirvin/See how to create a sing
Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Method
- Download file: http://people.highline.edu/mgirvin/See how to Extract recor
Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Method
- Download file: http://people.highline.edu/mgirvin/See how to Extract Recor
Excel Magic Trick 740: Avoid Errors & Blanks In Chart Using Filter
- Download file: http://people.highline.edu/mgirvin/See how to use the Filte
Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Ranges
- Download file: http://people.highline.edu/mgirvin/See how to use Formulas
Excel Magic Trick 742: Wrap Text In Chart Label Using CHAR function and Code 10
- Download file: http://people.highline.edu/mgirvin/See how to Wrap Text In
Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets
- Download file: http://people.highline.edu/mgirvin/SUBTOTAL Function To &qu
Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
- Download file: http://people.highline.edu/mgirvin/Given that that each she
Mr Excel & excelisfun Trick 59: Custom Lists, Defined Names, PivotTable & COUNTIF Function
- See Mr Excel and excelisfun create Custom Lists, Defined Names, a PivotTable &am
Mr Excel & excelisfun Trick 58.5: Sorting Formula For Biggest Sales and Sales Rep Names with Ties
- See excelisfun create formulas for sorting biggest to smallest (descending) numb
Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO
- Download file: http://people.highline.edu/mgirvin/See how to use the Advan
Mr Excel & excelisfun Trick 60: Conditional Format High Blood Pressures -- 4 Methods
- See Mr Excel and excelisfun create conditional formatting 4 ways:1) Built-
Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee two d
Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmLearn abo
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods
- Download file: http://people.highline.edu/mgirvin/See 5 different formula
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
- Download file: http://people.highline.edu/mgirvin/Two Lookup Values and Tw
Office 2010 Class #05: Word Formatting, Insert Picture, Navigation, Selection Tricks, Backup Files
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #04: Introduction To Word, Ribbons, QAT, Non-Printing Characters, Clipboard & More
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #03: Creating System Of Folders For File Management Using Windows Explorer
- Learn how to Creating System Of Folders For File Management Using Windows Explor
Office 2010 Class #02: Using Windows Explorer For File Management
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #01: Windows Explorer and Introduction To Office 2010
- Learn about Using Windows Explorer to manage files and get an introduction to Of
Excel Magic Trick 760: OR AND AND Logical Test To Extract Data With Formula Or Advanced Filter
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Office 2010 Class #09 Word Research Paper Tricks Footnotes, Citations, Bibliographies, Styles, Find
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #08: Word Three Levels Of Formatting: Character, Paragraph, Section
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #07: Spell Check, Custom Dictionary -- Auto Correct For Spelling and Shorthand
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #06: Word Hyperlinks and Save As Web Page
- Download files: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn
Office 2010 Class #14: Word Print Preview and Print Dialog Box Are The Same
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #15: Word Business Letter & Letterhead
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #16: Word Style Tricks: Send Word To PowerPoint & Table Of Contents
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Mr Excel & excelisfun Trick 61: Formula To Report Cell Reference 5 Examples
- See Mr Excel and excelisfun create five formulas that can retrieve a cell refere
Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks.
- See how to use the excelisfun YouTube channel:1) Search For Videos
Office 2010 Class #11: Word Tabs: Left, Right, Center, Decimal, Bar
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #10: Word Tables & Paste Special Link Excel Table Into Word Document
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #12: Word Objects & Word Wrap
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #13: Word Theme affects Shapes, Tables, Smart Art, Numbered Lists and Styles
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #19: Excel Intro Project 02: Formulas, Charts, Page Setup Net Income
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Mr Excel & excelisfun Trick 64: Extract Records With Not Criteria VBA or Filter
- See Mr Excel and excelisfun Extract Records From A Data Set With Not Criteria VB
Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets
- See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup Fro
Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formula
- See Mr Excel & excelisfun Conditional Format a Chart:1) Excel 20
Office 2010 Class #17: How To PowerPoint Tricks
- 1) Open PowerPoint2) Save As with Name "My2ndPP" in PowerPoint C
Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #18: Excel Intro Project 01: Data, Formatting, Formulas, Page Setup
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #32: Excel Percentage Number Format (6 Examples)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #35: Excel Sort and Filter (Data Analysis)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #28: Excel Number Formatting: Formatting As Façade
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #29: Excel ROUND Function How And When To Use It.
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF
- The Excel 2010 Basics Series shows a systematic description of what Excel can do
Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
- The Excel 2010 Basics Series shows a systematic description of what Excel can do
Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Mr Excel & excelisfun Trick 68: Count Dates in Column That Match Year and Month Criteria
- See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Crit
Mr Excel & excelisfun Trick 67: Extract Initials From Full Name: VBA or Formula?
- See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a For
Mr Excel & excelisfun Trick 66: Slaying Excel Dragons E-Book Available at Mr Excel Web Site!
- E-book available at: http://www.mrexcel.com/store/index.phpSee Mr Ex
Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #41: Introduction to Databases and Access
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Mr Excel & excelisfun Trick 69: Count Saturdays
- See Mr Excel and excelisfun create formulas to count Saturdays from a start date
Slaying Excel Dragon Book Is Out In Print! Also: Cool Excel MONTH Function Trick.
- Finally!!! The Slaying Excel Dragon book is out in print! You can get it at your
Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Office 2010 Class #45: Creating Queries In Access (16 Examples)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Office 2010 Class #44: Access Create Forms (User Interface), Enter Data Tricks
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #43: Access One To Many Relationship Between Tables
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #42: Access Create Database, Import Table, Create Table, Data Validation For Table
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...
- See how to use the excelisfun YouTube channel:1) Search For Videos
Excel Magic Trick 765: Formula To Sort Top 3, Including Ties
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Office 2010 Class #47: Export Data From Access To Excel, PDF or Text File
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #46: Access Create Report Based On A Query
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class 50: Word Letter Mail Merge w Excel Data (Number Format Problem TEXT function Fix)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #51: Word E-Mail Mail Merge from Data In an Access Database
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List
- See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Item
Excel Magic Trick 767: Count Months from Start and End Date
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmFormula t
Excel Magic Trick 766: Count Times Before And After A Stated Time.
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Mr Excel & excelisfun Trick 71: ROUND to 4 or 2 Formula or Conditional Formatting?
- See Mr Excel and excelisfun round numbers to 2 if the column says "DOLLAR&q
Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how a
Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Office 2010 Class #48: Import Excel Data Into Access & Compare & Contrast Formulas in Access & Excel
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Office 2010 Class #49: Word Letter Mail Merge w Excel Data (Number Format Problem & Field Code Fix)
- Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/b
Excel Magic Trick 772: Remove Spaces From Number and Convert To Number
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Excel Magic Trick 771: Calculate Your "Current" Grade: SUMIF, SUM & VLOOKUP functions
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Mr Excel & excelisfun Trick 72: Data Bar Cell Charts in Excel 2007/2010 & Excel 2003
- See Mr Excel and excelisfun create Data Bar Cell Charts in Excel 2007/2010 using
Add Dot Com To End Of Column Of Words Excel Formula, Copy, Paste Special Values
- Add Dot Com To End Of Column Of Words:1) Excel Formula with Ampersan
Excel Magic Trick 776: Slaying Excel Dragon DVD Out! & RANK From More Than One Column Trick
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how
Mr Excel & excelisfun Trick 73: Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions
- See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE,
Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmSee how t
Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmGreat tri
Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmA great t
Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)
- Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm1.
Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?
- See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation
Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Feature
- See Mr Excel and excelisfun use the Excel Table Feature to create dynamic ranges