Show navigation

Available in:

Audio & Reference Manual

Microsoft® Excel® for Mac: Timesaving (and Jaw-Dropping) Productivity Tips

Are you overwhelmed by the work on your plate that can’t be delegated to anyone else?Do you feel like it takes too long to get things done in Excel, but you don’t have the time to learn the shortcuts and new features? Or have you ever thought to yourself, there’s got to be an easier way? More often than not, you are right. There is an easier and FASTER way. We’re giving you the opportunity to really learn from the best: internationally renowned author and global trainer, Vickie Sokol Evans, who will help you deliver better results faster by using more of the technology you know and love ??" Microsoft Excel for Mac. Manage and format data like never before using jaw-dropping tips and tricks. Whether you are an Excel guru or you just get by, learn simple and practical best practices that will help you produce professional-looking spreadsheets with minimal effort. This topic is perfect for business users and for the experts.
Purchase Options

More Program Information

Why Lorman?

Over 31 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Agenda

Save Time in Excel
  • Quickly Select a Table in Excel
  • Use Excel's Autofit to Instantly Resize Columns and Rows
Manage Your Data With Minimal Effort (Using the Feature Vickie Wants to Marry)
  • Format a List as a Table
  • Sort and Use Autofilter to Find Data
  • Expand the Table as You Type
  • Create a Calculated Column With Minimal Effort
  • Instantly Add a Total Row to Your Table
Perform Magic
  • Separate Full Name Column Into First and Last Name
  • Autocalculate to Show off Your Math Skills
  • Flag Duplicates Values in Your Column
Reduce Errors
  • Paste Values Instead of Formulas
  • Flip Your Data Using Transpose Text
Listen to Your Data
  • Find Anomalies Using a Heat Map
  • See the Trend in Each Row Using Sparklines
  • Summarize Your Data Using a Pivot Table
Share Nicely With Others
  • Make Your Worksheets Stand out
  • Print to Fit on One Page
  • Send a Worksheet – Not the Entire Workbook – to a Colleague
Purchase Options

More Program Information

Why Lorman?

Over 31 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Credits

Audio & Reference Manual

This program does NOT qualify, nor meet the National Standard for NASBA accreditation.

Purchase Options

More Program Information

Why Lorman?

Over 31 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Faculty

Vickie Sokol Evans

Vickie Sokol Evans

The Red Cape Company, LLC

  • Founder and CEO of The Red Cape Company, LLC the global leader in engaging Microsoft®, Google® and Apple® productivity training
  • Microsoft® Certified Trainer with more than 15 certifications
  • Former business and data analyst for Microsoft®
  • Improv comedy performer having studied and performed in New York and Texas
  • Bestselling author of the “100 Tips” series for Microsoft® Productivity Tips
  • Recognized as one of the best Microsoft® productivity trainers for PC and Mac around the globe
  • International reputation with students in over 50 countries
  • 99% of attendees recommend Vickie’s sessions
  • 100% of IT pros recommend RedCape
  • Preferred trainer to Bill Gates’ immediate team as well as for The Gates Foundation and Microsoft®
  • Other high profile clients include The New York Times, Pepsico, Procter & Gamble, Dell, American Airlines, Celebrity Assistants in NY, LA and London, and more
  • Lead instructor of The Red Cape Academy, a membership platform to educate end users on best practices and basic to advance productivity skills
  • Co-host of the “Be the Ultimate Assistant Podcast with Bonnie & Vickie”
  • Contributor for Executive Secretary magazine
  • Thought leader in defining what it means to be tech-savvy
  • Collaborator with Microsoft® on features to include in the latest versions based on end user needs
  • Bachelor’s degree, University of Texas at Austin
  • Can be contacted at 877-814-6413, [email protected], www.redcapeco.com/vickie, www.linkedin.com/in/vsevans or facebook.com/redcapeco or twit-ter.com/redcapeco
Purchase Options

More Program Information

Why Lorman?

Over 31 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today
With This Course

Access to all training products for one year
$699/year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.

Product ID: 399636
Published 2017
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!