HOT Excel !!! Tips & Tutorials

COUNTIF(): How to Count How Many Numbers In Your MS Excel List Are Greater Than The Average

admin — Mon, 28 May 2012 11:56:16 +0000

google_ad_client = "pub-9661801294124307"; google_ad_channel =""; google_ad_width = 728; google_ad_height = 90; google_ad_format = "728x90_as"; google_ad_type = "text_image"; google_color_border =...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Tutorial – How To Remove Carriage Returns From A CSV File

admin — Mon, 21 May 2012 11:19:57 +0000

google_ad_client = "pub-9661801294124307"; google_ad_channel =""; google_ad_width = 300; google_ad_height = 250; google_ad_format = "300x250_as"; google_ad_type = "text_image"; google_color_border =...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Tutorial – Create Your Own Default Excel Template

admin — Fri, 18 May 2012 11:59:22 +0000

By BJ Johnston When you create or open a new work book in Excel, you are presented with Excel’s default standard version. You may not like that style. You may prefer to have just one...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How to Password Protect Individual Cells in Microsoft Excel

admin — Thu, 17 May 2012 11:56:32 +0000

By Paul Anthony Brown It can be very useful to password protect spreadsheets so that other people cannot accidentally (or even deliberately) overwrite valuable data of formulas and functions....

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Tips – Create a Table of Contents in Excel

admin — Wed, 16 May 2012 11:13:10 +0000

By B.J. Johnston If like me you have Excel workbooks that appear to be ever growing and contain more worksheets than are comfortable to navigate, then a great solution is to add a Table Of Contents...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Trial Dialog — Create an Excel VBA UserForm with Information Icon and Timer Enabled OK Button

admin — Tue, 15 May 2012 11:47:09 +0000

By Mark Kubiszyn OK, so let’s begin. We will set up the UserForm and then add in the VBA Code. First Open Excel and press ALT+F11 to enter the VBA Editor. Go to the File Menu and choose...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Tips – Subtracting Dates In Excel

admin — Mon, 14 May 2012 11:10:34 +0000

By B.J. Johnston Quite often in Excel you will want to subtract one date from another. This could be to check length of service of an employee, how long a customer has taken to pay a bill or the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Tips – How To Create A Watermark In Excel

admin — Fri, 11 May 2012 11:39:52 +0000

By BJ Johnston Strictly speaking you cannot create a ‘Water Mark” in Excel. Unlike MS Word where a lot of time people use ‘”Confidential” or “Draft” to...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

5 Microsoft Excel Tips for Your PPC Management

admin — Thu, 10 May 2012 11:52:29 +0000

By M Hammersley Many individuals these days use Excel for PPC tasks. Excel can make the life of a PPCer much easier, but if you are going to use it correctly, you need to have a little knowledge...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

MS Excel Tutorial – How To Create A Custom Theme In Excel 2007

admin — Wed, 09 May 2012 11:06:57 +0000

By B.J. Johnston Using a document theme is a great way to personalize and standardize your own personal or company image for consistency and a professional look in your Microsoft Office documents....

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]