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:
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............. |