Excel for Mac 2011 Tips and Tricks

Author

Released

6/4/2015

This course features tons of tips to make Excel for Mac 2011 users more proficient and productive with the popular spreadsheet program.

Learn the top shortcuts, find out how to most efficiently navigate and control the display, and discover the best ways to select, enter, and format data. The course also includes ways to leverage drag-and-drop features, shortcuts for formulas and operations, data management efficiency techniques, guidelines for working with charts efficiently, and a selection of quick tips.

Topics include:

Converting formulas to values with a simple drag

Entering today's date or time instantly

Accessing Ribbon commands from the keyboard

Creating split screens fast

Navigating and zooming quickly

Entering data more efficiently

Performing calculations without formulas

Applying formatting with keyboard shortcuts

Quickly cleaning up extra spaces and deleting duplicate entries

Skill Level Appropriate for all

4h 31m

Duration

46,276

Views

Show MoreShow Less

- [Voiceover] Hi I'm Dennis Taylor and welcome toExcel for the Mac 2011: Tips and Tricks.In this course I'll show you how to use this popularsoftware more efficiently.Most Excel users are under utilizing it becausethey're not aware of the many key stroke shortcutsand techniques that they could be using.Whether you need to create formulas quickly,split data into columns, apply numeric formats,create charts in a flash, accelerate data entry choresor just learn the top 10 shortcuts that every Exceluser should know, you can save time by learningsome of the tips in this course.

We've got a lot to cover so let's get started withExcel for the Mac 2011 Tips and Tricks.