Results for:
videos

• Impress your teacher: Use conditional formatting to highlight data (video)

  13 Jun 2012

  He's no slouch! Melvin Corpuscle shows his accounting teacher a thing or two by walking him through how he used conditional formatting to make low and high sales numbers stand out. Learn more about conditional formatting: Conditional Formatting Rules Simplified Quick start: Apply conditional formatting...
• Webinar: Excel PivotTables and Slicers

  11 Jun 2012

  In this week’s webinar, you’ll get an overview of two tools in Excel for crunching numbers so you can know what the numbers mean to your business: PivotTables and Slicers (new to Office 2010). References for this webinar: So you asked about PivotTables Quick Start: Create a PivotTable report...
• Webinar: Simplifying your data in Excel

  26 Mar 2012

  Here is the recording from this week's free Office 15-Minute Webinar about simplifying data in Excel. You can join our webinars live at 9:15 am PDT. Click http://aka.ms/offweb for complete information. What you will learn at Tuesday’s webinar Using Conditional Formatting Adding Sparklines Better...
• Excel: The Basics (Video)

  1 Feb 2012

  For those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about conditional formatting (a cool way to visually display data). Then one day your boss asks you to create a report--with...
• 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...
• You asked about pivot tables (video)

  22 Mar 2011

  So many Office customers ask about "pivot table" that we've gathered the best answers in this blog post. Most likely, you are looking for information about how to create a PivotTable report that can help summarize and analyze your data. Or you already have your data in a PivotTable report and are looking...
• 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...