More than half of Excel users never learn how to use 9 out of 10 of its most powerful features.
In three sessions of Excel Level IV, you will work with Excel at an advanced project-based level. You will be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples of completed Excel projects include professional-looking budgets, team performance charts, sales invoices, exercise logs and summaries. This course is ideal for students, clerical workers, managers, bookkeepers and instructors.
You will learn how to use the following tasks:
- Create, manage and link workbooks and worksheets
- Create and apply custom formats and layouts to cells
- Create tables, pivot tables and charts
- Apply formulas and functions for numeric calculations
- IF statements
- Text handling
- Data lookups
- Perform what-if analysis
This course addresses the following soft skills: leadership, communication, confidence, planning, organizing and prioritizing, problem solving, decision making and creating and editing written reports.
Note: If you also take Excel Level II and Level III you will earn a Certificate in Advanced Excel from USI.