Tag Archives: data

How to Use Criteria in Excel Filters and Functions

Posted on February 9, 2012 by admin

In this tutorial, I demonstrate how to use the “Logical Functions” of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Function, each logical test must answer TRUE. I frequently “Nest” the AND … Continue reading →

Posted in Learn Excel Formulas | Tagged Advanced, business, criteria, data, excel, filter, filtering, for, functions, in, information, lesson, Logical, management, office, software, technology, training, tutorial | Leave a comment

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Posted on February 7, 2012 by admin

Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to return all the numbers from a column that contains text and numbers. See an array formula that uses the functions: COUNT, IF, ROWS, INDEX, ISNUMBER, … Continue reading →

Posted in Learn Excel Formulas | Tagged 2, All, College, Community, data, excel, excelisfun, Extract, formula, functions, Gel, Girvin, Highline, INDEX, item, items, Lookup, Many, match, Mike, numbers, one, Return, to | 15 Comments

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Posted on February 3, 2012 by admin

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. … Continue reading →

Posted in Learn Excel Formulas | Tagged -1, College, Community, criteria, data, excel, excelisfun, Extract, extraction, for, formula, functions, Gel, Girvin, Highline, INDEX, item, items, Lookup, Many, match, Mike, one, Return, the, Two | 25 Comments

Excel VBA tutorial 30 Userforms Pictures and RGB Values.flv

Posted on February 2, 2012 by admin

Excel VBA tutorial 30 Userforms Pictures and RGB Values Showing how to add a bit of style to your userforms. Duration : 0:13:58 Technorati Tags: Access, Basic, business, colour, computer, customer, data, design, excel, Guide, Help, information, Macro, management, Microsoft, … Continue reading →

Posted in Learn Excel Macros | Tagged Access, Basic, business, colour, computer, customer, data, design, excel, Guide, Help, information, Macro, management, Microsoft, office, pics, Picture, programming, rgb, security, slideshow, software, Software Tutorial, solutions, system, Systems, technology, training, Userform, using, vba, video, Visual | 4 Comments

Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting

Posted on December 23, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Learn about Proportions, Probabilities and Percentages: Formulas and Formatting. 2. See the COUNTIF function and Relative and Absolute Cell References for counting with 1 criteria 3. See how to create a Basic Frequency Table with Qualitative … Continue reading →

Posted in Learn Basic Excel | Tagged 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with | 4 Comments

Excel Formatting 101 for Mac

Posted on December 22, 2011 by admin

Learn basic tips for making your data look sexy using Excel for Macs! This tutorial includes how to format as a table, format cells, remove gridlines, and use text and number filters. Duration : 0:10:19 Technorati Tags: analytics, data, excel, … Continue reading →

Posted in Learn Basic Excel | Tagged analytics, data, excel, how to, mac, Microsoft Office, spreadsheets, tips, tutorial | 1 Comment

Refer to an Excel Table Field When Writing Formulas

Posted on December 12, 2011 by admin

If you are using either Excel 2007 or Excel 2010, I encourage you to “format your data range” as an Excel Table. When you do this you can take advantage of several Table Tools: 1) The range references for the … Continue reading →

Posted in Learn Excel Formulas | Tagged business, cell, data, Educational, excel, formulas, functions, in, information, management, Microsoft Excel, Microsoft Office, named, office, range, software, Software Tutorial, tables, technology, training, tutorial | 2 Comments

Use the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Report

Posted on December 10, 2011 by admin

Watch, as I use both the SUMIF and the (new) SUMIFS functions to analyze an Accounts Receivable Status Report. With the SumIf Function in Excel, you only sum the cells in a range that match the condition that you set. … Continue reading →

Posted in Learn Excel Formulas | Tagged analysis, business, computer software, computers, data, economic, Educational, excel functions, finance, financial, Help, how to, information, instructions, management, Microsoft Excel, New in Excel 2007, office, programs, software, Software Tutorial, SUMIFS Function, Systems, technology, tips, training, tutorial | 4 Comments

How to Work with Array Formulas in Excel

Posted on December 8, 2011 by admin

With an Array Formula, you can frequently create formulas quicker because you can eliminate several intermediate calculations. I begin my introduction to Array Formulas by showing you how to use the SUMPRODUCT Function. Next, I show you two examples of … Continue reading →

Posted in Learn Excel Formulas | Tagged array formulas, business, CSE Formulas in Excel, data, excel, Formula Error Messages, information, management, mobile device, office, software, Software Tutorial, SUMPRODUCT Function, technology, training, work | 2 Comments

Excel Automation From MS Access Using VBA – Showing formating, charting and trends

Posted on November 26, 2011 by admin

I am available for consulting. Call 510-473-2492 10 am to 10 pm Pacific time or eMail via YouTube for more details. This example uses MS Access to launch Excel, create a workbook, add worksheets, format worksheets, write data and add … Continue reading →

Posted in Learn Excel Macros | Tagged 2000, 2007, Access, analysis, automation, call, Center, Chart, charting, charts, data, database, DB, excel, Microsoft, ms, office, OLE, spreadsheet, trending, vba, xp | 6 Comments