Go Ask Debbie BLOG

Splitting data into separate cells in Excel is very easy and there's even a convenient Wizard!

VLOOKUP is one of the most misunderstood functions in Excel. However, it really is simple and powerful when you learn the steps.

Merging cells in Excel is simple with the =CONCATENATE function.

Pivot Tables and Pivot Charts are easy ways to analyze data using Excel. Learn how Excel uses your data to create Pivot Tables and Charts.

Easy to create Map Charts in Excel. Excel 360 and 2019 now offer this awesome feature!

Janey, from Maine, asks, "When I'm working with PivotTables, I like to add specific formatting. But, when I update the PivotTable, my...

Janet, of Phoenix asks, “I’m always forgetting how to type the formulas in Excel. Is there an easier way to multiply numbers without...

Steve from Phoenix is looking for a way of ranking his sales representatives by revenue for a local company. Excel's Rank formula works...

If you have formulas that are based on the contents of another cell, you have precedent cells. If you have problems with a formula or...

This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick...

Did you get your annual raise yet? Many people have asked me over the years, "How do I calculate my annual raise when I know what...

For many years I've had students asking how to create Macros in Excel. So I created this Excel Macros Tutorial to show how you can...

Elizabeth asked, "Once I insert SmartArt in Excel, how can I change the color and look?" What Elizabeth is asking is very smart....

In this Excel Tutorial: Align Cells, you'll learn the basic alignment techniques to make your data visually attractive. You'll also learn...

Excel Functions can seem overwhelming, but once they are broken down, they can be very easy, but can provide you with useful results. ...

There are two types of cell references: relative and absolute. Relative and Absolute references behave differently when copied into...

For those of you who use Excel, I'm always trying to show tips that are helpful and fun at the same time. Did you know Excel has...

Brandy, of Phoenix asks, "Why does Excel automatically add hyperlinks when I type email and Internet addresses? Is there a way to make it...

In this Excel Tutorial – Sum and Percentage Formulas introductory video, Go Ask Debbie teaches simple ways to use the Excel 2003 to...

Julie, of Phoenix asks, “How do I type a superscript font in an Excel cell?” Let’s face it, Excel is a spreadsheet program meant for use...