Creating charts in Excel 2010 is pretty straightforward. Select your data, choose your chart type, and presto, you have a basic chart. While the three tabs you see after you create that chart might seem a bit overwhelming, they give you a whole lot of flexibility for getting your chart the way you want. Let’s take a look at adding a background graphic to the chart. Read the rest of this entry »
We’ve recently developed new resources to help clients achieve their Microsoft certification goals. We now offer a directory of Microsoft certification training, organized according to specific certification paths and the associated courses. More specifically, we have the Microsoft Office Specialist certification training.
Learn about Excel 2010! This recorded webinar covers changes to the ribbon, the new backstage view, sparklines and slicers. Read the rest of this entry »
A vertical Lookup or most commonly known as a VLOOKUP is one of the most popular Lookup functions. It will search vertically across row headings and return the information from that row that is being searched. Your lookup value MUST be in the leftmost column but it doesn’t necessarily have to be in Column A; it just must be the leftmost column of your table array. To find the column that has your search result, you simply start counting the columns in the table array from left to right! Read the rest of this entry »
Are you getting tired on always grabbing the mouse when you are working in Excel? Especially, when the mouse just isn’t behaving – you know, sometimes you are just having a “bad mouse” day!
Well, even though Microsoft Excel 2010 seems very mouse driven, you can still use the keyboard to perform some of the actions that you need. I am sure that you are familiar with the old standards of Ctrl + N to get a new workbook, Ctrl + S to save a workbook, and Ctrl + O to open a workbook, just to name a few. Read the rest of this entry »
Sparklines are a neat addition to Microsoft Excel 2010. Sparklines are miniature charts that are actually embedded in the background of worksheet cells. They’re really useful for getting a quick idea of trends in data. Read the rest of this entry »
I recently received a question regarding my article about Microsoft Office 2010 Backstage View. “Is there anyway I can also remove the list in Recent Places.” Let’s take a look at that. Read the rest of this entry »
In my last article, I explained how to create grouped worksheets. Let’s take this one step further and now turn these grouped worksheets into a template to use over and over again. Before you type in any specific information, simply go up to the Office button, and choose Save As. When the dialog box comes up, be sure to change the type of file to be a Excel Template: Read the rest of this entry »
Do you create multiple worksheets that use the same labels? Do you copy and paste the same labels over and over again? Want a quick way to set up as many worksheets as you need in one step? Let me show you a quick and easy way to do just that. We will just say that you are in charge of budgets for many departments within your company. You need to keep track of the same information for each department. So at the beginning of each month, you create a separate worksheet for the each of the departments and type the same category labels over and over. Wouldn’t it be nice to do it only once? Not a problem. Once you open the file simply click on the first sheet tab, hold down the shift key and click on the last sheet tab. All of the sheet tabs will turn white. Read the rest of this entry »
Formatting dates in Microsoft Excel is easy, right? All you have to do is: Read the rest of this entry »
