Tag Archives: business
MrExcel’s Learn Excel #695 – Scale Selection
In today’s podcast, a five line macro that will allow you to scale a selected range. This macro was inspired by engineers in one of my recent VBA seminars. They had been using a similar tool for years and we … Continue reading
Posted in Learn Basic Excel
Tagged accounting, business, excel, Macro, MrExcel, Scale Numbers, spreadsheets, technology, tutorial, vba
Leave a comment
Lotto Probability – 454 – Learn Excel from MrExcel Podcast
Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula … Continue reading
Posted in Learn Basic Excel
Tagged accounting, Array Formula, business, excel, MrExcel, spreadsheets, technology, tutorial
2 Comments
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
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
Learn Excel – Chart Title, Legend, Colors: Podcast #1408
The Basics of Excel Charting: Part IV This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we’d set up our Data Set, Created our Chart and made adjustments to … Continue reading
Posted in Learn Basic Excel
Tagged accounting, Bill Jelen, business, charting, charts, excel, Excel2010, Learn Excel, MrExcel, spreadsheet, technology, tutorial, workbook
2 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
Learn Excel 2010 — “Saving Form to Database”: Podcast #1504
John from New Zealand offers an improvement to Thursday’s podcast about creating a Data Entry form on a spreadsheet. Today, in Episode #1504, Bill applies the tip from John to improve the VBA code for this Database Form routine! …This … Continue reading
Posted in Learn Basic Excel
Tagged accounting, Bill Jelen, business, data entry, database, excel, Macro, MrExcel, shortcuts, spreadsheets, technology, tutorial, vba, visual basic for applications, worksheet
1 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
