Electronic Spreadsheet Fundamentals Certification for PC

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 PC 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 program will enable you to:

• Creating Workbooks
  
• Basic Formulas and Functions
  
• Formatting
  
• Tables and Charts
  
• Date and Text Functions
  
• All courses include a PDF version of the presentation slides along with any additional materials or resources provided by the presenter
  
• One certification exam attempt is included
  
• Advance your career
  

Electronic Spreadsheet Fundamentals Certification 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®.