Highline Excel Class 02: Excel Formulas & Excel Functions
Learn about: 1) The different elements of formulas: equal sign, cell references, math operators, comparative operators, built-in functions, ampersand, numbers 2) See the five methods for entering formulas: Enter. Ctrl + Enter, Tab, Shift Tab, Shift Enter 3) Order Of Excel Formula Evaluation 4) Bu...
Highline Excel Class 01: Back To Basics
Learn about: How Excel is setup Ribbons Quick Access Toolbar QAT Scroll Bars Numbers and Text Keyboard shortcuts This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase
See how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a Percentage Increase Formula. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Excel Training
www.ExcelTrainingDVD.com Excel Training for beginner, intermediate and advanced users of Microsoft Excel accounting and business software. http Please note that Microsoft Excel is a trademark of Microsoft Corp. This MS Excel Training is not associated with Microsoft in any way.
Highline Excel Class 25: Fix Problems & Errors In Spreadsheet
Learn about: 1.Nine errors & what they mean and how to fix them: ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, #NULL! 2.AVERAGE function will include zero in calculation, but not blanks 3.Go To Special Blanks 4.Ctrl Enter to add numbers to many cells instantly 5.SUM func...
Highline Excel Class 17: Filter, Filtering 8 Examples
See these 8 Filtering Examples: 1. Keyboard shortcut: Ctrl + Shift + L 2. See that Filtering hides rows whereas, sorting does not hide rows 3. Filter by Color 4. Checkboxes to show and hide certain items 5. Amazing new Date Filters in the field is filled with Dates 6. Amazing new Text Filters in ...
Highline Excel Class 07: VLOOKUP function formula 7 Examples
Learn about: 1)VLOOKUP to lookup an exact match 2)VLOOKUP to lookup an approximate match 3)VLOOKUP can return a value to a cell 4)VLOOKUP can return a value to a formula 5)VLOOKUP can lookup values on a different sheet (Name table and use name in VLOOKUP function) 6)Use VLOOKUP to return values f...
Highline Excel Class 52: Recorded Macro Basics
Learn about: 1.How to Record a Macro 2.Macro = VBA code 3.Macros are great for repetitive tasks 4.What file extension to use for Excel 2007: .xlsm 5.How to show Developer Ribbon in Excel 2007 6.Relative and Absolute References in Excel Macros 7.Paste Special Values Absolute Macro 8.Paste Special ...
excelisfun- Length: 24:59
- Views: 32126
- Tags: Excel Recorded Macro Basics Relative Absolute References excelisfun Mike Gel Girvin Highline Community College
-
Highline Excel Class 18: Subtotals
See these 5 Subtotal examples: 1. Basics of the Subtotal Feature including Sorting before Subtotaling 2. Adding two Subtotals 3. Adding Subtotals with the SUM function 4. Adding Subtotals with the AVERAGE, COUNT AND MAX FUNCTIONS 5. See how to copy and paste subtotals with the keyboard shortcut f...
Highline Excel Class 35: IF Function Vs. VLOOKUP Function
Topics for this video: 1)See an efficient IF function formula get beat by an even more efficient VLOOKUP function formula 2)See how to build the most efficient IF function formula when there are mutually exclusive categories: Always start at top and move toward bottom, or always start at bottom a...
Highline Excel Class 04: Style & Number Format & ROUND
Learn about: Style Formatting Number Formatting (Date, Time, Currency, Accounting) ROUND function This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Highline Excel Class 21: Conditional Formatting 12 Examples
See how to add conditional formatting for: 1)Data Bars to show relative size 2)Icons to show relative size 3)Highlight values within 1 standard deviation 4)Highlight MIN in column with a TRUE FALSE formula 5)Highlight MAX in column with a TRUE FALSE formula 6)Highlight two largest values with a T...
- excelisfun
- Length: 18:23
- Views: 35304
- Tags: Excel Conditional Formatting Format TRUE FALSE formulas more than one excelisfun Mike Gel Girvin Highline Community Coll
-
Highline Excel Class 13: Text functions & AMPERSAND
See how to transform data into useful data using formulas and Text functions such as; TRIM, PROPER, SUBSTITUTE, REPLACE, FIND, and LEFT. See how to use the ampersand and the CONCATENATE function to join data. See how to speed up slow calculating spreadsheets with a concatenated column that joins ...
Highline Excel Class 53: Relative & Absolute Macro Recorder
Learn about: 1.Relative & Absolute button in the Developer Ribbon 2.The fact that the Relative & Absolute button governs selection movement when recording a Macro 3.The fact that the cell references in Formulas created during a Recorded Macro are governed by the dollar signs 4.When to record an A...
Highline Excel Class 06: Worksheet & Workbook References
Learn how to create worksheet and workbook references in formulas. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Highline Excel Class 36: Array Formulas Basics
Topics for this video: 1)Learn about the basics of array formulas 2)Entering array formulas with Ctrl + Shift + Enter 3)Array syntax 4)Operations on ranges and arrays instead of cells or individual values 5)Create array formulas in single cells and save space in spreadsheet 6)Array formula for To...
- excelisfun
- Length: 31:35
- Views: 19939
- Tags: Excel Array Formulas Syntax same different dimensions SUMPRODUCT excelisfun Mike Gel Girvin Highline Community College
-
Page: 1 of 364
