Excel
Why XML in Excel is Important to Financial Professionals
While recently conducting an advanced level 3 Excel class, I was teaching the section which deals with XML. If you’re not in the know - XML stands for eXtensible Markup language - essentially a way of “tagging” data in an organized taxonomy. XML is open - which means that you can basically create your own [...]
Microsoft Office Training in Southern New Jersey - Buy Two, Get One Promotion
I’d like to spend a few minutes of your time to let you know that my company, Springhouse Education and Consulting Services, is offering three Microsoft Office 2007 classes in Southern New Jersey this summer. We’ll be offering classes in Word, Excel and Outlook 2007.
Also, here is something to entice you to register. We are [...]
More Counting in Excel
Last year I wrote a blog about using the COUNT and COUNTA functions in Excel, but what if you wanted to count the number of cells within a range that meet a single criterion that you specify. For example, I want to know how many OFF2007NF classes we’ve scheduled for this year (see following image).
In [...]
Customize Excel Comments
If you know how to create comments, did you know that you can change that drab yellow box to a more exciting, eye-catching shape? Ok, this is easy to do in Excel 2003 and is a great way to catch people’s attention. After you insert a comment on an Excel cell, select the border of [...]
Custom Order Sort in Excel
Sorting is a popular and easy feature in Excel. You simply select a cell in the column you want sorted and the click Sort button to sort in ascending or descending order. But what if you wanted an exception to the normal sort rules? In the following image the list is sorted by last name. [...]
Benefits of Training
People are either thrilled or upset when their company tells them they have to attend a training. I do understand that when you are already very busy, it just makes your day more stressful to be away from your desk for several hours. BUT, when you take the time to learn the most efficient way [...]
What to do with hard to view data points on a pie chart
Pie charts are great for data that is arranged in one column. Pie charts show the size of items, proportional to the sum of the items. The data points in a pie chart are percentages of the whole pie. But what do you do when some of your values are so small that they display [...]
Imported date field not recognized in Excel
A while back a client was having some problems with an imported text file in Excel. There were date columns that he needed to be formatted as dates so that he could calculate with them (i.e. # of days elapsed between two dates). In Excel, he tried a Text to Columns and change the date [...]
Copy and Paste Techniques for Excel
Most people know how to do a basic copy and paste procedure within the same Microsoft application. But did you know that when you copy cells of data from Excel, the way you paste it into Word or PowerPoint will produce different effects?
In both the 2003 and 2007 versions of Microsoft Office, you will find [...]
Import Excel data into Outlook Contacts
If you have ever collected customer information in an Excel 2003 workbook and wished you could transfer it to an Outlook contacts folders, the good news is that it is relatively simple to bring into Outlook 2003. You should start by examining the Excel data and making sure it is arranged into a proper list.
