Excel Video 454 Trendlines Part 1
Trendlines make it easier to see trends and patterns in your data. Excel Video 454 shows how to add a trendline to your chart. Trendlines are added a series at a time. Watch how to add a trendline, the types of trendlines to add, how to rename a trendline, and how to...
Excel Video 453 Legends
Chart Legends are pretty straightforward, but Excel Video 453 has a few tricks you may find helpful. There’s not much to Legends except where to put them, but watch for an easy way to change the chart legend and the x axis to better analyze your data. I’ll also give...
Excel Video 452 Gridlines
It’s easy to customize Gridlines in Excel Video 452. You can choose between horizontal and vertical and between major and minor gridlines, but that’s about it. Since Gridlines are so straight-forward, watch for another way to access and change the components of your...
Excel Video 451 Error Bars
Excel Video 451 shows you how to use Error Bars to display statistical information and a clever trick to show more information with fewer pixels. Error Bars are normally used to show uncertainty or confidence around numbers on a chart. For example, there are ways to...
Excel Video 450 Data Tables
Excel Video 450 shows you how easy it is to add a Data Table to a chart in Excel 2013. Watch how I remove the Legend from the chart and include it as part of the Data Table instead. You’ll see some new ways to customize the Data Table in Excel 2013 and I’ll show you...
Excel Video 449 Data Callouts
Excel Video 449 introduces Data Callouts, a new feature in Excel 2013. Watch how to use and customize Data Callouts. In my opinion, the space Data Callouts take up isn’t usually justified by the additional information they may provide. I typically use Data Labels as...
Excel Video 448 Data Labels Part 2
I have two more Data Label tricks in Excel Video 448. First, watch for a way to use cells outside of my chart as Data Labels. In today’s example I’ve characterized the data as High, Avg, or Low using formulas to see if the data point is significantly higher or lower...
Excel Video 447 Data Labels Part 1
Data Labels are a way to provide additional information about data in your chart. Excel Video 447 shows you how to start using Data Labels. Today I’ll show you what a Data Label is, some options on how where to position Data Labels, and some ways to change the content...
Excel Video 446 Chart Titles Part 2
Excel Video 446 takes our discussion of Chart Titles to the next level. Watch how I use = to point the Chart Title to a cell where I can combine text and formulas to get much more customized titles. If you aren’t familiar with the INDEX and MATCH trick I use in the...
Excel Video 445 Chart Titles Part 1
Excel Video 445 is the first of two videos on using Chart Titles. Watch for ways to change the location of the Chart Title and for suggestions on what to put in the title. Rather than a generic title like, “Charges by Month” you may find it more helpful to reinforce...
Excel Video 444 Axis Titles
There are three things to consider as we discuss axis titles in Excel Video 444 today. The first point is that axis titles are often redundant. The titles take up space on the chart but many times a reader can use the fact that the axis is formatted with a dollar sign...
Excel Video 443 Excel Axis Options Part 2
In Excel Video 443 we’ll make more changes to the horizontal and vertical axes. We’ll format the numbers, change the direction of the text, and change the font color. Notice how it’s often easier to just format the raw data the way you want the chart to appear, but if...
Excel Video 442 Excel Axis Options Part 1
Excel Video 442 shows you how to control the horizontal and vertical axes for your charts. Notice the new Chart Elements menu (the plus sign) and different ways to select the area on the chart you want to edit. Most of the options for controlling axes are fairly...
Excel Video 441 Introducing Excel 2013 Charts
Happy 2015 everybody! We’re kicking off the new year with a new series about Excel 2013 Charts. We’ll start with a new feature in Excel 2013, Recommended Charts. Watch how Excel reviews our data and provides recommendations for how to chart the data. It’s easy to see...
Excel Video 440 Custom Functions Part 2
The final video of 2014 and the final video in our series on VBA and macros is a practical example for medical practices. We’ll build a custom Aging function in Excel Video 440 using a case statement. Once all of the pieces are in place, the Aging function is pretty...
Excel Video 439 Custom Functions Part 1
Excel Video 439 puts several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA. The custom function is a response to a question a while back in MGMA’s Excel Users group asking for a way to compare the fill color of...
Excel Video 438 Case Statements
Excel Video 438 introduces case statements, which are a more concise and easier to read way to express multiple options in VBA. Notice how the Case statement starts with Select Case and ends with End Select and how the Case statement fits inside the loop so that each...
Excel Video 437 More Complex If Statements
The pre-authorization example gets even more precise in Excel Video 437, the last Excel Video about If. We’ll add several different tests to make different pre-authorization scenarios different colors in this Excel Video, including And tests and Or tests. We’ll also...
Excel Video 436 Else and ElseIf
You can add more power to your If statements by using Else and ElseIf. Excel Video 436 has an example of both. The If statements we worked through in the last Excel Video tested to see if the insurance was not Medicare. If the insurance is Medicare, we can use an Else...
Excel Video 435 If Statements
Adding If statements makes your code much more powerful. I’ll show you how to start using If statements in Excel Video 435. We’ll work through two examples to start. The first example is a simple If statement that fits on one line. Notice the If clause contains a test...