Microsoft Excel
Lesson 1: Getting started
Lesson 1: Getting Started with Microsoft Excel 2010
- Identify the Elements of the Excel Interface
- Create a Basic Worksheet
- Use the Help System
Lesson 2: Performing Calculations
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert, Manipulate, and Delete Cells, Columns, and Rows
- Search for and Replace Data
- Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Define the Basic Page Layout for a Workbook
- Refine the Page Layout and Apply Print Options
Lesson 6: Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
Lesson 7: Customizing the Excel Environment
- Customize General and Language Options
- Customize Formula Options
- Customize Proofing and Save Options
- Customize the Ribbon and Quick Access Toolbar
- Customize the Functionality of Excel by Enabling Add-Ins
- Customize Advanced and Trust Center Options.
Microsoft Excel - Intermediate
Lesson 1: Creating Advanced Formulas
- Apply Range Names
- Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
- Leverage Questions and Testing to Write Formulas
- Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3: Organizing Worksheet Data with Tables
- Create and Modify Tables
- Sort and Filter Data
- Use Summary and Database Functions to Calculate Data
Lesson 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- Filter Data Using Slicers
- Analyze Data Using Pivot Charts
Lesson 6: Inserting Graphics
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
Lesson 7: Enhancing Workbooks
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
Microsoft Excel- Advance
Lesson 1: Automating Worksheet Functionality
- Update Workbook Properties
- Create and Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
Lesson 2: Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Lesson 3: Analyzing Data
- Create Spark lines
- Create Scenarios
- Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis Tool Pack
Lesson 4: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells In Different Workbooks
- Merge Workbooks
Lesson 5: Building a PivotTable
- Insert a PivotTable
- Create a PivotTable Based on External Data
- Categorize PivotTable Data
- Customize a PivotTable
Lesson 6: Analyzing Data Using Pivot Tables
- Create Custom Calculations in a PivotTable
- Restructure a PivotTable
Lesson 7: Presenting PivotTable Data Visually
- Format a PivotTable
- Present a PivotTable in a Pivot Chart
- Print PivotTables and Pivot Charts
- Lesson 8: Exporting Excel Data
- Export Excel Data
- Import a Delimited Text File
- Integrate Excel Data with the Web
- Create a Web Query
Lesson 9: Examining Data Using Math Functions
- Analyze Sales Data Using Math Functions
Lesson 10: Manipulating Data Using Text and Information Functions
- Manipulate Data Using Text Functions
- Validate Data Using Information Functions
Lesson 11: Working with Templates and Charts
- Create Advanced Templates
- Create Advanced Charts
Lesson 12: Managing Data in Workbooks
Retrieve and Paste Data
Clean Data in Workbooks
Courses:
Language Training
Exam Test Preperation
Management Courses
Soft Skills
Medical Training Courses
IT Courses
Banking & Finance Courses
Free Consultation
Enter Your Name*
Enter Your Email*
Enter Your Phone Number*
Microsoft Excel - Basic