Part 1 - Microsoft Excel Certification Training
Lesson 1 - Introduction to Microsoft Excel Training
- Microsoft Office Basics
- Creating a Microsoft Excel Workbook
- The Ribbon
- The Backstage View (The File Menu)
- The Quick Access Toolbar
- Entering Data in Microsoft Excel Worksheets
- Formatting Microsoft Excel Worksheets
- Editing Worksheets
- Working with Rows and Columns
- Using Formulas in Microsoft Excel
- Finalizing Microsoft Excel Worksheets
Introduction to Microsoft Excel Exam
Lesson 2 - Intermediate Microsoft Excel Training
- Common Functions
- Working with Lists
- Visualizing Your Data
- Working with Tables
- Advanced Formatting
Intermediate Microsoft Excel Exam
Lesson 3 - Advanced Microsoft Excel Training
- Using PivotTables
- Advanced Functions
- Auditing Workbooks
- Data Tools
- Recording and Using Macros
- Working with Others
Advanced Microsoft Excel Exam
Final Microsoft Excel Exam
Part 2 - Payroll Practice and Management
Lesson 1 - Payroll Practice and Management
Lesson 2 - Introduction to Payroll
Lesson 3 - Determining Worker Status
Lesson 4 - The Fair Labor Standards Act (FLSA)
Lesson 5 - Federal Employment Taxes
Lesson 6 - Payroll Forms
Lesson 7 - Fringe Benefits – Tax-Preferred and Other Related Health Benefits
Lesson 8 - Fringe Benefits – Deferred Comp, Retirement Plans, and Stock Options
Lesson 9 - Other Employee Benefits
Lesson 10 - Calculating Gross Wages
Lesson 11 - Calculating Gross Pay – Additional Topics
Lesson 12 - Paycheck Calculation – Taxes
Lesson 13 - Paycheck Calculation – Voluntary and Involuntary Deductions
Lesson 14 - Gross to Net Paycheck Calculation
Lesson 15 - Compliance – Laws and Reporting
Lesson 16 - Global Payroll
Lesson 17 - Payroll Process and Systems and Audits
Lesson 18 - Paying the Employee
Lesson 19 - Payroll Administration and Management
Lesson 20 - Basic Accounting
Lesson 21 - Exploring Payroll Careers
Lesson 22 - Exam Preparation
Lesson 23 - Payroll Project