Microsoft Excel

Course details

Microsoft Excel has always been a trending topic among the professionals of several sectors. If you are looking for a job that will pay you generously, Microsoft Excel course is a package which will ensure you can stand out from the crowd. Nowadays, a large number of companies require MIS executives as the nature of the job is very sophisticated and needs to be handled with caution.

This Microsoft Excel course will be the ideal playing ground for you if you plan to take your career to the next level. This Microsoft Excel course is suitable for data analysis ranging in accounts, budgets, billing and many other areas. The Microsoft Excel course also covers the improved methods of Excel such as create and edit macros, conditional formatting and adding data validation rules. This Microsoft Excel course explains the advanced formulas which can be used in excel.

This Microsoft Excel course is centrally for those who have the basics cleared. This Microsoft Excel advanced course will give the learner an in-depth of the Excel experience. You will see your career reaching heights like never before in no time!

Why Choose Skill Express

• Instantly accessible CPD Accredited certificate on successful course completion
• 24/7 access to the course for lifetime
• Developed by qualified professionals with updated resources
• Full Tutor support on weekdays (Monday - Friday)
• No hidden fees or exam charges

Description

Course Curriculum of Microsoft Excel

We have divided the Microsoft Excel Course into five user-friendly Lessons.

Microsoft Excel - Module 01: Developing Macros

• Microsoft Excel - Create a macro using the Macro Recorder
• Microsoft Excel - Edit a macro
• Microsoft Excel - Debug a macro
• Microsoft Excel - Customise the Quick Access toolbar and
• Microsoft Excel - hotkeys
• Microsoft Excel - Set macro security

Microsoft Excel - Module 02: Formatting Worksheets Using Macros

• Microsoft Excel - Insert text with a macro
• Microsoft Excel - Format text with a macro
• Microsoft Excel - Sort data with a macro
• Microsoft Excel - Duplicate data with a macro
• Microsoft Excel - Generate a report with a macro

Microsoft Excel - Module 03: Creating an Interactive Worksheet

• Microsoft Excel - Determine the appropriate dialogue box type to use
• Microsoft Excel - Capture user input using a variety of techniques

Microsoft Excel - Module 04: Working with Multiple Worksheets

• Microsoft Excel - Insert, copy, and delete worksheets using macros
• Microsoft Excel - Rename worksheets using macros
• Microsoft Excel - Modify the order of worksheets using macros
• Microsoft Excel - Print worksheets using macros

Microsoft Excel - Module 05: Performing Calculations

• Microsoft Excel - Create user-defined functions in macros
• Microsoft Excel - Automate SUM functions with a macro

Updated on 16 June, 2023