Home

Excelguru.ca

Tips and pointers for Excel and other MS Office applications
Access | Excel | General | Internet Explorer | Other | Outlook | Powerpoint | Publisher | Word | Articles by Date | Articles by Last Update | Site News by Date
Articles | Blog | Consulting | Contact Me | Downloads | RibbonX Book | About Me | Experience & Accolades | Links | Donations

Contents

  • Articles
    • Access
    • Excel
    • General
    • Internet Explorer
    • Other
    • Outlook
    • Powerpoint
    • Publisher
    • Word
    • Articles by Date
    • Articles by Last Update
    • Site News by Date
  • Blog
  • Consulting
  • Contact Me
  • Downloads
  • RibbonX Book
  • About Me
  • Experience & Accolades
  • Links
  • Donations

User login

  • Create new account
  • Request new password

Home » Articles

List of All Excel Articles

Node: TitleNode: Created Time
Understanding Dates in Excel2008-03-29 22:01
User Defined Function To Show Formulas In A Cell2006-01-11 00:00
User Defined Function To Sum And Round To Two Decimal Places2006-01-10 00:00
UseTemplate Add-in2006-08-30 22:13
Using a Treeview Control2007-02-01 23:47
Using Help in Your Applications2006-10-21 13:28
Using PDFCreator with security options set2006-06-09 14:03
Using Styles in Excel - Why and How2008-05-01 22:19
Where To Place VBA Code2006-06-02 22:35
XLG Favourites Add-in2006-09-20 20:13
« first‹ previous12

Get your copy of RibbonX now!

Live via Twitter...

  • kpuls: Budget (verb) 6 letter word meaning hours upon hours of effort to prepare something that will never be accurate.
  • kpuls: Very Cool: RT @Discovery: BREAKING: Josh And Jake Harris Sign On For Discovery Channel’s ‘@DeadliestCatch’ http://ow.ly/2Azhx
  • kpuls: I have a friend who uses a USB splitter @k_sasha . I believe he's pretty happy with it.
  • kpuls: @k_sasha 2*22 Sasha. 100% you wont' regret it, you will with a single monitor
  • kpuls: Books updated for board #1. Now to do family business ones, then look at stuff for board #2. I think I suffer from volunteerism.
more

Fresh from the blog...

  • Calendaring with the iPhone
  • Enabling Outlining Commands on a Protected Worksheet
  • Macro to wrap an existing formula with IFERROR
  • My VMWare Setup Steps
  • Built in Ribbon Customizations in Office 2010
more

Popular content

Today's:

  • Outlook 2007 Time Saving Tips - Creating Email Groups
  • Printing Worksheets To A PDF File (Using Early Binding)
  • Function to Check if File or Directory (Folder) exists
  • Retrieve Data From A Database To Excel Using SQL
  • Using a Treeview Control

All time:

  • Printing Worksheets To A PDF File (Using Early Binding)
  • Retrieve Data From A Database To Excel Using SQL
  • Function to Check if File or Directory (Folder) exists
  • Using a Treeview Control
  • Outlook 2007 Time Saving Tips - Creating Email Groups
  • Export A Range Of Excel Data To A Database
  • Function To Get File Name From Specific Directory
  • Downloads
  • Quickly Eliminate Duplicate Records From A Specific Column
  • Creating an Access Database (on the fly) Using VBA and SQL

Last viewed:

  • Have Excel read a range of data to you
  • User Defined Function To Sum And Round To Two Decimal Places
  • Function to Check if File or Directory (Folder) exists
  • A message to forum cross posters
  • Creating an Access Database (on the fly) Using VBA and SQL

Professional Office Developers Association Articles

  • If you're upgrading to Outlook 2010…
  • Do you use Office Marketplace?
  • Attach files to an Outlook email using VBA
  • Creating UNC paths from mapped drives
  • technorati claim, ignore
more

Terms of service: The content on this site is Copyright Ken Puls. All techniques and code are shared for general use, and are available for you to use in your own work without permission. Reproduction, copying and reposting of the articles on this site, however, is prohibited without express permission of the author.

Who's online

There are currently 0 users and 11 guests online.