Embedded Files
UNIT ONE
UNIT ONE
Advanced Formatting, Formulas, and Data Management
Advanced Formatting, Formulas, and Data Management
Week 8 10/20: Advanced Formatting Techniques
You will learn how to use the format categories using dialog boxes and use text functions.
Week 9 10/27: 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/3: 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/10: 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
UNIT TWO
Managing and Integrating Data and the Excel Environment
Managing and Integrating Data and the Excel Environment
Week 12 11/17: 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/24: 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/1: 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/6 - 12/14
Review and Practices
Final Assignment
LEVEL TWO
LEVEL TWO
Google Sites
Report abuse