This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Prerequisites
Basic knowledge of Microsoft Excel is essential with the follow pre-requisites: Have attended Microsoft Excel – Foundation Level; OR Able to switch between task applications
Able to perform basic calculation
The Outlines:-
Module 1: Calculating Data with Advance Formulas
Module 2: Organizing Worksheet and Table Data
Module 3: Presenting Data Using Charts
Module 4: Graphic Objects
Module 5: Enhancing and Customizing Workbook
Module 6: Streamlining Workflow
Module 7: Collaborating with others - Protect files
Module 8: Auditing worksheets
Module 9: Working with Multiple Workbooks
Module 10: Import Data
Module 11: Analysing Data
Module 12: Sorting and Filtering Data
Module 13: Analyzing Data Using Pivot
Module 14: Macro
Module 15: Linking and Embedding
visit here to get more details about IT Training.
Congratulation for the great post. Those who come to read your Information will find lots of helpful and informative tips. Process of Influencing sydney
ReplyDeleteThis is the perfect blog for anybody who wants to know about this topic. You know so much its almost hard to argue with you. You definitely put a new spin on a subject thats been written about for years. excel intermediate training
ReplyDelete