This course is designed to help the participants :-

• To understand and apply the basic concept of spreadsheet, graphics and database facility in Microsoft Excel.
• To explore the intermediate functions of Microsoft Excel program.

Among the topic that would be discussed are

DATABASE AND LIST MANAGEMENT

1. Using Databases ( Using the Excel database features, Using database terminology )
2. Creating And Editing A Database ( Creating an Excel database, Working with an Excel database, Assigning a database list, Creating an assigned list, Adding summary formulas to an assigned list )
3. Sorting Database ( Sorting data within a database, Adding other sorting criteria )
4. Using Autofilters ( Filtering data, Filtering data with AutoFilter, Specifying a conditional filter with AutoFilter, Using the Top 10 AutoFilter, Removing all AutoFilters )
5. Advanced Filters ( Using Advanced Filters, Removing all Advanced Filters )
6. Working With Filtered Data ( Manipulating Filtered Data, Totalling fields within a filtered database list, Creating Subtotals, Remove Subtotals )
7. Using Data Forms ( Using a Data Form, Adding a new record, Moving between records, Finding records, Editing a record, Deleting a record, Closing a Data Form )

CHARTS

1. Chart Wizard ( Using the Chart Wizard, Selecting the Chart Type, Specifying the Data Source, Customising the Chart, Defining the Chart Location )
2. Chart Toolbar ( Displaying the Chart toolbar, Using the Chart toolbar, Selecting a Chart, Selecting Chart objects )
3. Working With Charts ( Changing the Chart Type, Adding data to a Chart, Removing data from a Chart, Moving a Chart, Resizing a Chart, Deleting a Chart )
4. Formatting The Chart ( Formatting the Chart Area, Formatting the Chart Title, Formatting the Plot Area, Formatting the Axis, Formatting the Axis Title, Formatting the Legend, Formatting the Gridlines, Formatting the Data Series )