Certificate in Office Efficiency
Still learning and working on MS Office applications the old school way, Rethink!
In Today’s world coping with work pressure is really tough and an average work day is not always long enough to get everything you need to do. Ever thought how much of your productive time do you spend on MS Office Applications? MS Excel for your data requirements, MS Outlook for your mails and MS PowerPoint for your presentations. Ever wondered these tools take up a good portion of your day, leaving you little time for creativity and productivity on your high-priority work. You deserve a career you love and office efficiency will get everything you need…
Getting professionally trained on these essential office productivity tools have helped millions of working professionals across the globe perform better, get recognition and most importantly achieve targets on time making it profitable for their Careers.
Office Efficiency is one of the most essential and widely sought after skills in the industry today. Learn professionally these skills with us in the corporate training environment with real-time hands on scenarios giving you right exposure to power use MS Office Applications with technical skills-sets, subject know-how, best practises and personality enhancement capabilities around Office Efficiency.
Certificate in Office Efficiency is an effective 360 degree approach to make you efficient in Office Productivity.
Course Outline:
Session 1: Logical aspects of Advanced Excel
- Basic Excel functionalities, Software uses and compatibilities, Exploring File Management Fundamentals, Importing and Exporting Files, File Security, Enhancing Accessibility and usage
- Understanding Logical Functions, Working with IF function, Understanding and creating Nested functions, Working with “AND” and “OR”, Working with IFERROR, SUMIFS and COUNTIFS etc…
Session 2: Data Slice-n-Dice for enrichment, rationale & reconciliation
- Understanding Data References, assignments on combined Text Functions, Array and Lookup Functions like Lookups, Vlookup, Hlookup, Index, Match, Offset, Address, Indirect, Self Joins etc…
- Advanced Sort Options, Levels of sorting, Using Data Filters, Advanced Filter, Sharing Workbook patterns & Formula Auditing
- Dynamic Name Ranges, Data Validations – Basic, Advanced and Indirect, Managing Conditional Formatting Rules, Advanced cell referencing, Data sourcing and Consolidation, effectively Handling Duplicates, Data Security aspects.
Session 3: Data Analysis using Advanced Excel tools
- Methods to identify and link active performance and volume indicators, usage of advanced what-if analysis templates using Data Tables, Goal Seek, Subtotals and Solvers.
Session 4: Mastering Data Presentation, Pivoting & Dashboards
- Understanding Report Elements and Report Layout options, Creating and Rearranging PivotTables, Creating customized Pivot Fields, Creating User-defined Charts, Adding and formatting different chart elements, Adding dynamics to tables and charts.
- A quick introduction on what is Macros, How do they work, Steps to record a basic Macro.
Session 5: Powerful Professional Impressions, your personality attributes
- Making powerful professional impressions
- Communicate effectively to make positive impact
- Participate in virtual meetings more confidently
- Striking better rapport and build healthy work relationships with team members and other cross functional teams
Session 6: Impact Presentations using Advanced MS PowerPoint
- Slide Layouts, Titles, SmartArt, Shapes, Org Charts and Tables, Orientation, Formatting, Backgrounds & Links Management
- Using Slide Master, Master Layouts, Working with Placeholders, Custom Color schemes, Custom design templates, customizing Logo placement, Tips and tricks to effectively manage template designs across slides
Session 7: Master the art of creating dynamic PPT’s
- Creating speaker notes, Printing and packaging a presentation, Delivering using Custom shows, Interactive Presentations, Linking PPT with other applications
- Pre-set Animation schemes, Custom Animation, Graphic Effects, Slide Transitions, Rehearse timings, Media plug-ins, Hyperlinks, Action Buttons and more…
Session 8: Power Presenter, the self enhancement skill
- Understand what are the essential aspects of body language while making a positive impact as a presenter
- Understand how to develop confidence while speaking
- Safeguard yourself from the common mistakes that people make as a presenter
- Engage the participants better while presenting your views
- Deliver impressive presentations in a meeting
Session 9: Advanced MS Outlook - Effective Email Management
- Customizing messages, organizing the inbox, Rules management, Stationary and Folder Options, Templates and Forms, Action buttons
- Understanding Outlook environment, customizing view Settings, Outlook Reading Pane settings, Calendar, Contacts, search and filter options
- Changing mail formats, Importing and Exporting data, setting Auto-replies, sharing and backup of Outlook Folders and Mailboxes
- Email Best Practises & Ettiquettes
Session 10: RDBMS Concepts using MS Access
- Understanding concepts of RDBMS using Tables, Records, Fields and Columns
- Primary Key and Foreign Key concept for data management
- Different Query types in MS Access
- Database Navigation Tips & Tricks
Elective Specialization:
- VBA Excel Macros
- VBA PowerPoint Macros
- Dashboard Designing
- Advanced Access with SQL queries
Duration:
10 days of intense hands-on training, spread across 5 weekends. (50 Hours)
Course Benefits:
- Live Example Files
- Industry Experts as trainers
- Comprehensive step-by-step guide, in form of study notes
- Case Study Approach
- Certification & Corporate Recognition
- Follow-up consultation by Experts, post course completion
- Free Access to Pro Capitalize Membership
- Logical Batch formation techniques, different batches for working professionals and freshers
Drop in your details here to know more and attend our FREE introductory workshop on Certificate in Office Efficiency