Tips for Excel, Word, PowerPoint and Other Applications

Article Index

This is a catalog of tips I've posted in addition to articles I have in the queue. Eventually, I'll get it organized into what I consider essentials, the core tool kit, and other nice to know topics. The last section lists articles I've written but haven't marked up in HTML yet.

Feedback and input on what you'd like to see covered is always welcomed and appreciated.

Index of Posted Articles

  1. Quick Tips
  2. The 10-Day Test
  3. 15-Second Pivot Tables - Building Proficiency
  4. Adding Passwords to PDF Documents
  5. Adding Passwords to .ZIP Archives
  6. Arranging Documents for Better Workflow?
  7. Attaching E-mails to an Outlook E-mail
  8. AutoFiltering in Excel
  9. AutoFormat in PowerPoint
  10. Basic Data Cleansing
  11. Basic SUMIF and COUNTIF
  12. Basic Text to Column (Fixed Width)
  13. Bullet Charts in Excel
  14. Cameras, Copy Picture, Paste Picture Link and more really cool stuff
  15. Cell Parsing: LEFT, MID, RIGHT
  16. Changing the Default Save Location For Your Excel Files
  17. Using the Character Map
  18. Charting in Excel
  19. Charting in PowerPoint
  20. Cleaning Data With Notepad
  21. Commenting and Reviewing Tools in Adobe Acrobat
  22. Comparative Series Charts in PowerPoint
  23. Conditional Formatting: Cell Value Is
  24. Conditional Formatting: Formula Is
  25. Creating Custom Lists in Excel
  26. Creating Custom Quick Launch Shortcuts
  27. Creating Waterfall Charts
  28. Data Validation
  29. Creating Default Excel Workbooks and Worksheets
  30. A Quick Overview of Excel's Drawing Toolbar
  31. Dynamically Linking Data From Excel Into Powerpoint
  32. Excel 101
  33. Excel Error Messages
  34. Fill Colors in the Office Suite
  35. A Quick and Easy Way to Fill in Blank Cells
  36. Formatting Multiple Spreadsheets Simultaneously
  37. Formatting Org Charts in PowerPoint
  38. A Function is a Function is a Function ... Right?
  39. Inserting Excel Tables in PowerPoint
  40. Inserting Linked Data From Excel Into Word
  41. Introduction to Arrays
  42. Introduction to Basic Pivot Tables in Excel
  43. Introduction to Forms Tools
  44. INDEX-MATCH Combos
  45. Introduction to INDIRECT
  46. Introduction to Logical Statements and Logical Math
  47. Introduction to SUMPRODUCT
  48. Introduction to VLOOKUP
  49. Keyboard Shortcuts in Excel
  50. Making custom "art" in PowerPoint
  51. Matching Two Lists in Excel
  52. Math with Dates, Why there are only 38711 - TODAY() days before Christmas
  53. Naming Ranges
  54. Calculating Net Work Days in Excel
  55. Paste Special (aka ALT + E, S)
  56. Printing Web Pages
  57. Save As Options for Websites
  58. Saving PowerPoint Tables as Graphical Images
  59. Scorecards in Excel
  60. Selective Exclusion or Inclusion using SUMPRODUCT
  61. Simple intro to PowerPoint menus and work panes
  62. Snapshot Tool in Adobe Reader
  63. Stacking Data for Better Analysis
  64. Structure of a PowerPoint Page
  65. SUMIF with wildcards
  66. Advanced SUMPRODUCT - part 1
  67. Advanced SUMPRODUCT - part 2
  68. Advanced SUMPRODUCT - Part 3
  69. Advanced SUMPRODUCT - Part 4
  70. Track Changes in Excel
  71. Track Changes in Word
  72. Using VLOOKUP to Match Lists
  73. VLOOKUP-MATCH Combos
  74. VLOOKUP and IF/ISERROR combos
  75. Using the Watch Function in Excel
  76. What is a Model?
  77. LARGE, SMALL, and RANK
  78. Highlight Top N Values in a List
  79. OFFSET and Dynamic Ranges
  80. Using Named Formulas in Excel
  81. The CHOOSE Function in Excel

Material Developed But Not Posted

  1. Importing Text (1 of 4). A 4-part series of tips
  2. Using the Auditing Toolbar and F9
  3. Dynamic Charting
  4. Index Values
  5. Building a Negotiations Model, Step 1
  6. Building a Negotiations Model, Step 2

Planned Articles

  1. Why Models are Like Ogres
  2. Cascading Filters
  3. Selective Exclusions from a table (advanced)
  4. Advanced Text to Column
  5. Selecting Values From Single Column Lists (simple)
  6. Selecting Values From Single and Multiple Tables (advanced)
  7. Scenario Modeling
  8. Searching and Navigation Tips (Ctrl-G, Ctrl-H, and Ctrl-F)
  9. Quick Tips (stoppers, send to mail recipient, etc)
  10. Processing Data Sets (SCALE)
  11. Survey to Data Table
  12. VLOOKUP/INDIRECT combos