+971 56 731 2942 , +971 04 298 9926

MS Excel – Intermediate

Excel 2010 – Level 2 (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

Online Assessment Test

Testimonials

Download Here


download_profile