The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. With our Excel courses, you will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer. Continuing on, learn to control data – a skill that is a significant benefit to your organization. You will learn to analyze massive amounts of data, extract information from it, and present the information clearly using more advanced features. Finally, explore the most advanced features to work in collaboration with others to deliver actionable organizational intelligence while keeping and maintaining workbooks for multiple purposes with efficiency in mind.
Module 1: Introduction to Spreadsheets and Basic Formulas
- Navigate the Excel user interface
- Use Excel Commands
- Create and Save a Basic Workbook
- Enter Cell Data
- Use Excel Help
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas and Functions
- Insert, Delete and Adjust Cells, Columns Rows
- Search for and Replace Data
- Use Proofing and Research Tools
Module 2: Introduction to Spreadsheet Appearance and Organization
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Styles and Themes
- Apply Basic Conditional Formatting
- Create and Use Templates
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties
Module 3: Intermediate Formulas and Basic Data Lists
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date and Time Functions
- Work with Text Functions
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Module 4: Intermediate Data Structure and Visualization
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Module 5: Workbook Consolidation and Collaboration
- Use Links and External References
- Use 3-D References
- Consolidate Data
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Module 6: Data Auditing and problem Solving
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Using the Goal Seek Feature
- Forecasting Data Trends
- Create Sparklines
- Map Data
