Course Coverage

Our Courses

Using Custom & Conditional Formats
- Creating a custom format
- Create a custom number format
- Conditional Formatting
- Creating Conditional Formatting
- Editing Conditional Formatting
- Adding Conditional Formatting
- Deleting Conditional Formatting from the selected range
Using Range Names
- Using Range names
- Creating range names
- Using range names in formulas
- Creating range names from headings
- Deleting range names
Using Formulas & Functions
- Text Function
- Logical Functions
- Date and Time Functions
- Information Function
- Database Functions
- Math and Trigonometry Functions
- Statistical Functions
- Lookup and reference functions
Managing, Sorting & Filtering Tables
- Creating Tables
- Naming the Tables
- Changing the Table style
- Creating a total row
- Creating a calculated column
- using FIltering in Table
- Removing the duplicate record
Working with Charts
- Creating a chart
- Formatting a chart
- Adding Labels
- Changing the chart type, Data source
Working with Pivot Tables
- Creating Pivot tables
- Adding Pivot table Report Fields
- Refreshing Pivot table Reports
- Changing the summary functions
- Creating report filter page
Working with Shared Workbooks
- Sharing a workbook
- Opening and editing a shared workbook
- Tracking changes
- Resolving conflict in a shared workbook
Working with Multiple Workbooks
- Linking workbooks
- Editing the Link
- Consolidating the workbooks
Protecting Your Worksheet and Workbook
- Protecting your work sheet
- Protecting range with password
- Protecting your Workbook and Excel File

« Back

Course Coverage

Our Courses

Rohit Gupta