posted by Nate Moore on January 26th, 2015 at 6:25 PM
0 Comments added to this post
Three things to think about axis titles today…
Read More ...
posted by Nate Moore on January 19th, 2015 at 5:24 PM
Today we’ll change the formatting of the axis, the direction of the text, and the font color.
posted by Nate Moore on January 14th, 2015 at 9:29 PM
Here's a quick introduction to Business Intelligence Tools for SQL Server.
posted by Nate Moore on January 12th, 2015 at 5:28 PM
posted by Nate Moore on January 5th, 2015 at 5:31 PM
Starting with Recommended Charts...
posted by Nate Moore on December 15th, 2014 at 7:21 PM
The final video of 2014 and the final video in our series on VBA and macros is a practical example for medical practices.
posted by Nate Moore on December 11th, 2014 at 4:59 PM
Here's a new article with everything you need to know about documenting your spreadsheet using Excel's comments feature.
posted by Nate Moore on December 8th, 2014 at 7:51 PM
Today we put several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA.
posted by Nate Moore on December 1st, 2014 at 7:41 PM
Case statements are more concise and easier to read than the If..ElseIf statements we’ve been discussing.
posted by Nate Moore on November 24th, 2014 at 4:51 PM
The pre-authorization example gets even more precise in the last Excel Video about If.
posted by Nate Moore on November 17th, 2014 at 7:43 PM
You can add more power to your If statements by using Else and ElseIf.
posted by Nate Moore on November 10th, 2014 at 7:30 PM
Adding If statements makes your code much more powerful.
posted by Nate Moore on November 3rd, 2014 at 4:57 PM
Today we’ll work through how to capture user input from Message Boxes.
posted by Nate Moore on October 27th, 2014 at 7:41 PM
Today we’ll take Message Boxes a step further by customizing the message buttons.
posted by Nate Moore on October 20th, 2014 at 7:11 PM
Here’s the first of three videos on Message Boxes in Excel.
posted by Nate Moore on October 13th, 2014 at 7:37 PM
One final video about looping…
posted by Nate Moore on October 6th, 2014 at 8:08 PM
If you watched Excel Video 429, this video will make a lot of sense as another way to loop.
posted by Nate Moore on September 29th, 2014 at 5:38 PM
Here’s another way to loop through data with VBA.
posted by Nate Moore on September 22nd, 2014 at 7:28 PM
We’ve spent several Excel Videos looping through rows and columns in a worksheet. Here’s a way to loop through Excel objects in your workbook.
posted by Nate Moore on September 15th, 2014 at 9:06 PM
If you find a problem as you’re looping through data, here’s how to stop the loop so you can fix the problem.