HOME > Public Semina > Course Online

 
ESSENTIAL EXCEL TECHNIQUES FOR ELITES

Why do my Excel?sheets always have mistakes?
Why are my Excel?formulas complicated?
Why do my Excel?charts look boring?
We are doing similar, or even the same tasks, every month, is there any simpler method?
These are problems confusing many people. Excel?is not as easy as it appears; you need to master some skills if you want to use it intelligently. This course will help you master the usually neglected skills under the basic functions, this will radically improve you work efficiency, make your Excel?spreadsheets effective, safe and pretty, and make you an expert in Excel?in other people抯 eyes.


Training Objectives

Master the skills that make your Excel?spreadsheets more efficient and professional
How to solve complicated problems with formulas
How to make boss-satisfying charts
Make the boring, repetitious and time-consuming tasks automatic with macros
Learn to analyze data with pivot tables
Design Excel?forms using data validation

 

Training Attendees

Financial and non-financial personnel who need to ameliorate work with Excel?special_en=
 
 
       
Training Outline
 


The methods of making your Excel® different
 
  • Efficient: The useful methods to improve work efficiency
  •  
  • Safe: Full introduction on data safety and protection in Excel®
  •  
  • Convenient: Reference, link and hyperlink
  •  
  • Professional: Prepare a professional and normative Excel® report


  • Commonly used functions introduction with practical examples
     
  • How to define and use names in formulas
  •  
  • Commonly used functions and examples in real financial work
  •  
  • Salary and individual income tax calculation models
  •  
  • How to simplify your formulas with arrays
  •  
  • Database functions can solve complicated problems


  • Boss-satisfying charts
     
  • How to prepare charts by clicking one key
  •  
  • Eight elements to make your charts more professional
  •  
  • How to use the secondary axis in charts
  •  
  • How to insert other objectives in charts
  •  
  • How to make dynamic charts
  •  
  • Six principles in making charts


  • Macros: automate your work
     
  • You can start to use macro(how to record a macro)
  •  
  • Macros are not difficult (How to write your own macro)
  •  
  • Not many skills needed (some common and practical VB language)
  •  
  • Only one button (assign a macro to a button, picture and even your own photo)
  •  
  • What kind of jobs can be applied with macros
  •  
  • Financial application examples of macros


  • Other useful tools and skills
     
  • Pivot tables
  •  
  • Conditional formatting
  •  
  • Formula audits
  •  
  • 3-D formulas
  •  
  • Data consolidation
  •  
  • Advanced filters
  •  
  • Data validation
  •  
                         
    City
    Day
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Sep
    Oct
    Nov
    Dec
    Price
    Beijing
    2
    4200
    Guangzhou
    2
    4200
    Shanghai
    2
    4200
     
    Call For Registration:
    +86 21 58362000 810


     
     
    RECENT TRAINING
    > 19/03/21-22 /¥4200 / Shanghai
    > 19/06/13-14 /¥4200 / Beijing
    > 19/06/17-18 /¥4200 / Shanghai
    > 19/09/09-10 /¥4200 / Shanghai
    > 19/10/24-25 /¥4200 / Shenzhen
    > 19/11/14-15 /¥4200 / Beijing


     
     
      EASYFINANCE MANAGEMENT CONSULTING CO.,LTD
    Tel:+86 21-58362000 / 15801919100  Fax +86 21-58361896  
    E-MAIL :BD@EasyFinance.com.cn
    CopyRight ® EASYFINANCE
     
    瀹㈡埛鏈嶅姟
    live chat