I have a worksheet with duplicate values that need to be removed. There are two columns of data, with Date in column A and Weight in column B. The Date values are for each day and extend to the end of June. Some of the Weight values repeat as you can see in the picture. …
I recently downloaded and opened a CSV file from a web browser and one of the data columns was supposed to have date information. There was date-type information, but Excel recognized it as being a text field. I really needed a valid date range for graphing purposes, so I used the Text to Columns feature …
I’m new to the Excel 2008, the Mac version. Every time I open the program it just looks weird. What bothers me is that the default view is Page Layout. I guess it comes like that out of the box. The regular Excel programs (Windows) are all setup with a Normal page layout as the …
You can pin documents to the recent file list in Excel 2007 so they stay on the list and are easily found. Select the Office button to see the list of Recent Documents. Click the gray pin next to a document and the pin turns green and “pins” the document to the list. It’s great …
One of the things I frequently do is Freeze Panes in my worksheet. This command locks data into place, like column headings, row headings, or both. So when scrolling down (or to the right) I know what type of data I’m looking at because the headings are still visible. [UPDATE: There’s a command hidden from …
I have a Lose It! app on my iPhone that automatically backs up data to my web account. The website makes it easy to download reports using CSV files, essentially giving you a file with the raw data. A lot of programs export data using comma separated values, known as CSV files because of the …
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. …
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 …
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 …