Topics

OFFICE AUTOMATION

• Fundamentals of Computer Systems, Hardware, Software, and Input/Output Devices
• Basic File & Folder Management, Including Creating, Organizing, Deleting, and Restoring Files
• Internet and E-mail Operations, Including Downloading Images, Creating Gmail Accounts, and Managing E-mails with Attachments
• Screenshot Capture and File Conversions
• Document Creation and Formatting Using Word, Including Tables, Pictures, Mail Merge, and Printing
• Presentation Development Using PowerPoint with Text, Images, Designs, Transitions, Animations, and Slideshows
• Protecting Documents Using Password
• Practical Computer Skills for Day-to-Day Office Work and Personal Productivity Tasks

ADVANCED EXCEL WITH VBA

• Data Entry and Worksheet Management
• Formatting Documents and Text Formatting
• Basic Formulas, Chart Creation, and Workbook Protection
• IF, Nested IF, AND, OR Functions, and Text & Date Functions
• Sorting, Filtering, Conditional Formatting, and Data Validation
• SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, and MINIFS
• VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH, and Database Functions
• Financial Functions, CONCATENATE, SUBSTITUTE, and DATEDIF
• Pivot Tables, Pivot Charts, Advanced Charts, and Dashboards
• What-If Analysis, Goal Seek, Forecasting, Trend Analysis, Data Import, Transformation, Cleaning, and Query Merging
• VBA Editor, Programming Basics, Variables, Data Types, Loops, and Macros
• Working with Worksheets and Ranges
• Creating User Forms and Form Controls with Validation

DATABASE MANAGEMENT USING ACCESS

• Database Creation
• Table Design
• Queries
• Forms
• Reports
• Relationships
• Database Management Using Access