© Copyright Ezee Computer Training 2010 Made by Wen Studio FORMATTING CELLS USING MENU OPTIONS Formatting Cells Using Menu Options • How to double underline using menu option • How to align vertically • How to change text orientation • How to wrap text in a cell • How to format numbers • How to format date • How to change cell background colour • How to add outline border • How to add double line border • How to add shading and pattern to a cell • How to format table using AutoFormat WORKING WITH ADVANCED FORMATTING, STYLE AND OUTLINING Customizing Data Appearance With Advance Formatting • How to use build-in number formats • How to custom number format • How to custom date format Using Conditional Formatting • How to use conditional formatting Maintaining Format Consistency With Styles  • How to create new style • How to apply styles • How to redefine style • How to delete style Using Data Outlining • How to create an outline automatically • How to remove outline • How to create outline manually • How to use Subtotal to create outline • How to show / hide details using outline symbols • How to remove Subtotal MANAGING WORKBOOK INFORMATION Managing Workbook Information • How to rename worksheet • How to add new worksheet • How to rearrange worksheet • How to copy worksheet • How to move a worksheet to another workbook • How to hide and unhide worksheet • How to hide and unhide workbook • How to format worksheet tab Protecting Workbook Contents  • How to protect the workbook structure • How to unprotect the workbook structure • Protecting your workbook from unauthorized users access • How to set password to open • How to remove password to open • How to set password to modify creating CREATING POWERFUL DATABASES Creating a Database • How to create database field • How to add records manually • How to add new record using a built-in data form • How to use find and replace Managing Record in Database  • How to search for the record using data form • How to edit / delete the record using data form • How to create a list • How to find total in a list • How to switch functions in a list • How to convert a list to a range Sorting Records • How to perform simple sort • How to perform multiple sort • How to set advanced sort options Using AutoFilter • How to enable / disable AutoFilter • How to apply / remove the criteria • How to customize criteria • How to use wildcard in criteria Using Advance Filter • How to define the criteria range • How to use the advanced filter command WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Managing Data in Multiple Worksheets • How to select adjacent worksheets • How to select non-adjacent worksheets • How to enter data into multiple worksheets • Using a 3D formula across worksheets • How to enter a 3D formula across worksheets using a function   Linking Information From Different Worksheets and Workbook • How to link information using copy and paste link • How to update link IMPORTING AND EXPORTING DATA Importing / Exporting Data • How to use text import wizard • How to export data to a document • How to copy data from other applications • How to insert objects • How to export data to Excel workbook into other application Retrieving Data From a Database • How to get specific information using database query • How to edit database query FORMATTING CHARTS Formatting a Chart • How to change font format • How to change text orientation • How to change object color • How to change the order of data series • How to use combination of chart type • How to create a pie chart • How to use 3-d view to rotate chart • How to explode a wedge in pie chart WORKING WITH COMMENTS Using Comments • How to add a comment into a cell • How to show comments • How to show/hide comment indicators • How to edit and delete comments PROTECTING WORKSHEET STYLE, CONTENTS AND ELEMENTS How to Protect the Worksheet • How to unprotect the worksheet • How to unlock cell for editing in protected sheet • How to hide cell formula in protected sheet • How to set password to edit specific range • How to grant selected users edit range without password 519-473-1391 eMail