COURSE BREAK DOWN
UNIT ONE
Advanced Formatting, Formulas, and Data Management
Week 8 10/21: Advanced Formatting Techniques
You will learn how to use the format categories using dialog boxes and use text functions.
Week 9 10/28: Advanced Functions and Formulas
You will learn how to use some complex calculations for worksheets containing statistical, financial, logical, database, and other data.
Week 10 11/4: Working with Tables and Data Features
You will learn how to use the table feature to manage a range. You will learn how to use to tools to validate data, search for and remove duplicate records, and convert text to a table and convert a table back to a normal range.
Week 11 11/11: Summarizing and Consolidating Data
You will learn how to summarize and filter data using a variety of methods and present visually summarized data for analysis.
UNIT TWO
Managing and Integrating Data and the Excel Environment
Week 12 11/18: Using the Data Analysis Features
You will learn how to use the What-if Analysis tools to assist with accurate data analysis for decision-making and management tasks.
Week 13 11/25: Importing, Exporting, and Distributing Data
You will learn how to bring data into an Excel worksheet from external sources and how to export data into a worksheet into another program. You will also learn how to distribute Excel data using a variety of methods.
Week 14 12/2: Automating Repetitive Tasks and Customizing Excel
You will learn how to create macros and customize the ribbon to save time for frequently repeated tasks.
Weeks 15 and 16 - 12/7 - 12/15
Review and Practices
Final Assignment