Microsoft Excel – Level 2

Microsoft Excel – Level 2

Duration: One day

Prerequisites: The course requires that you have successfully completed Excel Level 1 or had more than 6 months using Excel and are familiar with all Excel Level 1 materials.

Description: This course will teach students how to work with large worksheets in Microsoft Excel and use multiple worksheets and workbooks efficiently. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques, such as creating custom number formats. In addition, students will learn how to create outlines, subtotals and how to create and apply cell names. They will sort and filter, consolidate and remove duplicate data, and create and format tables. Finally, they will learn how to audit worksheets for errors, how to protect worksheets and how to share workbooks.

Contents:

• Managing workbooks and worksheets
• Setting sheets up in a workbook
• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets
• Cell and range names
• Linking worksheets
• Using multiple workbooks
• Custom Number formatting
• Using and Creating special formats
• Transposing data
• Create and Modify Tables
• Creating Subtotals.
• Summarizing large amounts of information
• Custom Sorting
• Filtering data
• Removing Duplicate values
• Auditing features and error checking
• Comments and Notes
• Worksheet and Workbook Protection

*NOTE: Half and Full Day Computer Skills classes are not eligible for AAIM’s All Access Training Pass usage.

*Registration will close TEN business days prior to the event.

For Cancellation/Reschedule and Inclement Weather Policy please click HERE

HRCI Accreditation:

N/A|N/A|N/A

---

SHRM Accreditation:

N/A|N/A|N/A

---

CPE Accreditation:

Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.