Archive for Excel

Word for Chromebook

Need help installing Word on your Chromebook? Call Skylark NetWorks at (516) 308-2759 or read on.

One of the most frequent calls I’ve received lately as a computer repair technician revolves around the new Chromebooks using the ChromeOS Operating System. The typical call sounds like this:

Caller: How do I install Microsoft Word on my Chromebook? I can’t get Word to work on my Chromebook.

Skylark NetWorks: Do you have a Windows or a Mac version of the Microsoft Word software that you are trying to install on your Chromebook?

Caller: Yes! I have the _________ version. (Fill in the blank)

Skylark NetWorks: You can’t install that on your Chromebook because your Chromebook isn’t a Mac or a Windows computer, but —

Caller: So what do I do? I need a word processor, and I prefer to use Word.

Skylark NetWorks: I would recommend you go to the Microsoft Office Apps website at http://office.microsoft.com/en-us/web-apps. Then you can use and share your Word documents anywhere.

Get Started with Microsoft Office Web Apps

Since Chromebook users cannot install Microsoft Word on Chromebook because Chromebook uses ChromeOS, a Linux-based operating system which doesn’t support Microsoft Windows-based or Mac-based software.

This doesn’t mean that you’re locked out forever from working on Word documents. There are a number of ways Chromebook users work on Word documents, and their Excel and PowerPoint files, too. You already know these are important file types, and having access to them is a must.

Download Microsoft Office Web App

This Chrome app was generated by Microsoft to allow Chromebook users the chance to go online and use Microsoft Office programs such as Word, Excel, and PowerPoint. The web app also gives you access to Microsoft’s Cloud Storage Service called SkyDrive.

Alternate: Google Docs

Have you heard of Google Docs? It’s a free service from Google. Google Docs can open and edit most of the popular file types of Microsoft Office including Microsoft Word and Excel documents. Since your Chromebook was also developed by Google it is the perfect tool for working with Google Docs.

FYI: Anyone Can Use Microsoft Office Web Apps

Microsoft’s Office Web Apps aren’t just for Chromebook users. Your can use it on just about any desktop, laptop, netbook, or tablet computer.

Office 2010 – Better Than Ever

If you run a small business you should have (or upgrade to) Microsoft Office 2010 Home and Business Edition. This package provides you with the leading word processing package, Microsoft Word, and the top spreadsheet application, Excel. Beyond that you get PowerPoint for quick and easy presentations (slideshows), and Outlook for managing your email.

Outlook 2010 has proven so useful for managing my email because I have so many email accounts. People always ask “Which email address should I use for you, Robert?”, and I say, “Any of them; they all go to the same place.” That place is my Outlook Inbox. The other great thing about Outlook is the mail rules. I can have it flag or sort important messages as they arrive. Flags add them to my To Do list so I know which mails need to be looked at right away.

Download Microsoft Office Home and Business 2010 today and try it free for 3 days. And feel free to leave comments or questions here.

Excel’s Fill Handle

Friday evening I was meeting some friends for dinner. One of the worked at a law office on Seventh Avenue, so I met them at their office beforehand. They were performing some calculations on an Excel spreadsheet at the time, and as they were copying and pasting a repetitive formula, I showed them this trick which I am now sharing with you. This technique works with Excel 2003 and Excel 2007.

Sometimes you may want to use a formula or function repeatedly. In such a case you can easily copy the formula from one consecutive cell to another by using the fill handle of the active cell. The fill handle is the small square that appears in the lower right corner of an active cell.

To Copy A Formula With The Fill Handle

  1. Activate the cell that contains the formula you want to copy. (This typically done by clicking on the cell).
  2. Use the mouse to grab the fill handle. (Move the mouse close enough to the fill handle so that the mouse turns into a small black cross. When you see the small black cross, hold down the left mouse button.)
  3. While holding down the left mouse button, drag the mouse down for as many rows as you would like to copy to. Then release the left mouse button.
Fill Handle Usage

Fill Handle Usage

That’s it! The references used in the formula will be updated to match the new rows, so that the answers will be correct for the new rows.


Post Comments or Questions with the link below. Keep up-to-date with Skylarking: By Email or RSS Newsfeed or on Twitter. You can also send questions with my email form.

Work Hour Timesheet with Excel

A client of mine asked me to setup a worksheet for them that calculates the number of hours they worked in a day based upon the time they arrived at work and the time they left. They also wanted it to deduct the number of hours they took for lunchbreaks.

Here’s the simple spreadsheet I setup for them using Microsoft Excel:

Hours Worked Spreadsheet

Hours Worked Spreadsheet

Columns A and B were used to fill in the days and dates. Columns C and D were used to enter the times they came and went each day. Column E indicates time taken for lunch. Finally, column F performs the calculations.

In cell F3, the end of the row for Monday, the following formula was used:

=24*(IF(C3>D3,D3+1-C3,D3-C3))-E3

That formula was then copied and pasted into the rows below.

It may seem a little complex, but it’s a very versatile formula. Since they occasionally work a night shift, they sometimes leave work after midnight. Leaving after midnight means they left in the AM, and the formula, C3>D3, will be able to detect if they came in during the PM hours and left in the AM hours.

A regular 9 AM to 5 PM workshift is calculated as =24*(D3-C3)-E3. The portion in parentheses calculates the difference between the time they arrived and the time they left. The 24* converts it to hours out of 24 hour day, and the -E3 deducts their lunchbreak.

If they work a nightshift the Excel uses the formula =24*(D3+1-C3)-E3. The portion D3+1 indicates that they left work in the AM of the following day.

Post Comments or Questions with the link below. Keep up-to-date with Skylarking: By Email or RSS Newsfeed or on Twitter. You can also send questions with my email form. I’m looking forward to hearing from you.