Advance Excel 12 Hrs

Advance Excel                                                                                                                                                                12 Hrs.

การใช้งาน Function และ ความเข้าใจ การทำ Excel  ให้สามารถเป็น Application ได้

FUNCTIONS

  1. Excel 2007 Functions
  2. Getting help about using a particular function
  3. TODAY
  4. DAY
  5. MONTH
  6. YEAR
  7. SUMIF
  8. ROUND
  9. COUNT
  10. COUNTA
  11. COUNTIF
  12. PROPER
  13. UPPER
  14. LOWER
  15. CONCATENATE
  16. FV
  17. NPV
  18. PMT
  19. PV
  20. RATE
  21. HLOOKUP
  22. VLOOKUP
  23. IF
  24. AND
  25. OR
  26. ISERROR
  27. DSUM
  28. DMIN
  29. DMAX
  30. DCOUNT
  31. Nested functions

USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES

  1. Using a one input Data Table command
  2. Using a two input data table command

A FIRST LOOK AT PIVOT TABLES

  1. Creating a PivotTable
  2. Dropping data into the Pivot Table
  3. Modifying data and refreshing the Pivot Table
  4. Grouping data within a Pivot table

SCENARIOS

  1. Scenario Manager – an example
  2. Showing a scenario
  3. Viewing an alternative scenario
  4. Create a scenario summary

AUDITING

  1. Tracing precedent cells
  2. Tracing the dependants of a cell
  3. Displaying all formulas within a worksheet
  4. Adding comments
  5. Displaying comments
  6. Removing comments
  7. Editing comments

MACROS

  1. Displaying the Developer tab
  2. Recording and running macros
  3. Lowering your macro security level
  4. Customizing the Quick Access Toolbar
  5. Changing the Quick Toolbar Macro icon
  6. Removing a macro icon from the quick access toolbar
  7. Raising your macro security level

TEST

 

ออกแบบหลักสูตรโดย  อ.รชต รัตนวสวัต

 โรงเรียนศูนย์อบรมคอมพิวเตอร์ ชลบุรี