Participants who have basic and intermediate knowledge of Excel should take Advanced Excel Training. This course will enhance their understanding of the use of Excel.
Additionally, the facilitator will discuss, in detail, the functions and features available in Microsoft Excel. At the same time, each participant of this course learns how to use different logical and statistical functions. They will also learn to import and export data, use simple database access, and create and use macros.
The course will then keep you engaged by providing a combination of video lectures, course notes, take-away templates, quizzes, exercises, and even homework. Also, this is an excellent opportunity to add practical Excel focus to what you learn in the program.
The depth and breadth of Advanced Excel Training topics we selected are challenging and rewarding, providing a 360-degree approach to modeling in Excel. Our strong focus on real-world examples ensures a super hands-on Excel experience. We design a process that allows you to learn and see how participants apply this in practice.
Advanced Excel Training is by professionals for professionals, so if you are looking to improve your knowledge and use hands-on practical applications of Microsoft Excel in the workplace.
At the end of this 1 day course participants are expected to learn the following:
- Use Logical Functions
- Use Other Math Functions
- Use DATE Functions
- Use TIME Functions
- Using Arrays
- Use Lookup functions
- Data Validation
- Use Database Functions
- Import & export text files, XML data
- Create scenarios
- Using Macros