Electronic Spreadsheet Fundamentals Certification for Mac

Lock in your job by mastering spreadsheets! Discover the secrets of these powerful tools on your Mac.

People who know how to use electronic spreadsheets like Microsoft® Excel have a better chance of avoiding layoffs, qualifying for promotions, receiving raises, and getting hired. By mastering these applications on your Mac, you will be able to accomplish more in less time while impressing your colleagues.

Vital across occupations, spreadsheets enable you to manage projects and analyze data quickly. In addition, they can draw conclusions and present information. 

The Electronic Spreadsheet Fundamentals Certification for Mac program will enable you to:

• Create and format workbooks
• Use functions and formulas
• Manage data in lists and tables
• Create charts
• Earn a prestigious certification
• Advance your career

We have packed a large volume of interesting and useful content into five engaging webinars.

Electronic Spreadsheet Fundamentals Certification for Mac

Webinar 1: Creating Workbooks

• Five ways to create an Excel workbook in less time
• How to navigate the workbook
• The quickest way to select data
• Entering text and numbers
• Copying, cutting, pasting, and moving data
• Saving workbooks to multiple formats

Webinar 2: Basic Formulas and Functions

• Creating basic formulas
• Creating basic functions
• AutoSUM, COUNT, AVERAGE, etc.
• Absolute vs. relative references

Webinar 3: Formatting

• Formatting worksheets
• Easy ways to copy formats
• Using styles
• Conditional formatting

Webinar 4: Tables and Charts

• Using lists and tables
• Creating charts
• Formatting charts
• Modifying charts

Webinar 5: Date and Text Functions

• Absolute vs. relative references (continued)
• Date functions (with commonly used examples)
• Text functions
• How to lock your cells to protect functions

We are not affiliated, endorsed, or sponsored by Microsoft or Microsoft Excel®.