Advanced Excel
Course Prerequisite(s)
- Please note that this course has the following prerequisites which must be completed before it can be accessed
-
Basic MS. Excel 2016
About Course
In this course, students use Excel® to streamline and enhance spreadsheets
with templates, charts, graphics, and formulas. They will apply visual elements and
advanced formulas to a worksheet to display data in various formats. (Second
Edition)
Course Content
Model One
-
Lesson 1 : Calculating Data with Advanced Formulas
-
Lesson 2 : Working With Text Function
-
Lesson 3 : Working With References Functions
-
Lesson 4 :Organizing Worksheet and Table Data
-
Lesson 5 : Analyzing Data Using PivotTables and PivotCharts
-
Lesson 6 : Customizing and Enhancing Workbooks and the Excel Environment
-
Lesson 7 : Filtering Data
-
Lesson 8 : Working With Excel Data Tools and Outlines
-
Lesson 9 : Analyzing Data
-
Lesson 10 : Working with Multiple Workbooks
-
Lesson 11 : Exporting Excel Data
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet