You must be logged in to take this course → LOGIN | REGISTER NOW
[course_title] continues Velsoft’s in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA.
So, if you are interested to develop your skills and knowledge, you shouldn’t be late to join this course.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Edukite
Course Curriculum
| Developing Macros | |||
| Create a Macro Using the Macro Recorder | 01:00:00 | ||
| Edit a Macro | 01:00:00 | ||
| Debug a Macro | 00:30:00 | ||
| Customize the Quick Access Toolbar and Hotkeys | 00:30:00 | ||
| Set Macro Security | 01:00:00 | ||
| Formatting Worksheets Using Macros | |||
| Insert Text | 00:30:00 | ||
| Format Text | 00:30:00 | ||
| Sort Data | 00:30:00 | ||
| Duplicate Data | 01:00:00 | ||
| Generate a Report | 01:00:00 | ||
| Creating an Interactive Worksheet | |||
| Determine the Dialog Box Type | 00:15:00 | ||
| Capture User Input | 01:00:00 | ||
| Working with Multiple Worksheets | |||
| Insert, Copy, and Delete Worksheets | 00:30:00 | ||
| Rename Worksheets | 00:30:00 | ||
| Modify the Order of Worksheets | 00:15:00 | ||
| Print Worksheets | 00:30:00 | ||
| Performing Calculations | |||
| Create User-Defined Functions | 00:30:00 | ||
| Automate SUM Functions | 00:30:00 | ||
| Activities and Exercise Files – Microsoft Excel 2016 and VBA | 00:00:00 | ||
| Assessment | |||
| Submit Your Assignment | 00:00:00 | ||
| Certification | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
