Tag Archives: excel

Learn Excel in Marathi How to use If Condition in Microsoft Excel 2007

Learn Excel in Marathi How to use If Condition in Microsoft Excel 2007 Marathi Computer Training Without a Teacher Teach Computer Learn Computer using Software self study Duration : 0:9:11 Technorati Tags: 2007, banking, Basic, Booking, Bus, computer, Condition, excel, … Continue reading

Posted in Learn Basic Excel | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , | 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 , , , , , , , , , , , , , , , , , , | Leave a comment

Use named cell references in your Excel formulas

Do you find it difficult to interpret a formula that you wrote in last year’s spreadsheet? Can you easily explain your formulas to a colleague, client or to your boss? This is a common proble. Learn how to use named … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , | Leave a comment

Excel 2007 – Create Basic Inventory System using Form and Formula

How to create a basic inventory system using Form and Formula Duration : 0:1:40 Technorati Tags: excel, Macro, Pivot Table, SumIF, vba, visual basic, vlookup

Posted in Learn Basic Excel | Tagged , , , , , , | 16 Comments

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

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , | 15 Comments

How to Enable Macros in Excel 2007

as per title Duration : 0:0:31 Technorati Tags: Enable, excel, Macro

Posted in Learn Excel Macros | Tagged , , | 1 Comment

Excel VBA tutorial 4 Using Integer Variables to perform calculations

An introduction to variables and how to use them in calculations. Also introduces the “With” keyword Duration : 0:9:37 Technorati Tags: begginer, cheats, computers, Computing, crafts, discussion, downloads, electronics, excel, financial, howto, increment, instruction, integer, Macro, management, programming, programs, self … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , | 4 Comments

Excel Formulas

Hi Guys, First video of the new year. In this video I will be showing you how to use simple formulas in Excel. —– PLEASE DON’T FORGET TO: – LIKE, COMMENT & SUBSCRIBE!!! THANKS —– This video is for Educational … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , | Leave a comment

How to use macros to count rows columns for Microsoft Excel 2007

http://www.officehelpontap.com Get the Worlds most advanced integrated Office Help solution today. Download NOW FREE 12 Mth License – Playback thousands of video clips inside your Excel application Duration : 0:1:18 Technorati Tags: 2007 excel, 2007 help, 2007 microsoft, excel, help … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , | Leave a comment