How To - Excel

Excel - Set the default number of sheets for your workbooks

By default Excel already includes3 sheets in your new workbooks (sheet1,... Read more

Excel

August 8, 2012 at 09:16 AM

VBA - A button to save filename of a document to a cell

I need to create a button that saves a modified document as a number in a... Read more

Excel

November 21, 2012 at 09:03 AM

Excel - Copy row 1 to new worksheet on condition

Copying rows from one sheet to another can be done in Excel. The worksheet... Read more

Excel

November 6, 2016 at 02:11 PM

Excel - Comparing results/scores

I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and... Read more

Excel

February 20, 2010 at 02:39 AM

Excel - Count rows where 2 conditions are true

I am having problems counting the # rows of problem reports where the... Read more

Excel

November 21, 2011 at 11:35 AM

VBA VB6 - When the test DIR (directory) goes down

The simplest test to check out if the path of a directory is valid is of... Read more

Excel

June 1, 2010 at 07:32 AM

Complicated Lookup in Excel

I have two spreadsheets that I am trying to use a lookup on. It's a little... Read more

Excel

August 27, 2010 at 02:14 AM

Excel - Textbox issue: Time displayed in decimal format

I have an EXCEL sheet with a list containing various data including hours... Read more

Excel

October 8, 2012 at 09:56 AM

Excel - Hide rows with zero value in Multiple sheets

Please help me in making a macro in the Excelsheet that: I can hide the... Read more

Excel

April 13, 2010 at 03:47 PM

Excel - Calculate the sum based on multiple criteria

I have the following: A B C INC-001 05/2009 10 INC-002... Read more

Excel

September 21, 2012 at 06:37 AM

VBA - Updating a procedure or function

Managing a workbook using only the standard functions of the spreadsheet may... Read more

Excel

June 17, 2013 at 04:37 AM

Excel - Macro to format report

Hopefully I can word what I am looking for in a way that makes sense to... Read more

Excel

April 13, 2010 at 03:53 PM

Excel - Set first letter in uppercase

I need a formula to set the first letter of each word in upper-case. Try... Read more

Excel

April 12, 2012 at 08:49 AM

Excel - How to find duplicates

This tutorial explains how to manage duplicate entries on the different... Read more

Excel

January 28, 2015 at 04:20 AM

Excel - Convert hours in decimal

I have a table with following columns: - Duration (format [h]: mm: ss) -... Read more

Excel

October 3, 2011 at 07:20 AM

Excel - How to align all common list?

I have 4 columns. the first two (A & B) columns are list of cheques i... Read more

Excel

April 14, 2010 at 06:43 AM

Excel - Billing template

It is impossible to make a billing model that suits all cases, the example... Read more

Excel

May 17, 2010 at 03:17 PM

VBA - A form and multilingual collections of objects

This Demo Based on Several customer satisfaction survey. Two languages are... Read more

Excel

May 17, 2010 at 03:28 PM

Excel - Adding the current date in cell

If you want to insert the current date in a cell in following format DD... Read more

Excel

March 12, 2011 at 05:32 AM

Excel - Concatenate cells "line by line"

have one cell that has names separated with alt + enter. On the other cell,... Read more

Excel

May 1, 2012 at 12:27 PM

Subscribe To Our Newsletter!