Electronic Spreadsheet Fundamentals Certification for Mac
Master Excel for Mac: Formulas, Formatting, Charts, and Time-Saving Spreadsheet Skills
Spreadsheets are essential for organizing and analyzing numerical data, running calculations automatically, creating charts and graphs, and tracking trends for budgets, financial planning, and data comparisons.
The Electronic Spreadsheet Fundamentals Certification for Mac helps you build practical Microsoft Excel skills you can use immediately at work. You will learn how to create and manage workbooks, enter and organize data efficiently, and apply key tools that make spreadsheets faster, cleaner, and more reliable.
Led by Jackie Kiadii, a Microsoft Certified Trainer and Excel expert, this program focuses on real fundamentals: building formulas and functions, formatting worksheets professionally, creating tables and charts, and using common date and text functions. You will also learn how to lock cells to protect formulas so your work stays accurate and consistent.
By the end of the program, you will be able to work more efficiently, improve the quality of your spreadsheets, and better present data and conclusions in a professional format.
We are not affiliated, endorsed, or sponsored by Microsoft or Microsoft Excel®.
Course Outcomes
- Create and manage Excel workbooks on Mac efficiently
- Build basic formulas and core functions (SUM, COUNT, AVERAGE)
- Format worksheets using styles and conditional formatting
- Create tables and charts and modify chart outputs
- Use common date and text functions accurately
- Protect key cells to preserve formulas and structure
- One certification exam attempt is included
Outline
Session 1: Creating Workbooks
- Create workbooks quickly and navigate efficiently
- Enter and edit data; select and move ranges
- Save to common file formats
Session 2: Basic Formulas and Functions
- Write formulas and use AutoSum and common functions
- Understand absolute vs. relative references
Session 3: Formatting
- Apply styles and copy formats
- Use conditional formatting
Session 4: Tables and Charts
- Build tables and create charts
- Format and modify charts
Session 5: Date and Text Functions
- Apply commonly used date and text functions
- Lock cells to protect formulas
What's Included
The Electronic Spreadsheet Fundamentals Certification for Mac course includes the following:
-
Course access and recordings
Access your course and any included recordings through your customer dashboard -
Course materials
Includes PDFs of the presentation and any additional resources provided by the expert presenter -
Certificates and exams
- Certificate of attendance included with all courses
- Certification courses include one exam attempt
- Successful graduates will receive an official certification along with verified digital credentials
-
Class experience
- Live sessions are small and focused to support questions and discussion
- Self-paced on-demand courses allow you to move through the material on your own schedule
Who Should Attend?
Certifications
Your Instructor
Jackie Kiadii
- Founder of Phoenix Computer Consultants
- LLC
Jackie Kiadii is founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm. Since 2001, she has helped her clients leverage technology to increase their productivity and profitability. Ms. Kiadii provides curriculum development, consulting, and training in Microsoft 365 applications. She is a Microsoft Certified Trainers and Microsoft Certified Expert–Excel. Organizations her firm has served include: City of Atlanta, Coca-Cola Company, Emory University, and Georgia Pacific.
Why CareerLearning?
-
✔
Learn from Industry Experts
Courses are led by professionals with real-world experience, ensuring you gain practical insights and skills. -
✔
Focus on Practical Skills
The learning approach emphasizes skills-based education, enabling you to immediately apply what you learn to your career. -
✔
Tailored to Industry Needs
Programs specifically designed for various sectors like Education, HR, and Nonprofit, addressing industry-specific challenges and regulations. -
✔
Enhance Career Growth
Courses designed to help professionals advance their careers, improve their knowledge, and make a greater impact in their organizations. -
✔
Flexible Learning Options
Both live and on-demand options available, learn at a pace and time that suits your schedule. -
✔
Potential for Certifications
Leading certifications and third-party accreditations to help you showcase your achievements. -
✔
Access to Valuable Resources
Course materials and resources provided to support your learning and implementation of new skills.
- Choosing a selection results in a full page refresh.
- Opens in a new window.
A Guide To Common Formative Assessments And Defined Learning Outcomes