Intermediate MS Excel ! MS Excel Session - Simfotix
 
×
  • One Day Training Workshop
  • Two Day Traning Workshop

Intermediate MS Excel - Two Days

Two Days
Getting started
  • Spreadsheet terminology
  • The Excel environment
  • Navigating a worksheet
  • Using a template
  • Entering and editing data
  • Entering and editing text and values
  • Entering and editing formulas
  • Entering and editing formulas
Modifying a worksheet & Functions
  • Moving and copying data
  • Moving, copying, and viewing formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows, and columns
  • Entering functions
Professional Formatting
  • Specific Text formatting
  • Row and column formatting
  • Number formatting as per requirements
Managing workbooks and worksheets
  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Using multiple workbooks
  • Linking workbooks
  • Using special number formats
  • Working with themes
Outlining and subtotals
  • Outlining and consolidating data
  • Creating subtotals
  • Cell and range names
  • Creating and using names
  • Managing names
  • Data structure and tables
  • Sorting and filtering data
  • Working with tables
Web and sharing features
  • Saving workbooks as Web pages
  • Using hyperlinks
  • Sharing workbooks
  • Documenting and auditing
  • Auditing features
  • Comments in cells and workbooks
  • Protection
  • Workgroup collaboration
  • Application settings and templates
  • Application settings
  • Working with templates

Gallery

Testimonials