Electronic Spreadsheet Fundamentals Certification for Mac

Electronic spreadsheets are most useful for organizing and analyzing numerical data, performing calculations automatically, creating charts and graphs, and tracking trends, particularly when dealing with budgets, financial planning, and data comparisons; essentially, any situation where you need to manipulate and visualize large sets of numbers efficiently. Our Electronic Spreadsheet Fundamentals Certification for MAC program will help you to develop your spreadsheet skills. Mastering Microsoft® Excel can help you gain a promotion, earn a raise, or get hired. Spreadsheets enable you to manage projects and analyze data efficiently. Furthermore, they can draw conclusions and present information. As a Microsoft® Certified Trainer and Excel expert, Jackie Kiadii will teach you the spreadsheet skills you need to advance in your career. As a result, you will be able to work more efficiently and achieve better results.

What You'll Learn

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

• Creating Workbooks
• Basic Formulas and Functions
• Formatting
• Tables and Charts
• Date and Text Functions
  

You’ll Also Receive:

• All courses include a PDF version of the presentation slides along with any additional materials or resources provided by the presenter
• Certification upon successful completion of the program
• One certification exam attempt is included
• Advance your career

Electronic Spreadsheet Fundamentals Certification for Mac Program Outline
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®.