Module A1: Linking and Consolidating Data
- Linking Workbooks
- Creating A Link Formula By Paste Link
- Consolidating Data
- Creating A 3-D Formula
Welcome to TED Learning!
Have a general question concerning Perfect, find below contact details our team will help you.
TED Learning Sdn Bhd
12-07 Binjai 8 Premium SOHO
No. 2 Lorong Binjai
50450 Kuala Lumpur
03-2742 1828
training@ted.com.my
Advanced Formula and Functions
Advanced Way of Computing Data
This Advanced level of Microsoft Excel 2013 course covers the advance features of Excel. It is suitable for Excel users who wish to enhance their knowledge on more advanced formulas and functions.
At the end of this course you will have better understanding of the more advanced features of Excel. You will be able to link and consolidate information from different Excel files, manipulate data lists using filtering, subtotals and pivot tables. You will also be able to use logical and lookup functions.
Which of ever undertake laborious
physical exercised, excepts too obtain
some advantage from it?
Great explorer of the truth, the
master-builder of human happiness
No one rejects.
chooses to enjoy a pleasure that
has no annoing consequences, one a
pain that produces.
This program will run for 2 days which which covers Advanced level of Microsoft Excel. In 2 days, trainer will guide and teach students according to these outline to ensure the learning outcome will achieve.
Module A2: Managing Tables and Data
Module A3: Pivot Tables and Pivot Charts
Module A7: Auditing a Worksheet