Electronic Spreadsheet Fundamentals Certification for PC

Drive 2024 Career Growth by Mastering Spreadsheets Now.

Enhance your spreadsheet abilities in 2024. Mastering Microsoft® Excel can help you qualify for a promotion, earn a raise, or get hired in a new position.

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 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

Electronic Spreadsheet Fundamentals Certification

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®.