Did you mean?
Search Results - Showing 48 - 60 Of 87
_how-to-link-cells-in-different-excel-spreadsheets.jpg "http://vitamincm.com/excel-link-cells-tutorialnThis video accompanies the How to Link Cells in Different Excel Spreadsheets article on www.VitaminCM.com. You will learn how to link data in one Excel Spreadsheet to data in cells of another worksheet or workbook using linking formulas.")
⏲ 3 min 5 sec ✓ 13-Nov-2010
_excel-video-139-the-formulas-tab.jpg "Excel Video 139 provides an overview of the Formulas tab in Excel 2010.For the next set of Excel Videos, we’ll cover a wide variety of functions that will do everything from statistics to finances to telling you what time it is.I won’t go through every single function in Excel, but I’m going to cover all of the major functions and hope to introduce you to some cool functions you may not be aware of.nnWe’ll also spend time in coming weeks reviewing how Defined Names work in Excel.We")
⏲ 2 min 87 sec ✓ 21-Mar-2015
_excel-video-249-writing-formulas-between-tabs.jpg "Now that we’re more familiar with tabs, watch Excel Video 249 to write formulas that reference data on other tabs.As you watch how to write formulas to reference data on other tabs, one of the biggest takeaways is that I don’t get too worked up about Excel syntax for referencing other tabs and spreadsheets.I start a formula with = and then click on the cell I want to reference.Excel will fill in the brackets, exclamation marks, and single quotes as needed.nnThe syntax is that Excel ref")
⏲ 3 min 22 sec ✓ 21-Mar-2015
_developing-a-strategic-business-plan-within-gp-practices.jpg "New Care Models: Ross Clark describes the resources and systems available for GP practices to develop a business plan. nnTranscriptnnIn the changing health economy, can you give us some advice on creating a business case?nnIt’s absolutely fundamental that each GP practice develops its own business plan or strategic plan. Now there are two key reasons for that. One is internal to the practice and one is external. So the external affect is what’s happening in the area around the practice. The")
⏲ 1 min 48 sec ✓ 23-Oct-2017
_excel-video-234-fee-schedule-example-part-3.jpg "Excel Video 234 includes a couple more tips as we analyze the sample fee schedule we’ve been working on.Watch for how the F2 key not only lets you edit the formula, but Excel also color codes the formula components so you can easily find the cells that influence the formula.The F2 trick is especially helpful if you didn’t create the spreadsheet and you’re trying to understand how the formulas work.We’ll use the sum button to quickly summarize totals, we’ll single and double under")
⏲ 3 min 57 sec ✓ 21-Mar-2015
_excel-video-252-relative-cell-references.jpg "Excel Video 252 describes a relative cell reference, or a formula that changes the row and column references when it’s copied.Relative cell references are very common and very useful in Excel.For many formulas, you want the row and column references to change as the cell is copied.nnThere are occasions when you wouldn’t want the cell reference to change when a formula is copied.For example, if you forecast collections to increase by 4% next year for your top 100 CPT codes, rather than")
⏲ 1 min 86 sec ✓ 21-Mar-2015
_excel-video-46-highlight-cells-rules-part-2.jpg "Excel Video 46 describes how to highlight specific dates and how to find duplicate values using conditional formatting.If you have a list of dates, it’s easy to highlight dates meeting a variety of criteria, such as yesterday/today/tomorrow, last week/this week/next week, and last month/this month/next month.A helpful thing about this feature is that Excel always knows what today is, so if you load the spreadsheet tomorrow, next week, or next month, the conditional formatting always stays")
⏲ 3 min 6 sec ✓ 21-Mar-2015
_watch-evaluate-formulas-on-excel-2007-ipods.jpg "Excel 2007 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2007 as a database with many sorting and filtering options. It's also important to know how to create the database by watching the top design flaws you can use helpful features!nnLearn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified")
⏲ 3 min 19 sec ✓ 28-Feb-2010
_excel-video-477-relationships-in-the-excel-data-model.jpg "Creating and managing relationships in the Excel Data Model, as we’ll do in Excel Video 477, adds tremendous power and flexibility to our analysis.In a typical Pivot Table, you can only pivot data from one table.If you wanted to combine data from multiple tables, you have a serious VLOOKUP project ahead of you.In today’s example, there would millions of VLOOKUP formulas.That would slow down your spreadsheet a little!Relationships in the Excel Data Model make that complexity much fa")
⏲ 4 min 26 sec ✓ 29-Sep-2015
_excel-video-147-nesting-if-functions.jpg "Excel Video 147 nests IF functions.By nesting, I mean we’ll put an IF function inside of another IF function so that we’ll have 3 options instead of the 2 options we normally get with IF.I’ll show you two different ways to nest the IF function so you customize your approach based on the data you see in your practice.You can write an IF statement so that if the statement is true, Excel evaluates a second IF statement.You can also write an IF statement so that if the statement is fal")
⏲ 2 min 83 sec ✓ 21-Mar-2015
_excel-video-338-introducing-scenario-manager.jpg "Excel Video 338 introduces Scenario Manager, a different way to manage scenarios in Excel.Scenario Manager is another tool in the What-If Analysis section of the Data tab.We can use Scenario Manager to keep track of what happens when we change variables in an equation.The example for the next group of Excel Videos is a physician compensation plan.I’ll say this in the video, but the purpose of this example is to show how Excel works, not to discuss the merits or mechanics of physician c")
⏲ 3 min 3 sec ✓ 21-Mar-2015
_excel-video-176-row-with-hlookup.jpg "In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula, the column reference doesn’t change.We used an Excel function called COLUMN as the column reference so that we could easily copy the VLOOKUP formulas.In Excel Video 176, I’ll show you a very similar trick for HLOOKUP.nnJust like VLOOKUP, when you copy an HLOOKUP formula, the row reference won’t update as the rest of the cell references do.Today, we’ll use the ROW function to")
⏲ 2 min 0 sec ✓ 21-Mar-2015
Related Searches
Search Videos
Recent Searches
_how-to-link-cells-in-different-excel-spreadsheets.webp "http://vitamincm.com/excel-link-cells-tutorialnThis video accompanies the How to Link Cells in Different Excel Spreadsheets article on www.VitaminCM.com. You will learn how to link data in one Excel Spreadsheet to data in cells of another worksheet or workbook using linking formulas.")
_excel-video-139-the-formulas-tab.webp "Excel Video 139 provides an overview of the Formulas tab in Excel 2010.For the next set of Excel Videos, we’ll cover a wide variety of functions that will do everything from statistics to finances to telling you what time it is.I won’t go through every single function in Excel, but I’m going to cover all of the major functions and hope to introduce you to some cool functions you may not be aware of.nnWe’ll also spend time in coming weeks reviewing how Defined Names work in Excel.We")
_excel-video-249-writing-formulas-between-tabs.webp "Now that we’re more familiar with tabs, watch Excel Video 249 to write formulas that reference data on other tabs.As you watch how to write formulas to reference data on other tabs, one of the biggest takeaways is that I don’t get too worked up about Excel syntax for referencing other tabs and spreadsheets.I start a formula with = and then click on the cell I want to reference.Excel will fill in the brackets, exclamation marks, and single quotes as needed.nnThe syntax is that Excel ref")
_developing-a-strategic-business-plan-within-gp-practices.webp "New Care Models: Ross Clark describes the resources and systems available for GP practices to develop a business plan. nnTranscriptnnIn the changing health economy, can you give us some advice on creating a business case?nnIt’s absolutely fundamental that each GP practice develops its own business plan or strategic plan. Now there are two key reasons for that. One is internal to the practice and one is external. So the external affect is what’s happening in the area around the practice. The")
_excel-video-234-fee-schedule-example-part-3.webp "Excel Video 234 includes a couple more tips as we analyze the sample fee schedule we’ve been working on.Watch for how the F2 key not only lets you edit the formula, but Excel also color codes the formula components so you can easily find the cells that influence the formula.The F2 trick is especially helpful if you didn’t create the spreadsheet and you’re trying to understand how the formulas work.We’ll use the sum button to quickly summarize totals, we’ll single and double under")
_excel-video-252-relative-cell-references.webp "Excel Video 252 describes a relative cell reference, or a formula that changes the row and column references when it’s copied.Relative cell references are very common and very useful in Excel.For many formulas, you want the row and column references to change as the cell is copied.nnThere are occasions when you wouldn’t want the cell reference to change when a formula is copied.For example, if you forecast collections to increase by 4% next year for your top 100 CPT codes, rather than")
_excel-video-46-highlight-cells-rules-part-2.webp "Excel Video 46 describes how to highlight specific dates and how to find duplicate values using conditional formatting.If you have a list of dates, it’s easy to highlight dates meeting a variety of criteria, such as yesterday/today/tomorrow, last week/this week/next week, and last month/this month/next month.A helpful thing about this feature is that Excel always knows what today is, so if you load the spreadsheet tomorrow, next week, or next month, the conditional formatting always stays")
_watch-evaluate-formulas-on-excel-2007-ipods.webp "Excel 2007 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2007 as a database with many sorting and filtering options. It's also important to know how to create the database by watching the top design flaws you can use helpful features!nnLearn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified")
_excel-video-477-relationships-in-the-excel-data-model.webp "Creating and managing relationships in the Excel Data Model, as we’ll do in Excel Video 477, adds tremendous power and flexibility to our analysis.In a typical Pivot Table, you can only pivot data from one table.If you wanted to combine data from multiple tables, you have a serious VLOOKUP project ahead of you.In today’s example, there would millions of VLOOKUP formulas.That would slow down your spreadsheet a little!Relationships in the Excel Data Model make that complexity much fa")
_excel-video-147-nesting-if-functions.webp "Excel Video 147 nests IF functions.By nesting, I mean we’ll put an IF function inside of another IF function so that we’ll have 3 options instead of the 2 options we normally get with IF.I’ll show you two different ways to nest the IF function so you customize your approach based on the data you see in your practice.You can write an IF statement so that if the statement is true, Excel evaluates a second IF statement.You can also write an IF statement so that if the statement is fal")
_excel-video-338-introducing-scenario-manager.webp "Excel Video 338 introduces Scenario Manager, a different way to manage scenarios in Excel.Scenario Manager is another tool in the What-If Analysis section of the Data tab.We can use Scenario Manager to keep track of what happens when we change variables in an equation.The example for the next group of Excel Videos is a physician compensation plan.I’ll say this in the video, but the purpose of this example is to show how Excel works, not to discuss the merits or mechanics of physician c")
_excel-video-176-row-with-hlookup.webp "In Excel Video 174, I explained that one of the gotchas in VLOOKUP is that when you copy a VLOOKUP formula, the column reference doesn’t change.We used an Excel function called COLUMN as the column reference so that we could easily copy the VLOOKUP formulas.In Excel Video 176, I’ll show you a very similar trick for HLOOKUP.nnJust like VLOOKUP, when you copy an HLOOKUP formula, the row reference won’t update as the rest of the cell references do.Today, we’ll use the ROW function to")
![[+]](/images/menu.gif){kind=small}