Microsoft® Certified Trainer and Excel expert Jackie Kiadii will give you the valuable spreadsheet skills you need to power your career to the next level. You will learn how to work more efficiently and achieve better results.
What You'll Learn
- Create and format workbooks
- Use functions and formulas
- Manage data in lists and tables
- Create charts
- Earn a prestigious certification
- Advance your career
Training Overview
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
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®.
Who Should Attend?
- Individuals with no experience with spreadsheets
- Self-taught spreadsheet users who are stumbling along
- Professionals who need firm basic skills to progress to pivot tables
- People who receive workbooks created by others
- Managers who must make data-driven decisions
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
CareerLearning Quality Commitment
CareerLearning wants you to be satisfied with your purchase. If this program does not meet your expectations, email us at support@careerlearning.com.
