## Excel Array Formula Examples, Use CTRL + SHIFT + ENTER, Advanced Ms Excel Tips and Tricks 2019

About this tutorial: Video duration: 6:58 What is an Array in Excel? Learn the Use of Ms Excel Array Formula With Examples, Use CTRL + SHIFT + ENTER, Advanced MS Excel 2019 Tips and Tricks. Advance Excel Essentials training series. In this Tutorial. Learn Array Functions and When to Use them. This Advance excel Formulas […]

## Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions

About this tutorial: Video duration: 3:11 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 good substitute.

## Advance Excel Online Training Classes Day-1 Basic Knowledge

About this tutorial: Video duration: 27:52 A K SOFTWARES AND SERVICES 43/1, 1ST FLOOR, MAIN EAST AZAD NAGAR, KRISHNA NAGAR, DELHI-110051 Mob – 9310221060, 8750221060, 9136018988, Phone – 011-22007066-22005052 E-mail- aksoftware01@gmail.com Wabsite – www.busyak.in

## BUSY 3

About this tutorial: Video duration: 21:32 A K SOFTWARES AND SERVICES 43/1, 1ST FLOOR, MAIN EAST AZAD NAGAR, KRISHNA NAGAR, DELHI-110051 Mob – 9310221060, 8750221060, 9136018988, Phone – 011-22007066-22005052 E-mail- aksoftware01@gmail.com Wabsite – www.busyak.in

## Excel VBA Introduction Part 50.3 – Conditional Formatting by Value in Charts

About this tutorial: Video duration: 14:19 By Andrew Gould – Looping over the points of a chart and testing the value of each should be a simple task in Excel VBA but it’s slightly trickier than you might expect! This video explains how to access the values array of a series, how to loop through […]

## Excel – Plotting Multiple Lines on One Plot

About this tutorial: Video duration: 4:54 Many more great Excel tutorials linked below: Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques and many useful and practical ones. Be sure to Subscribe and Comment. Incoming search terms:excel – plotting multiple lines on one plotexcel plot multiple linesexcel plotting […]

## Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula

About this tutorial: Video duration: 8:10 See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula. Link for file:

## Return Multiple Items with One Lookup Value

About this tutorial: Video duration: 9:41 Check out my Blog: How to lookup one value and return multiple values associated with it. This is an array function that needs to be entered with the keyboard combination CTRL+SHIFT+ENTER, which essentially enters it as an array formula.

## C# Introduction Part 9 – While Loops and Do Loops

About this tutorial: Video duration: 47:19 If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos you can click this link to make a donation. Thanks for watching! By Andrew Gould – A While Loop in C# allows your code to repeat a set of instructions while a […]

## Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results

About this tutorial: Video duration: 16:2 Download workbook: See how to create an immediate filter governed from criteria entered into cells that shows all records when no criteria is entered in cells, but filters the data when criteria is entered. Enter Exact or Partial Criteria. Also see how to create Dependent Data Validation List and […]

## Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes

About this tutorial: Video duration: 5:12 See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new Excel 2007 function. Also see Mr Excel use Fine and Replace to complete two amazing […]

## Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function

About this tutorial: Video duration: 11:16 Download file: 1. Multiple Two Way Lookup Adding using INDIRECT, ADDRESS and ARRAY MATCH Function as well as SUMPRODUCT, SUM and N functions 2. Amazing trick from circlechicken at Mr Excel Message Board 3. Information for multiple accounts and departments from a Trial Balance Accounting Report used as criteria […]

## Excel Array Formula Series #2: TRANSPOSE function

About this tutorial: Video duration: 2:14 See how to use the Array function TRANSPOSE to transpose a table, switching rows and columns to columns and rows. In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that […]

## Connect to MS SQL Server Using ODBC From MS Access

About this tutorial: Video duration: 4:17 A short tutorial video on how to configure your ODBC connection and create connection data source to MS SQL Server database in MS Access. Please subscribe as I’ll be posting more videos weekly! For any question, please email me at JJYouTubeChannel@Outlook.com

## Excel Magic Trick 364: Return First Non-Blank (Array Formula)

About this tutorial: Video duration: 4:31 Array formula for returning cell content from first non-blank cell in a row that uses INDEX, MATCH and the not comparative operator and the symbol for blank (double quotes). Formula from Aladin from Mr Excel Message Board.

## Excel Magic Trick #111: Build A Questionnaire

About this tutorial: Video duration: 8:2 See how to put the IF function inside a VLOOKUP function, add Data Validation, use an Array formula, unlock cells and protect the sheet all in order to create a Questionnaire form that automatically tallies the score. Protection Lock cells Unlock Cells Protect. Incoming search terms:Excel Magic Trick #111: […]

## Excel 2010 Magic Trick 796: Excel Flip Table Rotate Table TRANSPOSE or INDEX or Paste Special

About this tutorial: Video duration: 8:5 Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Rotate Table: 1. See how to rotate a table 90 degrees using the array function TRANSPOSE 2. Flip table 90 degrees with Formula with INDEX and ROWS and COLUMNS 3. Paste Special Transpose. 4. Keyboard shortcuts for Paste Special 5. Flip table 180 degrees with Formula […]

## Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula

About this tutorial: Video duration: 1:51 See how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula. Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

## Excel Magic Trick 608: Array Formula To Return Multiple Items – List Students With Free Periods

About this tutorial: Video duration: 11:6 See a formula that can lookup and return all the student names based on the blanks in a different column using the functions COUNTIF, IF, ROWS, INDEX, SMALL, ROW and an array formula. Also see: Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for […]