Home
Videos uploaded by user “Doug H”
Use the COUNT (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) Functions
 
03:18
Check out my Blog: http://exceltraining101.blogspot.com Are you interesting in learning how Excel counts? IF you are, you've come to the right place! There are numerous ways that Excel can count stuff like numbers or text. This video covers the group of count functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) that Excel provides. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 253715 Doug H
Create Angled or Slanted Text and Borders
 
04:48
Check out my Blog: http://exceltraining101.blogspot.com How to create slanted, angled or sideways text in Excel. The example show a 45 degree orientation for headings. There are also other ways to rotate the text such as vertically. The video finished with formatting such as adding borders that are also angled. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 235414 Doug H
Create a Speedometer Chart
 
07:54
Check out my Blog: http://exceltraining101.blogspot.com If you like cars and Excel, you might like this video. The speedometer analogy on business dashboards is often used or mis-used. You've got a spectrum where data resides and it gets separated by good, average, and poor areas. If you like the visual appeal of a car dashboard chart on your worksheet see this video to learn how to create a speedometer chart in Excel. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 225646 Doug H
Use the INDEX & MATCH Functions to Perform Lookups
 
06:16
Check out my Blog: http://exceltraining101.blogspot.com Have you every used VLOOKUP to do look ups from table to table? If you have you'd know there were some limitation on how it performs look ups, such as it would only lookup up the item in the first column of the table you are trying to bring data over from. There are ways to get around that limitation, but another method is to use the INDEX & MATCH functions to perform table look ups. It might be scary at first, but once you get the hang of using these two function together, you'll find it very useful. Check out the video to see how. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 640382 Doug H
Create a Dynamic Drop Down List
 
06:16
Check out my Blog: http://exceltraining101.blogspot.com Do you want to learn how to create a drop down list? That's when you can click a small arrow to show you a list of choices. But what about after selecting an option from a first drop down list and it filters another set of options from another drop down list? That would dynamic wouldn't it? This video covers how to create a dynamic drop down list in Excel and it's pretty simple to do. See how... #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 847530 Doug H
Create a Simple Org Chart
 
03:56
Check out my Blog: http://exceltraining101.blogspot.com How to create a simple organizational chart starting with bullet points in PowerPoint 2010 Check out my Blog: http://exceltraining101.blogspot.com
Views: 125004 Doug H
Use the Consolidate Feature to Combine Data
 
07:44
Check out my Blog: http://exceltraining101.blogspot.com Do you want to combine tables together?  Lets say you have sales data that span multiple columns but there rows and rows of values.  Also there are multiple worksheets (or tabs) that have the same format.  The only difference is that one worksheet if for salesperson A and the other worksheet is for salesperson B.  Now with two sales people the act of combining this together would be a simple copy/paste.  However if you have more sales people (like 10, 15, or more!), that would be a lot of copying and pasting.  Instead of doing that, just use the consolidate feature in Excel to do the heavy lifting.  See how it's done with this video. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 303313 Doug H
Create a Speedometer Chart in Excel 2010
 
06:54
Check out my Blog: http://exceltraining101.blogspot.com Sometimes...don't you feel the need for speed? Get into the car and just press the pedal and watch the speedometer needle go and go.  Of course that's probably not the safest thing to do in the real world in most settings.  So let do it in a more safe and benign environment - in your spreadsheet but with the same excitement! If you're creating dashboards or just wanted to add some flair to data that you're sharing, a speedometer chart may just fit the bill.  The excitement it adds is the green, yellow and red colors! And seeing the needle moving to the different colors like moving from yellow to red...that just screams the word "dramatic" (or "dangerous" depending on your audience).  Anyways a speedometer chart just presents data in a familiar dashboard analogy so if you wanted to add some visual appeal to your data, try a speedometer chart.  Check out the video below. #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 62639 Doug H
Create a Thermometer Chart in Excel
 
04:08
Check out my Blog: http://exceltraining101.blogspot.com How to create a thermometer style chart in Excel 2007 #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 25694 Doug H
Create a Reverse Pivot Table
 
04:13
Check out my Blog: http://exceltraining101.blogspot.com How to create a database table from a summary table. Basically creating a reverse pivot table. This tip uses the Pivot Table Wizard (keyboard short cut ALT+D+P) Some also call this an unpivot. Reverse Pivot #2 video at https://youtu.be/sb81XE_jPd8 #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 55269 Doug H
Create a Pareto Chart
 
10:01
Check out my Blog: http://exceltraining101.blogspot.com Have you ever heard of the 80 20 rule? It's based on the idea of the Pareto principle which was named after an Italian economist. Basically it proposed that a small percentage of inputs where responsible for a large percentage of outputs. Like a small percentage of a population held the wealth or wealth creating aspects of the larger population. Often you may see charts to try to visualize this and sometimes they are called Pareto charts. To see how we can create a simple Pareto chart, click the video to learn. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 478946 Doug H
Use VLOOKUP to Find the 2nd Match (or nth Match)
 
07:47
Check out my Blog: http://exceltraining101.blogspot.com If you are familiar with the VLOOKUP function it's a great tool to lookup values in a range or table. However it will only bring back the first instance of the looked up value. What if you wanted the second instance of the value or even have all the instances of the value brought back? This could be done by using a helper column and the COUNTIF function. Watch the video to see how it's done! P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 90369 Doug H
Use the PMT, IPMT & PPMT Functions
 
05:43
Check out my Blog: http://exceltraining101.blogspot.com How to use the different payment functions (PMT, IPMT & PPMT) in Excel. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 53442 Doug H
Create a Form Letter with Mail Merge in Word and Excel
 
07:50
Check out my Blog: http://exceltraining101.blogspot.com Do you create mass mailings? For example you have a standard form letter or template and you needed to incorporate a mailing list with the first and last names to semi personalize the letter. The list is on Excel and your form letter template is in Microsoft Word. There is actually a utility on Word to combine the Excel list and your Word file and create these type of letters. See the video to learn how to create form letters with mail merge in Word and Excel. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 80820 Doug H
Create a Basic Gantt Chart
 
08:12
Check out my Blog: http://exceltraining101.blogspot.com Do you do project management and trying to figure out how to visually see tasks that are happening through a timeline? There's a tool to do that and it's called a Gantt chart. Though complex Gantt charts can be created with Microsoft Project (as well as other project management tools), if you wanted a basic Gantt chart this can be created in Excel. It doesn't take too much work and it's actually quite simple. Check out the video to see how it's done! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 1246281 Doug H
Use the DSUM Function
 
03:37
Check out my Blog: http://exceltraining101.blogspot.com How to use the Microsoft Excel DSUM function #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 67839 Doug H
Create a Two Variable Data Table
 
04:36
Check out my Blog: http://exceltraining101.blogspot.com This video is about creating a two variable data table feature. The use case for this is if you want to input two varying pieces of data and see how the output changes. For example say you are taking out a loan and maybe not sure how much you want to take out. At the same time you are unsure of the rate you might get. What are the possibilities of monthly payments you'll have? It's almost endless! With a two variable data table you can a range of interest rate AND a range of loan amounts and let the handy-dandy data table feature figure out the different monthly payments that are possible. Amazing! See the magic at work in the video. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 240269 Doug H
Create a One Variable Data Table
 
04:39
Check out my Blog: http://exceltraining101.blogspot.com Ever heard of a variable table? What about a one variable table? Well if you haven't you've step into the right place. A one variable table gives you the ability to put a variable input in and see how that input affects some outputs. For example let's say you are taking out a loan and wanted to see what your payments would be at 1%, 1.5% or etc. Instead of erasing and plugging in a different interest each time, you can just create a table that list the interest rates ranging from 1% to say 7% in .5% increments. This can be done with a one variable data table. View the video to see how it's done. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 200549 Doug H
Combine Tables from Multiple Sheets in the Same Workbook with Power Query
 
09:18
Check out my Blog: http://exceltraining101.blogspot.com If you work with data in many worksheets, sometimes it's better to combine this all into one worksheet. Especially if they all have the same header fields. You can usually do a copy and paste, but if there are a lot of worksheet or if this is a recurring task, you might want to semi automate it. Power Query makes this easier to do. This video shows how to combine tables from different tabs in the same file using the Append capability in the Excel with Power Query. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 178809 Doug H
Turn on Filtering for the Values Area of a Pivot Table
 
03:59
Check out my Blog: http://exceltraining101.blogspot.com This video shows how to turn on filtering capabilities in the values area of a Pivot Table. When you create a Pivot Table you can sort and filter in the rows or column area but can only sort in the values area. There is a workaround that lets you turn on filtering in the values area. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 40315 Doug H
Perform a Lookup with Power Query
 
11:00
Check out my Blog: http://exceltraining101.blogspot.com This video show how to use Power Query to perform lookups. For small data sets you are better off with Excel's other lookup function, but if you are dealing with large data sets (over half a million) you may be better off using Power Query. This method also would make it easier if you do this on a recurring basis (daily, weekly, etc) and didn't/couldn't write macros. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 65711 Doug H
Filter Unique Values from a List
 
04:41
Check out my Blog: http://exceltraining101.blogspot.com How to filter out unique values from a list in a column. I'll show three ways to do this: (1) with a PivotTable (2) with the Advanced Filter feature (3) with the Remove Duplicates feature #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 65270 Doug H
Create an Amortization Table with a Pre-Payment Option
 
12:05
Check out my Blog: http://exceltraining101.blogspot.com Are thinking about real estate or maybe considering purchasing a house, condo or other type of property? Usually you'll be thinking about getting a loan and then thinking about how to pay for it. Maybe there will even be an option to pay some of the loan early. But then you may want to know how that will impact the amount and term of the load. Check out this video to see how to create an amortization table that also let you calculate pre-payment amounts. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 231049 Doug H
Use the DGET Function
 
05:00
Check out my Blog: http://exceltraining101.blogspot.com This video covers how to use the DGET database function. This is a good look up function to use in place of VLOOKUP if you want to get around the limitation that VLOOKUP will not bring back data that is on the leftmost columns from where you are starting at. Feel free to provide a comment or share it with a friend! ------------------------------------ #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 10545 Doug H
Copy and Paste Only Visible Cells
 
03:22
Check out my Blog: http://exceltraining101.blogspot.com This video covers how to copy and paste visible cells. There are times when you hide a column or row, make a selection to copy and then paste to a target cell. The expectation is that the visible cells are the only one pasted at the target area. Unfortunately that didn't happen. I covered how to workaround that with selecting only the visible cells with two examples. P.S. Feel free to provide a comment or share it with a friend! ---------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 77025 Doug H
Create a Dynamic Chart with Checkboxes
 
11:06
Check out my Blog: http://exceltraining101.blogspot.com If you want to show multiple views of a chart, sometimes it may involve letting your audience select some criteria so they can see different views of the data. You'd want to embed some kind of interaction for your users and putting together a dynamic, interactive chart may be your option. To learn how to create a dynamic combination chart (with check boxes to choose with chart series to show) check out this video. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 120620 Doug H
Create a Scrolling Table
 
07:38
Check out my Blog: http://exceltraining101.blogspot.com It's fairly easy to create a table in Excel, but when it gets large you have to use the the arrows to scroll up and down. But what if you want to constrain the table to a fixed row height and perform scrolling within the table? This can actually be done with some Excel functions and it's not as hard as you might think. See this video to learn how to create a scrolling table that lets your scroll through a range from a larger table. #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 201098 Doug H
Find Duplicates with a PivotTable
 
05:11
Check out my Blog: http://exceltraining101.blogspot.com How to find duplicate values in one column record or in multiple column records #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 38440 Doug H
Create a Combination Chart
 
06:47
Check out my Blog: http://exceltraining101.blogspot.com Ever see those charts where there is a column chart and a line chart in one?  Also there are two y axis that show ranges on values on both the left and right side of the chart?  Well this is called a combination chart and it's commonly used to show two series of data together.  I see this most in stock price type of charts where the column charts shows the volume of stock trading activity and the line chart shows the stock price.  It's actually fairly easy to create this type of chart and it's a great way to show multiple views of data in one chart.  See the video to learn how it's done. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 626692 Doug H
Sum Positive and Negative Numbers with the SIGN (and SUMIF) Function
 
03:32
Check out my Blog: http://exceltraining101.blogspot.com This video show how to sum up positive and negative numbers with the SIGN and SUMIF functions. Feel free to provide a comment or share it with a friend! ------------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 58351 Doug H
Create a Basic Custom Function in Power Query
 
08:22
Check out my Blog: http://exceltraining101.blogspot.com Creating a Custom Function in Power Query is actually a simple process. Custom functions enable you to provide create more complex data processing with Power Query and maybe even some interactivity. Before learning all that complex stuff, you'd probably need to understand how the heck can you create a customer function in Power Query. I'm going to provide a very basic example of how it's done. After learning this and getting a taste for the M language (the formula language behind Power Query) it's a start to understanding how to create more sophisticated functions later on. Check out the video to see how it's done. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel #excel101
Views: 18368 Doug H
Use the TREND Function to Predict Sales Growth
 
07:21
Check out my Blog: http://exceltraining101.blogspot.com This video show you how to use the TREND function to predict future monthly sales (from one to multiple months) based on historical values. Feel free to provide a comment or share it with a friend! --------------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 81437 Doug H
Create a Drop Down List with a Combo Box or List Box
 
08:43
Check out my Blog: http://exceltraining101.blogspot.com This video shows you how to create a dropdown list with an Active X Combo Box Control. Other examples include how to create two type of lists with an Active X List Box. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 417837 Doug H
Create a Waterfall Chart
 
07:14
Check out my Blog: http://exceltraining101.blogspot.com How to create a basic waterfall chart #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 60444 Doug H
Use a Dropdown List to Switch between a Table or Chart
 
07:40
Check out my Blog: http://exceltraining101.blogspot.com Sometimes you want to see a Table and sometimes you'd want to see a Chart.  How about both?  And have the option to switch between both?  It like having a button to go between a table and chart.  This tip will step you through how to create not a button but a more descriptive drop down that informs you to choose between viewing your data as a table or a colorful chart.  How's that for power!  It's a bit more involved in creating this, but not too difficult.  To see the magic check out the video. Check out my Blog: http://exceltraining101.blogspot.com #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 29791 Doug H
Create a Basic Control Chart
 
09:55
Check out my Blog: http://exceltraining101.blogspot.com If you're in working in an manufacturing operations role or taking business operations class you'll be familiar with keeping the parts production in a certain range. You don't want too much variation in how something is made. One of the tools to report on this process is a control chart or also known as a Shewart chart. Check out video on how to create a basic control chart. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 231371 Doug H
Generate Random Numbers in Excel
 
05:46
Check out my Blog: http://exceltraining101.blogspot.com Do you like randomness? If so this is the video for you cause it will cover how to generate random numbers in Excel. There are three examples: One using the RAND function, another using the RANDBETWEEN and one more using the Data Analysis Toolpak Random Number Generator option. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 236748 Doug H
Calculate Compound Interest in Excel
 
04:27
Check out my Blog: http://exceltraining101.blogspot.com Did you know you can use Excel to figure out how much something is going to cost or how much money you'll get in the future assuming some fixed interest rate? It's call Future Value and this term is often used in business as well as personal finance. See this video to learn about using Excel to calculate compound interest with the Future Value (FV) formula and Excel's built in FV function. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 142210 Doug H
Create a Basic Burndown Chart in Excel
 
09:44
Check out my Blog: http://exceltraining101.blogspot.com How to create a basic burndown chart. Popular in Agile development, the burndown chart may also be considered a project management tool to see if a set of tasks are completed ahead of or behind schedule. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 138444 Doug H
Perform a Lookup with Multiple Criteria
 
10:03
Check out my Blog: http://exceltraining101.blogspot.com If you've perform lookup before it's usually looking up something with one criteria (i.e., finding the sales for SKU 123). But what if you had multiple criteria to lookup like sales for SKU 123 that are blue and size is small? Wow that's a lot of criteria to put into a lookup function. But it's actually not that hard to do. In this video I'll show two example of how you can accomplish this task. Check out the video! P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 115441 Doug H
Use the REPLACE and SUBSTITUTE Functions
 
04:59
Check out my Blog: http://exceltraining101.blogspot.com If you want to find some values and replace it with other values there are two functions that can help you do this. Similar to the find and replace feature in Excel this uses functions to accomplish it. Learn how to use the REPLACE and SUBSTITUTE functions by checking out the video. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 121442 Doug H
Use Goal Seek to Perform Break Even Analysis
 
04:00
Check out my Blog: http://exceltraining101.blogspot.com Thinking of staring a business? Are you going to make something and sell it for money? You may want to quickly find out how many items you need to sell in order to break even or maybe you want to know how many to sell in order to make a hundred dollars? Don't do those calculations in your head cause you may end up with a headache. Instead let good ole Excel do all the hard work with Goal Seek. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 6111 Doug H
Create a Swim Lane Flowchart in Visio
 
17:22
Check out my Blog: http://exceltraining101.blogspot.com How to create a swim lane diagram or a cross functional flowchart in Visio 2010. This video covers swim lane creation and modification, shapes and connector types, and multiple page tips. Check out my Blog: http://exceltraining101.blogspot.com
Views: 191685 Doug H
Use VLOOKUP to Lookup a Value to the Left
 
08:44
Check out my Blog: http://exceltraining101.blogspot.com This video show how to perform a lookup with the VLOOKUP and CHOOSE function to bring back a value to the left. The VLOOKUP function normally brings back values to the right of a table, but this "hack" using the CHOOSE function will let you bring back a value to the left of a table. P.S. Feel free to provide a comment or share it with a friend! ---------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 25533 Doug H
Create a Bubble Chart
 
08:36
Check out my Blog: http://exceltraining101.blogspot.com If you've create x y scatter charts, you'll probably like bubble charts. In addition to the horizontal and vertical series of data, you can add a third series of data which will show the difference between variable by varying the size (like the size of a circle or bubble). Check out the video to learn how to create a bubble chart and also using images or picture in the bubble instead of the colors. #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 124300 Doug H
Get a List of Filenames from Windows Directory into Excel
 
05:46
Check out my Blog: http://exceltraining101.blogspot.com This video shows how to copy file names from windows explorer to Excel for further modification. You would think it would be as easy as performing a copy and paste with mouse clicks, but it doesn't work that way. There is a workaround by using the command prompt and redirecting the output to a text file. P.S. Feel free to provide a comment or share it with a friend! ---------------------------------- #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 57723 Doug H
Create a Brainstorm Diagram or Mind Map in Visio
 
10:33
Check out my Blog: http://exceltraining101.blogspot.com Use Visio 2010 to create a brainstorm diagram or a mind map. This eventually could become a work breakdown structure (WBS) which could be exported to MS Excel and then into MS Project. #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 61224 Doug H
Convert Table in a PDF File to Excel
 
04:37
Check out my Blog: http://exceltraining101.blogspot.com Have you ever wanted to get a table in from a PDF file into excel so you could do some further analysis or charting? There's not a PDF to Excel converter capability though some websites have tools to do this for you (but if you have confidential information you'd wouldn't want to upload it to a 3rd party site). One way to pull a table in from a PDF file is to use an intermediary application and Microsoft already makes one....Word! See how this could be done. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel #excel101
Views: 18461 Doug H
Create an X Y Scatter Chart with Data Labels
 
07:23
Check out my Blog: http://exceltraining101.blogspot.com How to create an X Y Scatter Chart with Data Label. There isn't a function to do it explicitly in Excel, but it can be done with a macro. The Microsoft Knowledge base article describes it. See the link to the article (along with the Macro code) at http://support.microsoft.com/kb/213750 #exceltips #exceltipsandtricks #exceltutorial #doughexcel excel
Views: 379123 Doug H
Create a Break Even Analysis Chart
 
12:53
Check out my Blog: http://exceltraining101.blogspot.com This video show how to create a break even chart. Based on fixed and variable costs you can calculate the break even unit totals and dollar amounts with the per unit sales price. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel
Views: 246499 Doug H