In Microsoft Excel 2013 Level 2 course The target students for this course are those who desire to gain the skills necessary to create templates, sort and filter data, analyze data, create charts and Pivot tables.
Prerequisites: Participants should have basic Windows operating skills. This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Topic-A: Configure Excel Options
Topic-B: Customize the Ribbon and the Quick Access Toolbar
Topic-C: Enable Excel Add-Ins
Topic-A: Use Range Names in Formulas
Topic-B: Use Specialized Functions
Topic-C: Use Array Formulas
Topic-A: Analyze Data by Using Text and Logical Functions
Topic-B: Apply Advanced Conditional Formatting
Topic-A: Create and Modify Tables
Topic-B: Sort Data
Topic-C: Filter Data
Topic-D: Use SUBTOTAL and Database Functions
Topic-A: Create Charts
Topic-B: Modify and Format Charts
Topic-A: Create a Pivot-table
Topic-B: Analyze Pivot-table Data
Topic-C: Present Data with Pivot-charts
Topic-D: Filter Data by Using Slicers
Students who want to learn Microsoft Office and master it
Read About Microsoft Excel 2013 Here
2 Days
No Reviews found for this course.
