ADVANCE EXCEL

ADVANCE EXCEL   -   D03043      Help Line

Advance Excel Training Syllabus

EXCEL INTRODUCTION

1. An overview of the screen, navigation and basic spreadsheet concepts
2. Various selection techniques
3. Shortcut Keys

CUSTOMIZING EXCEL

1. Customizing the Ribbon
2. Using and Customizing AutoCorrect
3. Changing Excel’s Default Options

USING BASIC FUNCTIONS

1. Using Functions - Sum, Average, Max,Min, Count, Counta
2. Absolute, Mixed and Relative Referencing

FORMATTING AND PROOFING

1. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
2. Basic conditional formatting

MATHEMATICAL FUNCTIONS

1. SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs

PROTECTING EXCEL

1. File Level Protection
2. Workbook, Worksheet Protection

TEXT FUNCTIONS

1. Upper, Lower, Proper
2. Left, Mid, Right
3. Trim, Len, Exact
4. Concatenate
5. Find, Substitute

DATE AND TIME FUNCTIONS

1. Today, Now
2. Day, Month, Year
3. Date, Date if, DateAdd
4. EOMonth, Weekday

ADVANCED PASTE SPECIAL TECHNIQUES

1. Paste Formulas, Paste Formats
2. Paste Validations
3. Transpose Tables

New in Excel 2013 / 2016 & 365

1. New Charts - Tree map & Waterfall
2. Sunburst, Box and whisker Charts
3. Combo Charts – Secondary Axis
4. Adding Slicers Tool in Pivot & Tables
5. Using Power Map and Power View
6. Forecast Sheet
7. Sparklines -Line, Co

Note: course content and course fees may vary according to the location and category of centre but cannot go beyond the Course Fees mentioned in the site as it is the official declared Fees for the month. Kindly check this site regularly for updated course fee details.

Course Features

• Start: 01 Apr, 2023
• Course Duration: 2 Month
• Total Marks: 400
• Seats Available: Yes
• Total Classes : 24
• Time: Select batch timing
• Class: Mon, Tue, Wed, Thu, Fri
• Lecturer: 3 Per week