Beginner | Excel Semi-Pro | Page 2


Set the Number of Default Worksheets in Your Workbook

March 8, 2011 Beginner

I opened Excel 2007 today and realized there were 3 worksheets in a new workbook. That’s better than the 16 or so Excel had in times past, but more than one worksheet in a workbook is overkill, if you ask me. To change this travesty in Excel 2007, I’ll choose the Office Button > Excel […]

Get the full story …

View Excel Spreadsheets with the Google Docs Viewer

March 7, 2011 Beginner

If you have a Gmail or Google Docs account, getting a quick look at a Microsoft Excel file is now supported with the Google Docs Viewer. Just click the View link beside the file name in your email and the Google Docs Viewer will open to give you a quick look. Now you can send […]

Get the full story …

Convert Coordinates for Your GPS with Excel

March 1, 2011 Beginner

A few years ago I found myself just south of Paris, France one Sunday with a car and the inclination to do some sight-seeing. Since I was alone and don’t speak French my saving grace was Google Earth and a Tom Tom GPS navigation device. Tom Tom allows GPS coordinates to be entered as a […]

Get the full story …

Open File As Read Only in Excel

February 25, 2011 Beginner

To discourage users from making any changes to a macro file you can have the file recommend Read-Only when it’s opened. To show this pop-up box when the file opens: Choose File > Save As Select Tools > General Options (on the Save As dialog box) Check the box for Read-only recommended Click OK Name […]

Get the full story …

My First Excel 2011 Chart

February 21, 2011 Beginner

Right now I’m on the Ski slope and this particular chart served to help me kill two birds with one stone. I needed to show my daughter which ski pass would be most beneficial to her wallet and produce a chart for this article. Charts should speak for themselves, loud and clear. This one compares […]

Get the full story …

The Mini Toolbar in Excel

February 11, 2011 Beginner

The Mini Toolbar is nice to have when you need to do basic formatting and the Home tab is not displayed. Introduced in Excel 2007 and available in Excel 2010, the Mini Toolbar appears above the shortcut menu when you right-click a cell, range, chart, shape or other object. Note: There is no Mini Toolbar […]

Get the full story …

F2 in Excel for Mac

February 9, 2011 Beginner

Switching to a Mac has its advantages but Excel shortcuts isn’t one of them. The main gripe I have is that keyboard shortcuts should be the same in every version of Excel, yet the Windows and Mac worlds are light-years apart. The F2 key is a fundamental shortcut I learned early in my Excel life. […]

Get the full story …

Add Freeze Sheet Panes to the Quick Access Toolbar

February 4, 2011 Beginner

Add a one-click Freeze Panes command to the Quick Access Toolbar in Excel 2010 and 2007. This command icon is conveniently hidden from the Ribbon and is named Freeze Sheet Panes. In a previous post I made the recommendation to add the Freeze Panes command to the Excel Quick Access Toolbar, but recently found out […]

Get the full story …

Excel 2011 Preferences

February 2, 2011 Beginner

In my opinion, there are some default Preferences that should be changed in Excel 2011 [Mac] after taking it out of the box, like changing worksheets to the Normal view. I’ll share specific picks for General, View, Edit, Calculation, and Ribbon preferences. General Preferences Uncheck Open Excel Workbook Gallery when application opens. It’s rather annoying. […]

Get the full story …

Copy a Help Topic URL in Excel 2010

January 26, 2011 Beginner

Excel 2010 Help is normally connected to so each Help topic has a specific web address (URL) that can be easily copied. This is only for Windows computers running the latest Excel version 2010. You can check the connection status to by hitting the F1 key to bring up the Help screen, then […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …