ddalgleish on Squidoo
Excel MVP and author; Microsoft Office consultant; owner of contextures.com website and blog.contextures.com
ddalgleish's Lenses
-
Easy Data Entry With Excel Drop Down Lists
- Add drop down lists to your Excel workbooks, and it will be easier to enter data. For example, with a drop down list of products in an order form, customers...
- Updated 308 days ago | Easy Data Entry With Excel Drop Down Lists › data entry
-
How to Create an Excel Dashboard
- To summarize the key data in a complex Excel workbook, you can add an Excel dashboard. Your Excel dashboard can be a simple sheet with a few key numbers and...
- Updated 249 days ago | How to Create an Excel dashboard › excel charts
-
Block Pivot Table Changes
- In some workbooks, you might want to prevent users from making any changes to an Excel Pivot Table. You want the users to see the pivot table, but not change...
- Updated 189 days ago | Block Pivot Table Changes › excel pivot table
-
Excel Pivot Table Tutorial Videos
- Excel pivot tables can quickly summarize a large amount of data, such a sales records, or service call details. Learn how to work with pivot tables, and you...
- Updated 56 days ago | Excel Pivot Table Videos › excel
-
How to Find Free Excel Help Online
- Do you ever get stuck while you're working in Excel, and can't figure out a formula, or find the feature you need? If you look for the answer in the Excel H...
- Updated 15 days ago | Free Excel Help › excel
-
How to make an Excel Waterfall Chart
- With an Excel waterfall chart, you can show a starting price, then a series of increases and decreases. The increases and decreases are shown in different colors,...
- Updated 102 days ago | excel waterfall charts › chart in excel
-
Improve Excel Sheets By Naming Cells
- In Excel you can select one or more cells, and give that group of cells a name. For example, if you list the months, you can select those 12 cells and name...
- Updated 293 days ago | Name Cells in Excel › excel formulas
-
How to Create Date Formulas In Excel
- If you use Excel, you probably have to do some date calculations, and they can be a bit tricky to get working correctly. In this lens, I will show you some of...
- Updated 14 days ago | Calculating Dates In Excel › dates in excel
-
Excel Weight Tracking Workbook
- Enter your weight loss goals, and track your weekly weight loss. A chart shows your target, and weight loss to date. This lens shows you how the Excel weight...
- Updated 129 days ago | Excel Weight Tracking Workbook › excel bmi
-
Contextures - Excel Tips Website
- You can find hundreds of time-saving Excel tips and tutorials at the Excel Tips and Tutorials website and in the Contextures Blog. Also, view short Excel Video...
- Updated 6 days ago | Contextures › excel
- How to Clean Up an Excel List
- By following a few simple steps you can remove duplicates from a long list of items in Excel. In Excel 2007, there is a built in command that quickly removes...
- Updated 16 days ago | Remove Duplicates in Excel 2003 › duplicates
- How To Create a Christmas Planner in Excel
- This year, don't plan your Christmas activities and spending on scraps of paper -- use Excel instead. In Excel, it's easy to type a few lists, then...
- Updated 228 days ago | How To Create a Christmas Planner in Excel › christmas
- Debra Dalgleish - Excel Tips
- Debra Dalgleish is a Microsoft Excel MVP, the author of 3 pivot table books, and a Microsoft Office consultant, based in Ontario Canada. Self-employed since...
- Updated 67 days ago | Debra Dalgleish › contextures
- Highlight Excel Results With Color
- In Excel, you can use color to make specific cells stand out on the worksheet -- spotting the colored cells is easier on your eyes than reading through a long...
- Updated 145 days ago | Highlight Cells That Are Too High or Low › conditional formatting
- Report Filters in Excel Pivot Tables
- In a large pivot table, it can be difficult to find the information you need. However, by adding Report Filters at the top of an Excel Pivot Table, you can...
- Updated 37 days ago | Report Filters in Excel 2007 Pivot Tables › excel pivot filter
- Add a Picture in an Excel Comment
- A picture can help explain data in an Excel worksheet. For example, you could include a picture each item in a product list. Or show the flag of each country...
- Updated 191 days ago | Add a Popup Picture in Excel › cell picture popup
- How to Organize Excel Data in Tables
- In Excel 2007 and Excel 2010, you can create named Excel Tables to organize your data. Excel Tables have many features to help you sort, filter and view your...
- Updated 20 days ago | Excel data › excel 2007
- You Need Pivot Tables!
- Instead of creating long and complicated Excel formulas, you can quickly summarize thousands of rows of data in an Excel pivot table, with just a few clicks...
- Updated 38 days ago | Beginning Pivot Tables in Excel 2007 › excel
- How to Copy a Macro to Your Excel Workbook
- When you search on the internet for a solution to your Excel problem, you might find a sample Excel file, with a macro that does exactly what you need. The...
- Updated 3 days ago | Copy Excel VBA Code to Your Excel Workbook › excel
- Highlight Birthdays in Excel List
- With Excel conditional formatting, you can use a bright color to highlight cells on a worksheet. Use this feature to make it easy to find the employees who have...
- Updated 103 days ago | Highlight Birthdays in Excel List › conditional formatting
« Prev
1
Next »
1 - 20 of 20 lenses | see all
Leave ddalgleish a Message
Trophies
Profile
- Joined:Aug 11, 2008
- Lenses rated:29
- My blog: blog.contextures.com
- My Twitter: twitter.com/ddalgleish
- Favorite blog: blog.contextures.com
- Great site: www.contextures.com
- My other blog: www.pivot-table.com
- Don't miss: excelvideotutorials.blogspot...
Check out these great lenses!
-
You Need Pivot Tables!
-
Instead of creating long and complicated Excel formulas, you can quickly summarize thousands of rows of data in an Excel pivot table, with just a few clicks...
