Blog ~ Site Name

Excel Video 440 Custom Functions Part 2

posted by Nate Moore on December 15th, 2014 at 7:21 PM

0 Comments added to this post

 The final video of 2014 and the final video in our series on VBA and macros is a practical example for medical practices.

Read More ...

New Article on Excel's Comments Feature

posted by Nate Moore on December 11th, 2014 at 4:59 PM

0 Comments added to this post

 Here's a new article with everything you need to know about documenting your spreadsheet using Excel's comments feature.

Read More ...

Excel Video 439 Custom Functions Part 1

posted by Nate Moore on December 8th, 2014 at 7:51 PM

0 Comments added to this post

 Today we put several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA.

Read More ...

Excel Video 438 Case Statements

posted by Nate Moore on December 1st, 2014 at 7:41 PM

0 Comments added to this post

 Case statements are more concise and easier to read than the If..ElseIf statements we’ve been discussing.

Read More ...

Excel Video 437 More Complex If Statements

posted by Nate Moore on November 24th, 2014 at 4:51 PM

0 Comments added to this post

 The pre-authorization example gets even more precise in the last Excel Video about If.

Read More ...

Excel Video 436 Else and Else If

posted by Nate Moore on November 17th, 2014 at 7:43 PM

0 Comments added to this post

 You can add more power to your If statements by using Else and ElseIf.

Read More ...

Excel Video 435 If Statements

posted by Nate Moore on November 10th, 2014 at 7:30 PM

0 Comments added to this post

 Adding If statements makes your code much more powerful.

Read More ...

Excel Video 434 Message Boxes Part 3

posted by Nate Moore on November 3rd, 2014 at 4:57 PM

0 Comments added to this post

 Today we’ll work through how to capture user input from Message Boxes.

Read More ...

Excel Video 433 Message Boxes Part 2

posted by Nate Moore on October 27th, 2014 at 7:41 PM

0 Comments added to this post

 Today we’ll take Message Boxes a step further by customizing the message buttons.

Read More ...

Excel Video 432 Message Boxes Part 1

posted by Nate Moore on October 20th, 2014 at 7:11 PM

0 Comments added to this post

 Here’s the first of three videos on Message Boxes in Excel.

Read More ...

Excel Video 431 Looping Example

posted by Nate Moore on October 13th, 2014 at 7:37 PM

0 Comments added to this post

One final video about looping…

Read More ...

Excel Video 430 Do Until Loops

posted by Nate Moore on October 6th, 2014 at 8:08 PM

0 Comments added to this post

 If you watched Excel Video 429, this video will make a lot of sense as another way to loop.

Read More ...

Excel Video 429 Do While Loops

posted by Nate Moore on September 29th, 2014 at 5:38 PM

0 Comments added to this post

 Here’s another way to loop through data with VBA.

Read More ...

Excel Video 428 Looping Through Workbook Objects

posted by Nate Moore on September 22nd, 2014 at 7:28 PM

0 Comments added to this post

 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.

Read More ...

Excel Video 427 Exiting Loops

posted by Nate Moore on September 15th, 2014 at 9:06 PM

0 Comments added to this post

 If you find a problem as you’re looping through data, here’s how to stop the loop so you can fix the problem.

Read More ...

Excel Video 426 Nesting Loops

posted by Nate Moore on September 8th, 2014 at 6:16 PM

0 Comments added to this post

 Here’s how to make a loop inside another a loop…

Read More ...

New Article on Paste Special

posted by Nate Moore on September 3rd, 2014 at 7:19 PM

0 Comments added to this post

Now that you're familiar with cutting, copying, and pasting data, I've posted a new article on Paste Special.

Read More ...

Excel Video 425 Looping to the End of the Data

posted by Nate Moore on September 1st, 2014 at 6:25 PM

0 Comments added to this post

 Here’s one line of code that makes your macros much easier to run as the size of your data changes.

Read More ...

Excel Video 424 Loops with Steps

posted by Nate Moore on August 25th, 2014 at 6:38 PM

0 Comments added to this post

 Here’s how to make your loop shade alternate rows.

Read More ...

Excel Video 423 Introducing Loops

posted by Nate Moore on August 18th, 2014 at 4:42 PM

0 Comments added to this post

 We’ll start discussing loops in Excel Video 423.

Read More ...

More entries...

Buy the Book

Get Your Data

Invite Nate to Speak