3 Tips and Tricks for Excel on Mac

April 19, 2016

0 comments

Excel Shortcuts for Mac   Excel Skin   excel tips   excel tricks   Excelskin   Mac Excel Shortcuts   mac shortcuts for excel   Mastering Excel   Microsoft Excel   Microsoft Excel for Mac  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

1) Select All with a click

Instead of executing the Select All shortcut, there is a simple button built into every spreadsheet that will select all data in that spreadsheet.

 

2) Using the Formula Builder

We can’t always remember every formula in Excel, which is why we have the Formula Builder! With the Formula Builder you can search for specific formulas by name, insert the function, add your data, and receive any assistance through the Formula Builder. Open the Formula Builder by clicking the fx Insert button in the Formulas tab, or by executing the Formula Builder shortcut.

You will be able to search categorically when clicking the button in the Formulas tab.  

3) Remove Duplicates

Excel is one of the best programs for removing duplicate values. All you must do is copy your data into an Excel spreadsheet, and click on the Remove Duplicates button. I found this especially useful when I found out I had duplicate .jpg files taking up space on my computer, Excel identified and helped me remove those files with a click.

How do we do it? Select the data you’d like to analyze, then click the Remove Duplicates button in the Data tab.

A dialog box will appear telling you how many duplicates were found. Click Remove Duplicates in the bottom right to erase these duplicates from the spreadsheet.



Leave a comment

Comments will be approved before showing up.