Course Coverage

• 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