Archive for October, 2011
Monday, October 31st, 2011
Excel Video 68 shows how to nest functions, or put a function inside another function, in Excel. VLOOKUP is a powerful function, but it is even more powerful if you can combine other Excel functions inside VLOOKUP. In Video 68, we have a table of patients and ICD-9 codes and a table that categorizes the ICD-9 codes into groups. Rather than list each ICD-9 code in the grouping table, it’s much more efficient to group the diagnosis codes by the first three digits of the code.
We’ll use the LEFT function to capture the first three digits in the patient list, then combine LEFT with VLOOKUP to only look for the first three digits of the diagnosis code in the grouping table. By only looking for the first three digits, our grouping table is much smaller and more efficient than having to list every potential diagnosis code in the grouping table. This trick will only become more efficient with ICD-10.
Try using other Excel functions, like RIGHT to get the last digit of an E&M code, to make VLOOKUP more powerful for you. Stay tuned. Next time we’ll use VLOOKUP inside VLOOKUP to lookup two things at once.
Duration : 0:3:27
(more…)
Technorati Tags: Excel 2007, Microsoft Excel, vlookup
Tags: Excel 2007, Microsoft Excel, vlookup
Posted in Learn Excel Formulas | No Comments »
Monday, October 31st, 2011
Visit MotionTraining at http://www.motiontrainingweb.com
Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel.
Duration : 0:8:39
(more…)
Technorati Tags: Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, tips, tricks, tutorial
Tags: Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, tips, tricks, tutorial
Posted in Learn Excel Formulas | 25 Comments »
Friday, October 28th, 2011
MORE AT http://599CD.com/XYT2010 – We’ll learn how to add multiple cells, use the mouse to build our formulas, work with the status bar, calculate an average, and we’ll learn about the all-important Order of Operations. Complete Excel 2010 training package, lessons, online seminar.
Duration : 0:5:44
(more…)
Technorati Tags: AVERAGE, bar, excel, Excel 2010, excel 2010 Tutorial, excel classes, excel course, excel for beginners, excel for dummies, excel help, excel lessons, excel seminar, Excel training, excel tutor, Excel Tutorial, excel videos, Microsoft Excel, microsoft excel 2010 tutorial, microsoft excel tutorial, of, operations, Order, status, SUM
Tags: AVERAGE, bar, excel, Excel 2010, excel 2010 Tutorial, excel classes, excel course, excel for beginners, excel for dummies, excel help, excel lessons, excel seminar, Excel training, excel tutor, Excel Tutorial, excel videos, Microsoft Excel, microsoft excel 2010 tutorial, microsoft excel tutorial, of, operations, Order, status, SUM
Posted in Learn Basic Excel | No Comments »
Friday, October 28th, 2011
ExcelTutorialshttp://gdata.youtube.com/feeds/api/users/exceltutorialsEducationdemo, vba, macros, excel, spreadsheets, chandoo.org, tutorials, educationDemo of Our Sales Tracker VBA Application – Excel VBA Crash Cours from Chandoo.org
Duration : 0:3:46
(more…)
Technorati Tags: chandoo.org, demo, education, excel, macros, spreadsheets, tutorials, vba
Tags: chandoo.org, demo, education, excel, macros, spreadsheets, tutorials, vba
Posted in Learn Excel Macros | No Comments »
Friday, October 28th, 2011
Study this free course by registering at:http://alison.com/courses/Excel
Visit our website and register at http://alison.com/ to start studying for free today!
This video will teach you how to copy, move and delete cells in Excel 2003. Microsoft Excel is a spreadsheet application and part of Microsoft Office.
This free online course covers working with Excel spreadsheet software to create, edit and save worksheets and workbooks. It is a vital part of our free Microsoft Office training suite. Completing this free Microsoft Excel course will improve your workplace skill set.
This clip is taken from the FREE interactive online course available at http://ALISON.com
Duration : 0:8:0
(more…)
Technorati Tags: alison free online learning, Arithmetic, difficulties with excel, excel, excel formula guidance, excel formula help, excel formula tutorial, excel in easy steps, excel made easy, Free, free course, free course in excel, free grind, free online training course, Free Tutorial, free tutorial in excel, How to use Microsoft Excel, in, learn excel for free, lesson, Logical Formulas, Microsoft Excel, understanding excel, why use excel
Tags: alison free online learning, Arithmetic, difficulties with excel, excel, excel formula guidance, excel formula help, excel formula tutorial, excel in easy steps, excel made easy, Free, free course, free course in excel, free grind, free online training course, Free Tutorial, free tutorial in excel, How to use Microsoft Excel, in, learn excel for free, lesson, Logical Formulas, Microsoft Excel, understanding excel, why use excel
Posted in Learn Excel Formulas | 1 Comment »
Friday, October 28th, 2011
Study this course for free by registering at: http://alison.com/courses/Excel
This free course teaches you how to use Excel.
Visit our website and register at http://alison.com/ to start studying for free today!
Duration : 0:11:45
(more…)
Technorati Tags: alison free online learning, Arithmetic, difficulties with excel, excel, excel formula guidance, excel formula help, excel formula tutorial, excel in easy steps, excel made easy, free course, free course in excel, free grind, free lesson in excel, free online training course, Free Tutorial, free tutorial in excel, learn excel for free, Logical Formulas, Microsoft, understanding excel, understanding excel formulas, why use excel
Tags: alison free online learning, Arithmetic, difficulties with excel, excel, excel formula guidance, excel formula help, excel formula tutorial, excel in easy steps, excel made easy, free course, free course in excel, free grind, free lesson in excel, free online training course, Free Tutorial, free tutorial in excel, learn excel for free, Logical Formulas, Microsoft, understanding excel, understanding excel formulas, why use excel
Posted in Learn Excel Formulas | No Comments »
Thursday, October 27th, 2011
A short basic tutorial on MS Excel on how to insert / delete rows and columns using keyboard shortcuts.
Duration : 0:4:1
(more…)
Technorati Tags: 2003, 2007, 2010, Basic, Basics, beginner, Beginners, bible, COLUMNS, Delete, demo, demonstration, demonstrations, easy, education, Educational, excel, Guide, HD, Help, information, Insert, instruction, it, itbible, keyboard, learn, Learning, lesson, manual, Microsoft, Microsoft Office 2003, microsoft office 2007, Microsoft Office 2010, ms, MSExcel, MSOffice, office, program., Reference, ROWS, shortcuts, simple, students, teach, technology, tips, tutor, tutorial, usage, use, using, video, Way
Tags: 2003, 2007, 2010, Basic, Basics, beginner, Beginners, bible, COLUMNS, Delete, demo, demonstration, demonstrations, easy, education, Educational, excel, Guide, HD, Help, information, Insert, instruction, it, itbible, keyboard, learn, Learning, lesson, manual, Microsoft, Microsoft Office 2003, microsoft office 2007, Microsoft Office 2010, ms, MSExcel, MSOffice, office, program., Reference, ROWS, shortcuts, simple, students, teach, technology, tips, tutor, tutorial, usage, use, using, video, Way
Posted in Learn Basic Excel | No Comments »