Internal training-Advanced application of Excel in work

 Create tables in a standardized and efficient way
  Understand principles and methods to create Excel table, practice most common and practical functions, standardize ways of working to increase efficiency and quality of work
-  Four steps to create a table
-  Basic rules in data table
-  Format Cells: Custom Number Format
-  Paste Special
-  Data Validation: Whole number, Text length, List, Custom
-  Protect Sheet and Protect Workbook (Hide Sheet)
-  Hot key and maneuver skills

 Set up professional print format with attention to details
-  Learn to set up print format quicker and better
  Page Setup: Scaling/Margins/Gridlines/Header Footer/Print Titles

 Use Charts to display complicated data and make the presentation clear and vivid
-  Classification of Charts, delivery of key message
-  Charts formatting Skill
-  Two-axis and Multi-format Charts
-  Save and use Chart Templates
-  Paste Charts into PowerPoint

 Powerful data analysis functions to help you

 Powerful Pivot Table function in Excel help analyze large amount of data from various perspectives; grasp key information and generate graphs and tables
-  Understand pivot analysis mode
-  Data analysis in Row, Column, Data, and Page Field
-  Various analysis functions, Summarize Data By: Sum, Average, Count
-  Data trend analysis and ratio analysis: % of row/column/total, % Difference From
-  Date field Group: Years/Quarters/Months/Days
-  Sort, Filter, Show Details
-  PivotChart

 Learn various and easy to use data analysis functions in Excel
-  More convenient access to data: Freeze Panes, Split, Group
-  Use Text to Columns function and import of data
-  Conditional formatting: set up pre-defined automatic reminder
-  Multiple Level Sorting, Add Custom lists Sorting
-  Data Filter, Custom Filter, Advanced Filter
-  Pulling out unique records: Remove Duplicates

 Formula and Functions: Let compute work for you

 Use application Functions to handle complicated data search, quotation, sort, split and ensure consistency and accuracy of data
-  Understand application of functions
-  Learn to define and use functions in a standardized way
-  know how to use functions Help
-  Study and practice most popular functions
  Logical: and(), or(), if(), iferror()
  Statistical: average(), count(), counta(), countif()
  Math & Trig: sum(), sumif(), mod(), round(), subtotal()
  Look & Reference: vlookup(), index(), match(), offset()
  Text: trim(), left(), right(), mid(), &, len(), find()
  Date & Time: today(), date(), year(), month(), day(), edate()
-  Cell quotation: absolute, relative and mix
-  Define Name
-  Show Formulas, Hide and Protect Formulas

 More advanced uses: Controls and Marco(VBA)
-  Form Controls: Button, Group Box, Check Box, Option Button, Spin Button
-  Marco(VBA): Use VBA to process repetitive work (a few good recommendations)

 Gift: Magical and Powerful display tool