In this Advanced course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.

MODULE 1: INTRODUCTION TO INFORMATION SECURITY

• UNIT 1: Why is IT Security Necessary?
• UNIT 2: IT Security Services life cycle
• UNIT 3: Cyber Threats and Issues
• UNIT 4: Protecting Your Password and Logging Securely
• UNIT 5: Selecting Tools

MODULE 2: DESKTOP AND SERVER SECURITY

Session 3: Understanding the VBA editor, Module and Procedures

Session 4: VBA Syntax and Grammar

Session 5: Storing data in variables

Session 6: Control struture and Program Flow

Session 7: Building Procedures

Session 8: Building Intuitive User Interfaces

Session 9: Variables, Arrays & Constants

Session 10: Creating customized dislogs with User Form objects

Session 11: Fonts & Background

Session 12: Objects and Collections

Session 13: Array

Session 14: Functions

Session 15: Error Handling

Session 16: Internet and Excel

Session 17: Interacting with other office Apllications

Session 18: Running SQL Queries within Excel Environmment

Session 19: Modifying Menus and Toolbars