Beginner | Excel Semi-Pro


Select Excel’s Used Range on a Mac

March 20, 2012 Beginner

I recently read a good blog post over at Contextures about selecting the actual used range on an Excel sheet, both manually and with VBA. However, using Excel on a Mac makes you keenly aware that there’s no Home button. The used range on a worksheet starts with cell A1 and ends with the last […]

Get the full story …

Settings and Shortcuts for Excel 2003

August 23, 2011 Beginner

I recently found myself with a new, loaner laptop and a brand new copy of Excel 2003 as my default spreadsheet program. This was fine until I realized there were a number of things “missing.” Like shortcuts and settings that I’ve changed over the years to make Excel serve me, instead of the other way […]

Get the full story …

That Damn Delete Key in Excel for Mac

June 27, 2011 Beginner

I have no earthy idea why it took me so long to figure out how to delete the contents of a cell or range in Excel for Mac. Ever since I bought my MacBook Pro I’ve known the Delete key on a Mac isn’t really a Delete key. I mean, since my background is with […]

Get the full story …

Regional Date Formats in Excel

June 21, 2011 Beginner

I recently returned from two weeks in Ireland where I installed a couple of Excel reporting systems and came across the dreaded regional date settings. My computer is set for the US region, whereas the client’s computers were set for the UK region. When I mention regional settings on my computer, I’m talking about Windows […]

Get the full story …

Spreadsheet Size in Excel for Windows

April 29, 2011 Beginner

I’ve been thinking about converting my older XLS files to the newer XLSX format, but ran into a quirk that stopped me. Maybe I’m just too impatient. Here’s my story. A Few Facts First Excel versions 97-2003 (Windows) have a file extension of XLS and the worksheet size is 65,536 rows and 256 columns. In […]

Get the full story …

Spreadsheet Size in Excel for Mac

April 28, 2011 Beginner

Most people think an Excel workbook with an XLS file extension has only 65,636 rows and 256 columns in the worksheet. They would be wrong. Of course, if you don’t use a Mac there’s no way for you to discover this fact. When you open an Excel 97-2003 Workbook (*.xls) file in Excel 2007 or […]

Get the full story …

5 Obvious Things that 80% of People Don’t Know About Excel

April 15, 2011 Beginner

This is a Guest Post by Excel Everest. | For whatever reason, most people remain unaware of these 5 ultra-simple and ultra-useful aspects of Excel. Many people use Excel on a daily, or at least a weekly basis. But many of these people also haven’t had or taken the time to dig into even […]

Get the full story …

Table Names in Excel

April 11, 2011 Beginner

Excel Tables are given default names (Table1, Table2, etc.) when they are created. Table names are similar to defined names, which makes them easy use in formulas or to select data. There are a couple of ways to select all the data in a Table by using the Table name. 1) select the Table name […]

Get the full story …

Table Design in Excel

March 31, 2011 Beginner

I’m want to start using Excel Tables when building my spreadsheets. But first it’s instructive for me to explain how I think about “unofficial” tables or data tables as I like to call them. How I Think About Tables A data table is just a range of data, or a region of data that Excel […]

Get the full story …

Migrating to Tables in Excel

March 30, 2011 Beginner

My first epiphany with Excel was realizing how powerful it could be if you put all your data into data tables. Over the years Excel began to incorporate data tables. First in Excel 2003 as “Lists” then as official “Tables” in Excel 2007. (I’m not sure about the evolution in Excel for Mac versions.) The […]

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