About Course
This Advanced Excel Training program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2013. The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2013, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Key Features

You will get 100% job Assurance and life time e-placement support

classed taken by globally certified trainers

You will get 3 year Dedicated placement support
.png)
Courses are globally recognized & accredited
Lesson 1: Using Custom & Conditional Formats
Lesson 2: Using Range Names
Lesson 3: Using Formulas & Functions
- Understanding Formulas & Functions
- Quick Way to Insert a Function
- Viewing the Formulas (and not the results)
- How to Delete Values and not Formulas
- Create a Relative & Absolute Reference
- Working with Logic Functions
- Using SUMIF() and COUNTIF():
- Adding and Counting only the Cells you Specify
- Working with Text Functions
- Using More Text Function
- Working with Date and Time Functions
- Working with Lookup Functions
- Understanding VLOOKUP() Function
Lesson 4: Managing, Sorting & Filtering Tables
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Calculate Total Row in a Table
- Display Special Formatting for First or Last Column
- Outline a List of Data
- Validating Data During Entry
- Working with Database Functions
- How to Use Advance Filters in Excel
Lesson 5: Working with Charts
Lesson 6: Working with Pivot Tables
- What is a Pivot Table
- Anatomy of a Pivot Table
- How does a Pivot Table Works
- Create a Basic Pivot Table Report
- Rearranging a Pivot Table Report
- Customizing a Pivot Table
- Changing Summary Calculations
- Adding and Removing Subtotals
- Sorting in a Pivot Table
- Filtering in a Pivot Table
- Create Report Filter Pages
- Using Slicers in Pivot Table
- Working with Pivot Chart
Lesson 7: Working with Shared Workbooks
Lesson 8: Working with Multiple Workbooks
Lesson 9: Protecting Your Worksheet and Workbook
Lesson 10: Working with Excel Macros
