Excel-magic-tricks-series

excel-magic-tricks-series




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 ROWS functions to repeat list of names 7 times. See how to increment ...
Read more




Excel Magic Tricks # 1: Formulas & Cell References

Download Excel workbook: http://people.highline.edu/mgirvin/excelisfun.htm See Excel Magic! See how to build your spreadsheet smartly, so it updates ...
Read more




Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records

Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract ...
Read more




Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a VLOOKUP to a different Sheet using: 1. Sheet References 2. Defined ...
Read more




Excel 2013 Video 12 Top Excel Tricks Series The Powerfull Camera Tool

I have a PHD in Economy, many years of experience in Accounting, Taxes declarations for Individual and Corporations, Balance Sheet Preparation, Financial ...
Read more




Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Download file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT778.xlsx There are really about 30 example in this long video. INDEX and MATCH ...
Read more




Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like "Monday" 3. TEXT Function to get ...
Read more




Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria

See methods for counting: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an ...
Read more




Excel Magic Trick 848: Create List of Dates For Month With Formula

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. Given the month as text and the year as a number, see how to get the first of ...
Read more




Excel Magic Trick 1258: Add Spaces Between Digits: Custom Number Format & TEXT Function

Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to use Custom Number Format in Excel to display numbers with spaces and to ...
Read more




Excel Magic Trick 1501: INDIRECT Function: Pull Data from Different Sheet Based on Row Number

Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1501-1502.xlsx Entire page with all Excel Files for All Videos: ...
Read more




Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using Data ...
Read more




Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting

Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm In this video learn about how to build Excel Dashboard based on ...
Read more




Excel Magic Trick 1052: Best New Feature In Excel 2013: Recommended Charts & PivotTables

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Mind-blowing awesomeness: 1. Recommended Charts & PivotTables take transaction ...
Read more




Excel Magic Trick #202: Calculate Vacation Days

Create a formula that calculates the number of vacation days an employee gets based on hire date using the functions TODAY, YEAR and IF functions.
Read more




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 ROWS function. If you dont want to use TRANSPOSE function, this is a ...
Read more




Excel Magic Trick 1501 Pt 02: INDIRECT Lookup Items From Different Sheets Based on Row Number

Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1501-1502.xlsx Entire page with all Excel Files for All Videos: ...
Read more




Excel Magic Trick 519: SUBSTITUTE & REPLACE Functions

See how to REPLACE requires a starting position in the text string and the number of characters from the start position and it will replace those characters.
Read more




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 TRICKS: 1)See how to Freeze Panes for Large Spreadsheet 2)Ctrl + 1 to ...
Read more




Excel Magic Trick 1380: Slicer Power Query Report To Show Incomplete Student Assignments

Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to extract the incomplete student assignments from a cross tabulated table using ...
Read more




Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See how to do a three way lookup when there are two row header variables (criteria) and ...
Read more




Doughnut Chart Excel | Excel Advanced Charting Techniques|Excel Chart Tricks|Excel Magic Trick Chart

About Doughnut Chart Excel | Excel Advanced Charting Techniques|Excel Chart Tricks|Excel Magic Trick Chart: In this video I have discussed following: 1 How ...
Read more




Excel Magic Trick 1491: “Lookup Latest Product Price” Survey Results, Winner of Free Book

Survey Results for “Lookup Latest Product Price” Winner of Free Book Other Related Videos: Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct ...
Read more




Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard

Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn About: 1. Keyboard shortcuts to select columns of data 2. Clipboard to copy multiple ...
Read more