Tag Archives: business
Excel Macro Example Case Study
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
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
Microsoft Excel Overview for Beginners Tutorial – Excel 2003, 2007, 2010
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
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
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
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
Dueling Excel – Dynamic Validation VLOOKUP: #1379
Today’s Dueling Podcast asks: “Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?” In Episode #1379, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen look at using Table Nomenclature in Validation and in VLOOKUP. Duration : … Continue reading
Posted in Learn Excel Formulas
Tagged accounting, business, Data Validation List, excel, MrExcel, spreadsheets, table, technology, tutorial, validation, vlookup
3 Comments
