Results for:
macros

• Generate invoice numbers in Excel

  12 Jan 2012

  If you need to create invoices for your business, you can use one of the many invoice templates found on Office.com. Although these templates are a great starting point, they won't automatically generate unique invoice numbers—you'll need a macro for that. Excel MVP Bill Jelen graciously offered...
• Free training: Take the next steps in growing your Excel skills

  28 Jun 2011

  In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder...
• Learn how to create your own Excel macros in this free training course

  1 Jun 2011

  Have you been wanting to record your own Excel macros, but you're not yet ready to dip your toes in the water? Maybe you want to modify macros other people have created, or you're not sure what a macro can do for you? If so, you may want to take this online training course on creating Excel macros. You...
• IF and only IF (video)

  29 Mar 2011

  This post is all about IF--not the poem by Rudyard Kipling, or the 1971 hit song by Bread, but the function . The IF function is used in many Office programs, but most of us know it from Microsoft Excel: IF(logical_test, [value_if_true], [value_if_false]) IF is one of the most searched-for words on Office...
• A capital idea: Changing case in Excel (video)

  10 Mar 2011

  People often ask how to change the case of text in Excel. This issue tends to crop up when you work with data from external sources. Unlike Word, Excel doesn't have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn't mean...
• Add a table of contents to your workbook – it’s easy, I promise!

  13 Jan 2011

  Sometimes workbooks can be very large and hard to navigate. Only so many tabs fit across the bottom of the screen, and it’s hard to know how long each worksheet is. Excel doesn’t have a built-in way to add a table of contents to a workbook; however, there is a way! In this post, I’ll...