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

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

Skip to product information
1 of 1
On-Demand
Certification
Option
Regular price $607.00
Regular price Sale price $607.00
Sale Unavailable
View full details
INFORMATION
Training Overview

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

Recommended Audience
Who Should Attend?
  • Individuals with no experience with Excel
  • Self-taught Excel users who are stumbling along
  • Professionals who need firm basic skills to progress to pivot tables
  • People who receive Excel workbooks created by others
  • Managers who must make data-driven decisions
What's included
Training includes
  • Certificate of Attendance
  • All resources and training materials
About

Expert Presenter

Jackie Kiadii
  • ["Founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm","Helping clients leverage technology to increase their productivity and profitability since 2001","Provides curriculum development, consulting, and training in Microsoft 365® applications","Microsoft® Certified Trainer and Microsoft® Certified Expert – Excel"]

Customer Reviews

Be the first to write a review
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)