Part 2 of our series on Microsoft Office for Mac 2011 brings us to that wonder of spreadsheets: Excel. From doing basic math to shortening and combining pieces of data, or even just keeping track of the things you need, Excel has got you covered. Check out the hidden tips and tricks for Microsoft Excel for Mac 2011 below to start using this amazing application for more than just banking. Most of these tips are not specific to Excel for Mac, but the instructions on how to do them are.
(If you missed it, here’s.) Note: Some of the buttons referenced below are only visible in the Excel toolbar when you expand the Excel window to its full width. Excel will hide some buttons to save space when the window is made narrower. Find the Difference Between Two Dates A little-known formula in Excel is the DateDif function.
Open Excel for Mac and enter two dates next to each other in cells A1 and B1. Next, in another cell, enter this formula You could use this to see how old all of your friends and family are by having one column with their birth dates, a second column that’s auto-filled with today’s date by using the formula. The Draw tab is currently only available for touch or pen-enabled devices in Word, Excel, and PowerPoint. We chose that as the starting point since ink is a complicated feature, and we wanted to make sure we did it right, and obviously the best inking experience is when using a pen, so we wanted to start there.
With DateDif, you can see how many days or months there are between two given dates. This can be very useful in a spreadsheet that looks at the date a bill is sent out versus when it gets paid. It’s also useful a simple one-off formula for you to quickly calculate how many days it’s been since you started your. Open Excel for Mac and enter two dates next to each other in cells A1 and B1. Next, in another cell, enter this formula: =datedif(A1,B1,“d”) This will give you the number of days between the two dates.
To see the number of months, replace the “d” with “m”. Change that to “y” and – you guessed it – you’ve got years. You could use this to see how old all of your friends and family are by having one column with their birth dates, a second column that’s auto-filled with today’s date by using the formula =today(), and a third column with the year formula listed above. There are a few other arguments you can use, too. Check out for the rest. Free adobe photoshop elements for mac.
Clean your Mac of old clutter. Clear up your recycle bin, temporary files and folders, broken permissions and more. Remove installed programs with the click of a button. CCleaner for Mac allows you all the flexibility you need. Select exactly what you want cleaned, include or exclude custom files or folders. Freeware ccleaner for mac.
Constrain Cell Input Selection Let’s say you’re typing some data into a certain area of an Excel for Mac 2011 sheet that doesn’t line up with the top or sidebars. This means you have to use the mouse to keep clicking over to your starting point again when you go to another line.
Instead of doing this, all you have to do is highlight the area you’re working inside of. Then just hit the Tab button to move between cells. When you get to the last cell that’s selected in a row and hit Tab, you’ll be moved to the first selected cell in the next row. Show Alternating Row Colors Staring at data in Excel all day is enough to make you go cross-eyed. While that’s bad for you, it’s really bad for making sure you’re reading the data correctly. A simple solution to this is to add color to alternating rows, which helps you read the data and follow it much more clearly.