MS Excel Advanced
Course Specification:
Course Length: 1 day/2 evenings
Course Level: Advanced
Software: MS Excel xp/2003/2007 Professional
Course Description:
Excel Advanced concentrates more on the advanced functions available on this application to enhance more efficient and stronger management on calculations and worksheets and workbooks.
Target Students: That already works on Excel and uses Excel on a daily base.
Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic / Ms Excel Intermediate
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Benefits: Managing Workbooks, Spreadsheets and cells more efficiently by customizing according to the users need.
What s Next: VB on Excel xp/2003/2007
Course content:
X Custom Formatting: - Number Sections, Number Codes, Date Codes, Speedkeys
X Using Conditional Formats
X Creating Range Names
X Range Names in Calculations
X Paste Special
X Object Linking and Embedding
X Sharing Workbooks with Other Applications
X Importing a Text File into Excel
X Importing Data from Web Page
X Creating, Storing and Custom Workbook Templates
X Default Template
X Loading Add-In Programs
X Creating a Custom View and Work Space File
X Creating Formulae to Link Data
X Using the Report Manager to Print Multiple Workbooks and Worksheets
X Using the Look-Up Functions
X Creating, Displaying (hidden), Floating, Docking and Custom the Toolbar
X Understanding, Recording and Running a Macro Virus Protection
X Creating and Editing Data Map Charts
Course Length: 1 day/2 evenings
Course Level: Advanced
Software: MS Excel xp/2003/2007 Professional
Course Description:
Excel Advanced concentrates more on the advanced functions available on this application to enhance more efficient and stronger management on calculations and worksheets and workbooks.
Target Students: That already works on Excel and uses Excel on a daily base.
Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic / Ms Excel Intermediate
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Benefits: Managing Workbooks, Spreadsheets and cells more efficiently by customizing according to the users need.
What s Next: VB on Excel xp/2003/2007
Course content:
X Custom Formatting: - Number Sections, Number Codes, Date Codes, Speedkeys
X Using Conditional Formats
X Creating Range Names
X Range Names in Calculations
X Paste Special
X Object Linking and Embedding
X Sharing Workbooks with Other Applications
X Importing a Text File into Excel
X Importing Data from Web Page
X Creating, Storing and Custom Workbook Templates
X Default Template
X Loading Add-In Programs
X Creating a Custom View and Work Space File
X Creating Formulae to Link Data
X Using the Report Manager to Print Multiple Workbooks and Worksheets
X Using the Look-Up Functions
X Creating, Displaying (hidden), Floating, Docking and Custom the Toolbar
X Understanding, Recording and Running a Macro Virus Protection
X Creating and Editing Data Map Charts
|
|
||||
Training
Provided by Advanced Concepts
- R asked: how can i be a excel experts help me in this regard best regards bye
- asked: request quotations and dates
- A asked: i want to familiar myself with advance concepts of MS Excel which enhance utility of using MS Excel in my daily work
- M asked: intreseted in taking an Excel training course to learn formula's and shread sheets, Please email me with info on classes. I am in San diego. Thank You,
- B asked: I would like to get a quote on holding a Microst Excel seminar/ training session that is onsite at . I have about employees interested at this point and we are looking for more an intermediate/ advanced training session. We would like the session to be no more than day training and would prefer to be less than that if that is an option. Thanks! . Pond Dr. Wood Dale, IL
- P asked: I'm From Hyderabad - Andhra Pradesh. India. Is this possible for me to take training in Hyderabad? If it is, how does it cost ? Please send the details.
- S asked: Hi can you tell me where this course is held as well as dates/ prices. Kind regards
About The Training Provider: Advanced Concepts
Advanced Concepts - We are an accredited training provider with local authorities in SA. We have been in the training industry for the past 9 years.
We offer international and national course, instructer led or virtual.
Main source of training is IT and Softskill.
