2010 June | Excel Semi-Pro

June 2010

Excel on the Web – Another Spreadsheet in the Cloud

June 30, 2010 General Update
Thumbnail image for Excel on the Web – Another Spreadsheet in the Cloud

I decided to test the new Microsoft Excel Web App and tell you about my experience in creating a simple spreadsheet, give you a look at the interface, and share my initial opinion. The Excel Web App – Getting Started In order to use the Microsoft Excel Web App a Windows Live account is required. […]

Get the full story …

Generate a List of Dates in Excel

June 28, 2010 Intermediate
Thumbnail image for Generate a List of Dates in Excel

There are times when generating a list of dates comes in handy. Perhaps you need to log something every day for an entire year. Or maybe you’re tracking stock prices and want to skip the weekend and only use weekday dates. How about a list of dates for each week of the year? Or just […]

Get the full story …

Microsoft Excel Date Systems for Windows and Mac

June 23, 2010 Intermediate

Microsoft Excel has two different date systems that you will probably never think about because they exist in two different worlds: Windows or Mac. However, if you are sharing Excel files between Windows and Mac computers the potential exists for a great deal of confusion around dates. What is a Date System? Dates are represented […]

Get the full story …

Navigating Regions in Excel

June 21, 2010 Beginner

Navigating large regions of data can be very quick and easy using keyboard or mouse shortcuts. You can also select entire rows or columns, although multiple row and column ranges work slightly different with each method. Using the Keyboard to Navigate a Range of Data I prefer to navigate ranges using the keyboard. Holding down […]

Get the full story …

Select a Current Region of Data in Excel

June 19, 2010 Beginner

Finding the current region adjacent to the active cell is done in numerous ways. An quick and easy way to select a region of data that has a few quirks.

Get the full story …

Organizing Data Into Regions

June 17, 2010 Beginner

Organizing data into regions or ranges is the first step to harness the power of Microsoft Excel. If your data set is small, using the full power of Excel probably doesn’t mean very much. But as your data grows it’s important to let Excel do most of the work. Using features like sorting and filtering, […]

Get the full story …

Expand Menus in Excel 2003

June 15, 2010 Beginner

Short article and video of how to expand menus in Excel 2003 so you can see all items on each menu.

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