Tag Archives: data
Excel VBA tutorial 28 GetSaveAsFilename.flv
How to open up a saveas dialog box Duration : 0:8:50 Technorati Tags: business, computer, customer, data, design, excel, information, Macro, management, none, office, software, solutions, system, Systems, technology, training, tutorial, using, vba
Posted in Learn Excel Macros
Tagged business, computer, customer, data, design, excel, information, Macro, management, none, office, software, solutions, system, Systems, technology, training, tutorial, using, vba
Leave a comment
Excel VBA tutorial 15 Do Until loops and finding the end of data.flv
Do until loops and copying data from one sheet to another. Please check out my other Videos by clicking on my channel and subscribe to future tutorials! Duration : 0:12:21 Technorati Tags: beginner, computer, data, excel, Help, Macro, management, Microsoft, … Continue reading
Posted in Learn Excel Macros
Tagged beginner, computer, data, excel, Help, Macro, management, Microsoft, office, programming, software, system, technology, tutorial, vba, visual basic
7 Comments
How to Use Excel Functions & Formulas to Analyze Inventory for a Retail Store
Continuing in my series of Excel Tutorials for analyzing the year-end inventory of I retail store, I demonstrate how to use Excel Functions and Formulas. In this case, using just three “hard coded” numbers (Sales, Cost of Goods Sold and … Continue reading
Posted in Learn Excel Formulas
Tagged business, computer, data, information, Inventory, management, Microsoft Excel, Microsoft Office, office, software, system, technology, training
Leave a comment
How to Apply Named Cell Ranges to Existing Excel Formulas
I am a proponent of creating Named Cell Ranges and then using them in your Excel Formulas. However, what if you have existing formulas that use cell references and NOW you wish to create and apply Named Cell Ranges? In … Continue reading
Posted in Learn Excel Formulas
Tagged business, data, how to, information, management, Microsoft Excel, office, software, technology, training
6 Comments
How to Create Named Ranges to Use in Excel Formulas
In my opinion, there are three main reasons to use Named Ranges in Excel Formulas: 1) They are easier to write – especially when range of cells is large 2) They are easier to remember – e.g. Gross Profit = … Continue reading
Posted in Learn Excel Formulas
Tagged business, data, information, management, Microsoft Excel, Microsoft Office, office, software, technology, training
Leave a comment
How to Use Criteria in Excel Filters and Functions
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
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
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 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
