Excel Magic Revealed: Unstacking Data Like a Pro!
Microsoft Excel Tips and Tricks Excel Magic Revealed: Unstacking Data Like a Pro! Credit Chandoo
Read more
Tag: excel
Excel For The Infection Preventionist – Preview of APIC Pre-Conference
Microsoft Excel Tips and Tricks The Association for Professionals in Infection Control and Epidemiology is holding their annual conference in[…]
Read more
Excel Print Options – Set Print Area, Print Selection, Margins, and Printing Gridlines
Microsoft Excel Tips and Tricks Excel has many print options. We will look at setting the Print Area, Print Selection,[…]
Read more
New Excel Feature: Place Picture in Cell
Microsoft Excel Tips and Tricks Discover how to insert pictures inside Excel cells with the new “Place Picture in Cell”[…]
Read more
New Excel Feature: Place Picture in Cell
Microsoft Excel Tips and Tricks Discover how to insert pictures inside Excel cells with the new “Place Picture in Cell”[…]
Read more
Excel Formatting Habits That Drive Me Crazy!
Microsoft Excel Tips and Tricks Top 10 poor formatting habits that drive me CRAZY. Effective formatting subtly enhances usability, while[…]
Read more
Move or Copy Worksheet to Another or New Workbook and Keep Layout and Formatting in Excel
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to move or copy a worksheet[…]
Read more
Excel: Generate Random Numbers That Add Up to a Fixed Sum / Value Eg. Add up to 100.
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to create a series of random[…]
Read more
Field List Missing Excel PivotTable | Show Field List in Excel PivotTable
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to show the Field List task[…]
Read more
Sum Multiple Numbers Within a Single Cell in Excel | Add Comma Separated Values in One Cell
Microsoft Excel Tips and Tricks In this Microsoft Excel video tutorial I explain how to sum up numbers stored in[…]
Read more