Tag Archives: business

Learn Excel 2010 — “Saving Form to Database”: Podcast #1504

Posted on February 10, 2012 by admin

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

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 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 Macro Example Case Study

Posted on February 1, 2012 by admin

A case study on two Excel macros. Macros cure tedious, error prone and inefficient computer work. Duration : 0:3:49 Technorati Tags: Automate, automation, business, data formatting, database management, estimate, excel, excel help, Excel macro, excel macro help, excel macro tips, … Continue reading →

Posted in Learn Excel Macros | Tagged Automate, automation, business, data formatting, database management, estimate, excel, excel help, Excel macro, excel macro help, excel macro tips, excel tips, Formatting, Help, how to, Macro, Macro (computer Science), procurement, routine, save time, supply chain management, tedious, tips, vba, write, write excel macros | Leave a comment

How to Use the VLOOKUP Function in Excel

Posted on January 19, 2012 by admin

I receive numerous questions about how to use the VLOOKUP Function in Excel. So, I created this video to show you the step-by-step process to create them and to share my best practices for using VLOOKUPs. I invite you to … Continue reading →

Posted in Learn Excel Formulas | Tagged array, Array Data Structure, business, computer software, Educational, exact, Excel Look up Functions, how to, information, Lessons, management, match, office, Software Tutorial, technology, training, tutorial, vlookup | 2 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

Microsoft Excel Overview for Beginners Tutorial – Excel 2003, 2007, 2010

Posted on December 22, 2011 by admin

This tutorial is a brief overview of Microsoft Excel and a few of its basic functionalities. This video is intended for people that know a little about computers but are just trying to get their hands into Excel or any … Continue reading →

Posted in Learn Basic Excel | Tagged Advanced, advice, Basic, Basics, beginner, Beginners, business, easy, Free, Help, hints, howto, ideas, information, instruction, learn, Lessons, management, mobile device, need, need help, needs, please, please help, Quick, secrets, software, Software Tutorial, techniques, tips, tricks, tutorial, use, your | 2 Comments

Learn Excel – Macro to Find: Podcast #1382

Posted on December 16, 2011 by admin

Mike is looking for a faster way to Find. He wants to enter his search term in a Named Cell and have a Macro that will search for that term. Today, in Episode #1382, Bill shows us how to Record … Continue reading →

Posted in Learn Excel Macros | Tagged accounting, business, Change a Recorded Macro, excel, find, Macro, MrExcel, record a macro, spreadsheets, technology, tutorial, vba | 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