5.7.4 The IF Function

I am having such a great time learning more about Excel! I have yet another instance where this class has helped at work. I deal with spreadsheets daily at work. This specific chapter I learned how to use sumif's. I was able to utilize it yesterday. The spreadsheet I used it on consisted of four departments - Install, Service, E-Service, and Telecom. I needed to allocate how much was being charged to each department so I assigned each employee a letter (I, S, E, T) depending on what department that person was in. I was able to tell my function to sum depending on the letter. This was my third time dealing with this spreadsheet. This was so useful.

5.3.4 Data Entry Facts

Excel has many functions that can be hard to remember. One feature that I particularly like that is mentioned in this section of Chapter 5 is the "Freeze Pane Feature"! This is a feature that I like to use when dealing with a form that needs to be properly filled out. An example I have is, as usual, from work. The employee's have a tool allowance that I keep track of on an excel spreadsheet. Who ever managed it before did not utilize the "Freeze Top Row" which contains the names of what goes into each field. They must have had the fields already memorized. Me, being a recent hire, could not remember each field. Each time I would scroll to enter a deduction I could not remember what information went where since scrolling down move away from the top row that contained the titles of each column. That's when "Freeze Top Row" came in handy for me. There is so much more to learn in Excel and I am here for it. :-)

4.10.4 Table of Contents

Today at work I ran into having to make a Table of Contents. I had not done this on my own before. I didn't realize that your heading style had to be specific in order for the automatic table of contents to populate. It certainly helped to be knowledgeable in Microsoft Word. I was able to quickly figure this out. Now my Accounts Payable Guide has a more professional look! 

2.3.2 File Storage Options

 I feel file storage is such an important topic and many tend to forget about physical storage devices since you can store a lot on a "Cloud". I see people pull their pictures/files from their phones and move them to a different storage device which tends to be a laptop. They eventually run into the same issue. The device also runs out of storage. A storage device that I would have like to see further information on is the external hard drive. It very briefly mentions it. I know a lot of photographers use external hard drives. This way they don't over load their working computer devices. I have not found the need to utilize one myself as I currently use an outdated MacBook to store my pictures. With 1TB of memory, I am set for a little while. I am concerned this dinosaur of a MacBook might give out on me so I will be moving files over to an external hard drive soon! 

"Los Angeles? That’s just a big parking lot where you buy a hamburger for the trip to San Francisco." -John Lennon