There was a time when a 40 megabyte hard disk was considered luxuriously big, but with today’s consumption of digital media and common file sizes in the gigabytes, modern terabyte hard drives can fill up fast. By filling up our space we don’t only cause a file management headache, if let get out of control [...]
Tagged delete duplicates, excel automation, Excel Macro, Excel TipsIf you have any spreadsheets where one sheet has some kind of list and the other sheet has some details on the items in the list, you will understand how confusing it can be navigating from one to the other. Microsoft Excel has the ability to create hyperlinks between items in two sheets?
In this article [...]
For small businesses who do not want to pay an outside service for payroll the first port of call is usually Microsoft Excel. Standard office type employees are pretty simple to keep track of, but what if your employees have overtime and other work structures? How do you calculate the correct pay?
Let’s take a look!
First [...]
There is no excerpt because this is a protected post.
Tagged Excel Formulas, Excel TipsA reader asked us if there was a way to edit the contents of a cell in Excel, using an external program, for example Microsoft Word. This was an interesting challenge and we could see how there were many possible uses. Here is how we solved it!
Using Our Solution
If you want to see our resulting [...]
A reader imported some data from an external source and ended up with a table. They asked how they could get a copy of the data itself into the spreadsheet, without the table.
What is going on here?
When Excel 2007 imports data from an external source that can be updated back, such as the data connection, [...]
The new Excel 2007 Conditional Formatting features allow you to apply icons and bar color scales instead of only colors and formats to a cell or array.
So you will see your spreadsheets converted into more powerful visual dashboards!
And this is just the tip of the iceberg! Yes, Excel 2007 brings other enhancements [...]
There is no excerpt because this is a protected post.
Tagged excel learning, Excel TipsThere is no excerpt because this is a protected post.
Tagged excel learning, Excel TipsMicrosoft Excel makes it easy to sort a simple table of data. It is a standard operation that most Excel users will visit often. What, though, if you want to perform the sort as part of a macro?
We know that anything a user can do we can normally do within a macro script, the ability [...]
Canonical URL by SEO No Duplicate WordPress Plugin