This intermediate MS Excel Training program is designed for those who are the basic users of excel and want to enhance their skills and competency level in spreadsheet application though in 2003 , 2007 or 2010 version of MS-Excel.

Program Duration: 8 Hrs/ 1 Day


Table of Contents:

Overview of MS Excel Interface
- Working with Keyboard Shortcuts
- Overlook basics.
- Usage of Auto Correct features
- Adding your own Acronyms
Viewing options
- Adjusting zoom
- Using Freeze Panes
- Using Split Window
- Arrange Window to various Styles
Hiding and displaying data
- Hiding rows, Columns, Data, Worksheet, Formula.
- Creating an outline
Printing large worksheets
- Page Break preview
- Working with page breaks
- Printing multiple sheets
Working with Multiple Worksheets and Workbooks 
Using multiple worksheets
- Navigating between sheets
- Moving and copying sheets
Linking workbooks
- Creating a formula to link workbooks
- Using the Paste Link option
- Maintaining links
Working with dates
Entering date functions
- TODAY function
- NOW function
- Edate
Conditional formulas and formatting
The IF function
Conditional formatting
- Based on a cell value
- Based on a formula
- Identifying cells with conditional formatting
- Copying conditional formats
Import and Export of Data

List Management
Working with lists
- Structure of a list
- Editing the Custom list
- Defining your own list
Sorting and filtering lists
- Simple sorting
- Sorting by multiple columns
- Sorting based on cell colours
- Using AutoFilter
Advanced filtering
- Using custom filter
- Using Advanced Filter

Integration with Other Application
- Opening MS Word on Excel
- Linking data from Excel to Other Application
Documenting and Auditing
Comments
- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
Protection techniques
- Protecting a workbook
- Protecting a worksheet
- Protecting cell ranges
Using Templates
Built-in templates
- Accessing and using Excel’s templates
- Creating and managing templates
- Creating, using and modifying a custom template file

Exploring (QAT) Quick Access Toolbar
- Hidden Commands
- Commands not in the Ribbon
- Exploring Excel Backstage.

Many more.............

Advanced Excel Training, Excel VBA / Macro Training,MS Access Training Corporate IT Training, Finance Modelling, MS Word Training, MS PowerPoint Training,MS Project Training, HR Automation, IT Solutions.

HOME