See Similar Listings
Community Listing   Australia   NT   Community Listing -

Microsoft Excel Intermediate Course (...

Darwin Human Resource Computer Academy

This listing was posted on doMore - Learn Something New.

 

Microsoft Excel Intermediate Course (Excel Intermediate - Alice Springs)

Location:
Alice Springs, NT
Description:

BSBITU402 – Develop and use complex spreadsheets – Nationally Recognised & Accredited Training General Details Duration: two Half Days, seven Hours Prerequisite: Experience with Windows and Excel Introductory Functions. Objectives: To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Excel. Methodology: Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation. Competency Assessment: This will be issued to trainees upon completion of training session. Expected Outcome: By the end of the course the participant should be able to use the following functions and features of Microsoft Excel. Course Content Working with Workbooks: • Opening Workbooks • Creating and Saving Workspaces • Closing Workbooks Formula Referencing: • BODMAS Theory • Relative Referencing • Absolute Referencing • Mixed Referencing Linking Data: • Linking across Spreadsheets • Linking across Workbooks • Updating Links Other Formula Options: • Range Names • Creating Range Names • Deleting Name Ranges • Using Names for Constants • Creating Names in External Workbooks • Creating a List of Names Functions: • Insert Function Wizard • Statistical Functions • Financial Functions • Lookup Functions Managing Data: • Outlining • Sorting Data • Auto Filtering Creating and Using Macros: • Exploring Macros • Recording a Macro • Running a Macro • Assigning a Macro to a Button • Deleting a Macro • More Macros Advanced Charting: • Changing the Chart Type • Adding Data to a Chart • Formatting Charts
Category:
Community
Posted:
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to doMore - Learn Something New
Important Safety Tips

These might be signs of fraud:

  • Really cheap prices
  • Irregular email adresses
  • Contact info in pictures

To learn more, visit the Safety Center or click here to report this listing.