English 中文
AEX 
Search course content

Advanced Excel training course outline by Computer Academy
 
 
1. Naming Cells and Ranges
  • Creating a Name
  • Making a name list
  • using the name for calculation
2. Database
  • The database components
  • Data Form
  • Inputing Date
  • Deleting Date
  • Finding Records
  • Using menu commands to find records
  • Combining search criteria
  • Extracting records
3. Data sorting
4. Datebase Functions
  • DSum()
  • DMax()
  • DMin()
5. Creating and Using an Array Formula
6. Managing Documents with Workbooks
7. Consolidation with several Worksheets
8. Data Table
  • One-Input Table
  • Two-Input Table
9. Lookup Table
  • Lookup()
  • Vlookup()
  • Hlookup()
10. Document protection
  • File protection
  • Protect cells/document
  • Unprotected document
11. File Linking
  • Paste Link
12. Publisher and Subscriber options(Macintosh Only)
  • Create a publisher
  • Subscriber a publisher
13. Filter and Advanced Filter
14. Pivot Table
  • Steps to create a simple pivot table
  • Creating pivot table from Excel
  • Consolidating Data from Multiple Ranges into a Pivot Table
15. Conditional Format
  • Define single and multiple criterial
  • Delete criterial
16. Data Validation
  • Define the data type
  • Define the warning message
  • Define the error message
17. Sharing and tracking worksheets
  • Turning on and let the other users can edit the worksheet.
  • Cancel changes made by the others.
18. Drawing Tool Bar
  • Line, Rectangle, oval etc...
19. Creating a Chart
  • Polishing your chart
  • Changing the text format and the pattern color in a chart
  • Attach Text
  • Adding Legend
  • Adding Gridlines
  • Adding Arrow
  • Adding Unattached Text
  • Adding Data Series to the Chart
  • Creating an Overlay Chart
  • Changing chart type
20. 3D Chart
  • To construct a 3D chart
  • Formatting the 3D chart
  • 3D View
     
  top  
     
Duration: 2 night sessions or 1 day Fee: $1,480
Continuing Education course
Diploma Course in Computer Graphic Design
Diploma course in 3d Modelling and Animation
Diploma in Multimedia Web Design and Development
 
 
  Relating Courses  
 
  Access
  Excel I
  Filemaker Pro
  Financial Accounting with Excel
  Powerpoint
  Powerpoint-Advanced