Excel for Office 365 for Mac, Excel 2019 for Mac, Excel 2016 for Mac Excel for Mac 2011 Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. With MAC addresses in A1:A100, you can enter =FormatMAC(A1) in cell B1 and fill down. If you'd rather update the values themselves, select the range with MAC addresses and run the following macro (which uses the FormatMAC function).
By Excel 2011 for Mac has fantastic date and time calculation capabilities. When using Excel worksheets, you need to know just two secrets: Each day is represented by a whole number, called a serial number, and portions of days are represented by decimal fractions. Finding today with Excel formulas Some days, you wake up and don’t even know what day it is. Excel doesn’t have this problem. To have Excel return the current date, select the cell you want Excel to show the current date in and type the cell formula =TODAY and then click the green Enter button. The selected cell displays today’s date, and Excel automatically changes the format of the cell to Date.
Getting today’s serial number in Excel 2011 for Mac Each day has its own serial number in Excel. If you follow the steps in the preceding section, you don’t see the serial number in the selected cell because Excel knows the formula represents a date. If you want to see the serial number instead of a date format, you can manually change the format of the selected cell to Number by selecting Number in the Ribbon’s Number Format pop-up menu. In Excel, to add and subtract any number of days, just add and subtract whole numbers.
You’re probably wondering how Excel arrived at the serial number of today. To find out, enter 1 in a cell and apply the Date format. The date changes to January 1, 1900 — the first day that Excel knows about. Every day in Excel is the number of days after 1/1/1900. Finding the time of day with Excel’s formatting tools Because Excel works with days as whole numbers, you might guess that portions of days are fractions. Well, you’d be right!
Starting with a whole number representing a date, append.5 (one-half day) to a date serial number to represent noon. Apply the Time number format, and the time changes to 12:00 PM.
Go ahead and try some different decimals. Formatting a date in Excel 2011 for Mac You have at least three different ways to apply a date format. Perhaps the fastest is to select a cell or cell range, and then click the Home tab of the Ribbon. In the Number group, click the pop-up button under the Number group title and choose Date to display the date as m/d/yy, where m represents the month’s number, d represents the day number, and yy represents a two-digit year. Excel has many more built-in date formats, which you can apply by displaying the Format Cells dialog by pressing Command-1 and then clicking the Number tab. You can also display the Number tab of the Format Cells dialog by clicking the Home tab on the Ribbon. Then click the pop-up button under the Number group title and choose Custom from the pop-up menu.
When the Format Cells dialog displays, select the Date category. Choose a Type from the list. Choosing a different Location (language) or Calendar type changes the date types offered.
2016-03-22 16:-03-22 16:33:07 Bookkeeping English Microsoft Excel is an integral part of most businesses. See 10 easy tricks, shortcuts and hacks that will help you become an Excel super. 10 Microsoft Excel Tricks, Shortcuts and Hacks QuickBooks. Microsoft Excel is an integral part of most businesses. Some people relish the capabilities of Excel, finding it a useful tool that allows them to easily manage, report on and illustrate tables of data. Others, however, find it tedious and downright obtuse, unable to make heads or tails of what exactly Excel can do from them, aside from keeping things in neat columns and rows. Below is a list of 10 easy tricks, shortcuts and hacks that will put you on the path to being an Excel super user.
(Note: There are a many versions of Excel, including versions for desktop (Windows, Mac OS X) and mobile (iOS and Android) operating systems. The visuals are screenshots from a Mac version of Excel. These tips were confirmed to work on a Mac and Windows desktop, but may apply to other versions as well. This piece also discusses keyboard shortcuts for use in a Windows OS. For Mac, replace the “Control” key with the “Command” key.) 1. Select All Cells in a Spreadsheet at Once Do you need to reformat your font or make some other sweeping change to your Excel workbook? An easy way to select all the cells in the document is to click on the square in the upper left-hand corner where the top of the rows and columns meet.
Clicking on this box will highlight all of the cells in the document, even empty cells. If you prefer keyboard shortcuts, you can also select all cells by pressing the “Control” and “A” buttons at the same time. Copy a Worksheet From 1 Workbook to Another This is helpful if you’re looking to merge data across two workbooks together and don’t want to reformat all of your data in either workbook. Start by opening your “source” workbook (the one with the data you want to copy).
![Microsoft Microsoft](/uploads/1/2/5/4/125461658/585665699.jpg)
Next, open your “target” workbook (you want to copy to). This can be a new workbook or an existing workbook. In your source workbook, look towards the bottom left-hand corner and find the name of the sheet you want to copy. Unless the name of the worksheet is changed, it should have a name like “Sheet1” or something else. Right-click on the sheet you want to copy (if on a Mac with a single-button mouse, you may need to hold down the Control key while clicking).
Select “Move or Copy ” from the menu. Choose the workbook to copy it to and where in the order of the existing worksheets you want it to be. Alternatively, you can simply move the worksheet from one workbook to another by dragging it with your mouse, but it might be safer to copy it, at least until your comfort level with Excel increases. Add Multiple Rows and/or Columns at Once You might find you need to add multiple rows and columns at one time. For example, let’s say you want to add multiple rows in the middle of a set of data. Select two rows, starting with the row directly below where you want the new rows to appear. (Note: You can choose as many rows as needed.) 2.
Right-click (PC) or CTRL-click (Mac), and select “Insert” from the dropdown menu. The list has now been truncated to include the values you chose. But as you can see by the circled row numbers, the other data has not been deleted; it is simply “hidden” in this view. You can easily undo any sorting by clicking on the Filter button at the top and choosing “(Select All)” again.
Copying Figures From 1 Worksheet to Another in the Same Workbook You can use a figure from one cell on one worksheet in another cell on another worksheet without having to copy and paste them. This is especially handy for calculations where a number might change month to month, but you have one worksheet that figures everything on a year-to-date basis.
![Autosubtract Excel For Mac Autosubtract Excel For Mac](/uploads/1/2/5/4/125461658/503214043.png)
The example below shows the first tab of the workbook that displays Year-To-Date sales, expenses and revenues totals. The second tab is labeled JAN, and the third tab is labeled FEB. This copies the formula across the cells, but changes the values relative to the new cell’s position. For example, in the B3 cell, the formula will read “=SUM(JAN!B3+FEB!B3)” without quotes. In the C3 cell, the formula will read “=SUM(JAN!C3+FEB!C3)” and so on. The same thing can be done if you drag the box downward instead of across; this copies the formula into the column.
So the B3 column formula will read “=SUM(JAN!B3+FEB!B3)”, while the B4 formula will read “=SUM(JAN!B4+FEB!B4)”. Transpose Columns and Rows If you need to move pre-existing data from columns to rows—or vice versa—do not despair. Select the data you want to transpose, and copy it (CTRL-C).
Click on the cell where you want to place the data, and then right-click to get the dropdown menu. From that menu, select “Paste Special”. This is really handy if you’re looking for quick total or average without having to enter a formula. Other Essential Shortcut Keys and Tips Here are some other shortcuts that you may not be aware of. Some of these are universal across all Microsoft Office products (e.g. Word, PowerPoint, etc.), but are still very helpful when using Excel.
Undo button: This little backwards arrow undoes the last action you took in the worksheet. It’s the graphic equivalent to using the CTRL-Z keyboard shortcut. CTRL-SHIFT-Up or Down Arrow: Selects all of the cells directly above (up arrow) or below (down arrow) of the selected cell. (NOTE: This only selects cells above and below that have data).
SHIFT-F11: Creates a new worksheet in your current workbook called “Macro1.” (Note: In Mac OS, you may need to add the “Fn” key for this shortcut to work). CTRL-Home: Navigates to cell A1. CTRL-End: Navigates to the last cell that contains data.
Format Painter (the little paintbrush): Select the cell whose format you want to copy. Then click on Format Painter in the upper toolbar (or click on the paintbrush in the pop-up format menu that appears) and click on the cell you want to format. In the below example, we clicked on the “Expenses” cell, clicked on Format Painter and then clicked on “Revenue.”. As you’re, it’s understandable to want to use spreadsheets to manage your finances.
But as sales pick up and your numbers become increasingly complicated, it’s best to graduate to an. Sure, these tips will allow you to get a better handle of your Excel spreadsheets, but the time saved and errors avoided by using financial software are well-worth the transition. For more tips on managing the financial side of your business, be sure to check out our to learn the daily, weekly, monthly and yearly tasks you need to manage to keep your books in order.