Home
Courses
Corporate Solutions Contact
Journal Login cart 0

Excel- Advanced

Coming Soon

 

  • Introduction to MS Excel
  • Using Excel Templates
  • Understanding Microsoft Excel Home Screen
  • Protecting and Managing Workbook
  • Understanding the File Tab
  • Understanding Home Tab of Excel
  • Use of Clipboard, Use of Font Command Group
  • Merging Cells, Alignment command
  • Shortcut Keys used in Excel
  • Number Command Group
  • Conditional Formatting
  • Formatting data as Table
  • Inserting Cells, Applying Cell Styles
  • Using AutoSum Command
  • Pivot Tables
  • Inserting Charts
  • Use of Sparklines
  • Inserting Slicer, Inserting Timelines
  • Applying Themes. Effects and Fonts in excel
  • Applying Margins, Page Breaks - other elements under Page Setup
  • Sheet Options
  • Arrange Command
  • Applying various formulas
  • Use of various types of excel functions- Logical, Text, Information, Financial
  • Use of Name Manager, Defining Names
  • Formula Auditing
  • Importing Data
  • Data Sort and Filtering
  • Use of Data Tools
  • Data Validation and Consolidation
  • What If Analysis
  • Grouping and Ungrouping Data
  • Reviewing data, proofing
  • Inserting comments
  • Worksheet and Workbook protection
  • Understanding workbook view options

 

Rs.4999
Rs.1999
Add to cart
Books
Books