| EN
Beijing - Excel: Managing Databases
2018年12月5日 星期三
German Chamber of Commerce Beijing
主办方: Training IPS and German Chamber of Commerce Beijing 更多活动

价格: ¥1,500 - 1,800

Beijing - Excel: Managing Databases

价格: ¥1,500 - 1,800

Beijing - Excel: Managing Databases
2018年12月5日 星期三
German Chamber of Commerce Beijing
主办方: Training IPS and German Chamber of Commerce Beijing 更多活动

价格: ¥1,500 - 1,800

12月05日

周三

Beijing - Excel: Managing Databases

2018年12月5日 星期三 German Chamber of Commerce Beijing

价格: ¥1,500 - 1,800

时间 地点

2018年12月5日 星期三

German Chamber of Commerce Beijing German Chamber of Commerce Beijing
活动二维码

用微信客户端扫描并分享此活动

主办方 联系主办方

Training IPS and German Chamber of Commerce Beijing

Training IPS and German Chamber of Commerce Beijing

Intelligent People Solutions (IPS) is a personal and organisational development company that provides innovative and customised training solutions.


IPS has been providing public courses through out network of partners for over 10 years across China.


We offer courses in Beijing, Shanghai, Guangzhou, Shenzhen, Tianjin and Qingdao.


To learn more about us and our service, please visit our website:

www.trainingips.com

查看更多

13501310182

alistair.mcarthur@trainingips.com

访问主办方微站

详情

浏览: 66

If you manage databases using Excel, you will want to attend this course. We will walk you through the steps of working with multiple workbooks and merging them into one easily managed database. If you accumulate databases on a regular basis from your sales team, research or events, you will most likely want to update your master database with information and need to for analysis.


The full-day course will provide you with the knowledge to start using Excel to manage your information more effectively while saving you hours of frustration through learning the most common functions of Excel.


Who should attend?


Marketing, Sales, HR, Accounting - team members who regularly use Excel to manage databases.




Key objectives



  • Function usage
  • Save time by knowing what Excel can do for you
  • Learn some of the ‘advanced’ functionality of Excel, but know that it is not always difficult to manage
  • Use Pivot Tables and Charts to summarize and analyse data quickly and efficiently
  • Be more confident in using Excel and know things can always be more efficiently done


Outline



  • Excel Efficiency and Shortcuts – speed up your operation
    • Finding and replacing data
    • Auto-fill
    • Checking errors with formulas and functions
    • Naming cells and naming ranges
    • Using names and ‘named’ ranged in calculations
  • Formulas and Functions
    • Creating
    • Editing
    • Copying relative and absolute references
    • COUNT/MAX/MIN/AVERAGE
    • The IF Function
    • Errors
  • Working with Text
    • Text to Columns
    • Text manipulation and functions (MID, Left, Right, Len, Trim, Concatenate, Upper, Lower, Proper, etc)
  • The Data Menu
    • Using filters for large lists
    • Sorting Lists
    • Group Data
  • Advanced Features
    • Setting up criteria ranges for filtering
    • Lookup functions - V and H
  • Tables and Charts
    • Simple Tables and Charts
    • Pivot Tables and Charts






展开详情

收起

主办方

联系主办方

Intelligent People Solutions (IPS) is a personal and organisational development company that provides innovative and customised training solutions.


IPS has been providing public courses through out network of partners for over 10 years across China.


We offer courses in Beijing, Shanghai, Guangzhou, Shenzhen, Tianjin and Qingdao.


To learn more about us and our service, please visit our website:

www.trainingips.com