top of page
Go Ask Debbie BLOG
Search
Excel Tip: PivotTable Formatting
Janey, from Maine, asks, "When I'm working with PivotTables, I like to add specific formatting. But, when I update the PivotTable, my...
0 comments

Excel Tip: Multiply without using Formulas
Janet, of Phoenix asks, “I’m always forgetting how to type the formulas in Excel. Is there an easier way to multiply numbers without...
0 comments

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

Excel Tutorial: Auditing Formulas with Trace Precedents
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...
0 comments

How to Delete Blank Rows in Excel
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...
0 comments

How to Calculate Percentages in Excel
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...
0 comments

Excel Macros Tutorial
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...
0 comments

Excel Tutorial: How Can I Customize SmartArt?
Elizabeth asked, "Once I insert SmartArt in Excel, how can I change the color and look?" What Elizabeth is asking is very smart....
0 comments

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

How to Join Cells using Excel Concatenate
Excel Functions can seem overwhelming, but once they are broken down, they can be very easy, but can provide you with useful results. ...
0 comments

Excel: Relative vs. Absolute Cell Reference
There are two types of cell references: relative and absolute. Relative and Absolute references behave differently when copied into...
0 comments

Excel Tip: Sheet Types
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...
0 comments

Excel Tip: Remove automatic hyperlink formats
Brandy, of Phoenix asks, "Why does Excel automatically add hyperlinks when I type email and Internet addresses? Is there a way to make it...
0 comments

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

Excel Tip: How to Add Superscripts and Subscripts to Cells
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...
0 comments

Excel Tip: Hide Worksheet
Gene, of Phoenix asks, "I have an Excel spreadsheet that contains 3 worksheets. One of them has formulas I do not wish other users to...
0 comments


Excel Tip: Easily update Linked Spreadsheets
Kathy, of Phoenix writes, "I have multiple Excel spreadsheets that link to each other to form monthly reports. However, each year I spend...
0 comments

Excel Tip: COUNTA Function
Emma, of Phoenix asks, "I am a member of a ladies group that plays cards each week. We collect money after the total costs for the...
0 comments

Excel 2007: What happened to the Data Form?
Sue, from Phoenix asks, "I often have temporary employees for entering mass amounts of data from hard copies of information. I used to...
0 comments

Excel 2007 Tip: Merge & Center
Belinda, of Phoenix asks, "I use Excel for spreadsheets, but do not like using headers. Is there a way to center text across my...
0 comments
bottom of page