MICROSOFT EXCEL

[academia_heading title=”Course Outline”]

[academia_course_sections title=”BEGINNER SKILLS IN MICROSOFT EXCEL”][academia_course_lesson title=”CREATING AND EDITING WORKSHEET: 1″]

1. Setting Excel Options
2. Creating a New Workbook
3. Adding and Moving Data in Worksheet
4. Creating a Worksheet Adding Data
5. Modifying a Worksheet
6. Adding Formulas
7. Manipulating Worksheets
8. Print a Worksheet

[/academia_course_lesson][academia_course_lesson title=”CREATING AND EDITING WORKSHEET: 2″]

1. Modifying the Formatting of Cells
2. Using Borders and Margins
3. Sorting and Filtering a Data List
4. Using Proofing Tools

[/academia_course_lesson][academia_course_lesson title=”CREATING AND EDITING WORKSHEET: 3″]

1. Creating and Editing Charts
2. Formatting Charts
3. Creating and Formatting Charts
4. Working with Shapes
5. Inserting Graphics
6. Inserting Objects in a Worksheet
7. Adding Graphics to a Worksheet

[/academia_course_lesson][/academia_course_sections]

[academia_course_sections title=”INTERMEDIATE SKILLS IN MICROSOFT EXCEL”][academia_course_lesson title=”ENHANCING WORKBOOKS”]

1. Modifying Worksheets
2. Adding Headers and Footers
3. Editing Worksheets
4. Working with Office Themes
5. Formatting and Editing Cells
6. Conditional Formatting
7. Inserting Hyperlinks
8. Formatting Cell Data

[/academia_course_lesson][academia_course_lesson title=”WORKING WITH DATA”]

1. Extending a Data Series
2. Analyzing Data by Using Data Lists
3. Cleaning Up and Outlining Data List
4. Using What – If Analysis
5. Performing Calculations
6. Working with Data List

[/academia_course_lesson][academia_course_lesson title=”WORKING WITH TABLES AND CHARTS”]

1. Creating and Editing Pivot Tables
2. Formatting Pivot Table Data
3. Analyzing Pivot Table Data
4. Working with a Pivot Table
5. Working with Pivot Charts
6. Editing Charts
7. Using Table Styles
8. Using Pivot Tables

[/academia_course_lesson][academia_course_lesson title=”WORKING WITH ADVANCED FEATURES OF EXCEL”]

1. Setting Excel Options
2. Setting Workbook Properties
3. Customizing the Ribbon
4. The track Changes Feature
5. Linking and Embedding Objects
6. Sharing a Workbook
7. Working with the Advanced Features

[/academia_course_lesson][/academia_course_sections]

[academia_course_sections title=”ADVANCED SKILLS IN MICROSOFT EXCEL”][academia_course_lesson title=”CUSTOMIZING EXCEL”]

1. Setting Excel Options
2. Defining Workbook Protection Levels
3. Customizing Worksheet Views

[/academia_course_lesson][academia_course_lesson title=”WORKING WITH WORKSHEET DATA”]

1. Manipulating Worksheet Data
2. Creating Named Ranges
3. Managing Named Ranges
4. Inserting Equations
5. Analyzing Data
6. Working with a PowerPivot Workbook
7. Working with Worksheet Data

[/academia_course_lesson][academia_course_lesson title=”WORKING WITH EXTERNAL DATA”]

1. Defining and Editing External Data Connection
2. Working with XML Data
3. Creating and Editing Web Queries
4. Working with External Data

[/academia_course_lesson][academia_course_lesson title=”WORKING WITH TABLES AND CHARTS”]

1. Working with Charts
2. Creating a Sparkline Charts
3. Creating Different Types of Charts
4. Adding Trendline to a Chart
5. Analyzing Pivot Table Data
6. Working with Table and Charts

[/academia_course_lesson][academia_course_lesson title=”AUTOMATING WORKBOOKS”]

1. Creating a Macro
2. Editing a Macro
3. Running and Deleting a Macro
4. Working with Macro

[/academia_course_lesson][/academia_course_sections]