E-Learning Portal

The Excel Beginner Level course is designed to provide foundational skills for individuals new to Microsoft Excel. Covering a wide range of essential topics, it starts with an introduction to Excel, exploring its interface, tools, and navigation, including ribbons, tabs, and the Quick Access Toolbar. It progresses to fundamental operations like creating, saving, and managing workbooks and worksheets, as well as entering, editing, and formatting data. Learners will understand formulas and functions, including essential ones like SUM, AVERAGE, MIN, and MAX. The course also delves into handling errors, understanding absolute vs. relative referencing, and leveraging powerful tools such as AutoSum, AutoFill, and Flash Fill. To enhance productivity, it covers named ranges, formatting options, and useful shortcuts. Practical exercises throughout ensure hands-on practice, making this course ideal for beginners aiming to build a solid Excel foundation.

Learn Microsoft Project, the world's leading project management software, with this comprehensive training course covering Project 2019 and Project Online Desktop. Instructor Bonnie Biafore, PMP, begins by guiding you through project setup, including work tasks, summary tasks, milestones, recurring tasks, and resource types. You'll learn how to link and schedule tasks, assign resources to create a realistic project timeline, and utilize different views to monitor project status. The course also covers evaluating schedules and resource workloads to keep projects on track and within budget. Plus, discover how to generate reports and effectively share project insights with your team.

The Word Basic Course offers a comprehensive introduction to Microsoft Word, designed to equip learners with essential skills for creating and managing professional documents. Starting with an overview of the Word interface, ribbon, and help options, the course guides users through foundational tasks such as working with fonts, paragraphs, and styles to format text effectively. Participants will explore creating and managing lists, proofing documents, and saving their work efficiently. Advanced topics include using contextual tabs, integrating shapes, leveraging the online image library, and resizing, restyling, cropping, and editing pictures. Additionally, the course delves into page layout commands, headers and footers, and exporting documents to PDF. With clear explanations and hands-on demonstrations, this course is perfect for beginners aiming to build confidence and mastery in Word.

The Word Intermediate Course is designed to elevate your Microsoft Word skills to a professional level by exploring advanced document creation and formatting techniques. Through a series of comprehensive lessons, you'll learn how to create and manage text styles, work with tables and charts, and customize layouts with precision. Dive deeper into document formatting with themes, cover pages, columns, and section breaks to achieve a polished, cohesive design. Enhance productivity by mastering reusable content, Quick Parts, and saving templates. Additionally, you'll gain expertise in creating detailed references with tables of contents, indexes, and the outline view. The course concludes with practical applications like Mail Merge integration with Outlook, ensuring you're equipped with tools for efficient and professional document management. Whether you're streamlining workflows or designing standout documents, this course provides all the tools you need to succeed.

The course covers the following topics:

• Introduction to Negotiation • Negotiation myths busted • BATNA • ZOPA • Aspiration point • Reservation point • Types of negotiation • What to do during negotiation • Slicing the pie • Frequently asked questions • Barriers to agreement • Advanced scenarios

Course Completion Certificate Available on Passing Final Quiz.

The Office Workplace Safety e-learning course provides a comprehensive overview of essential safety principles and practices necessary for creating a secure, healthy, and compliant work environment. Beginning with foundational Safety Essentials, the course progresses through critical topics such as Office Safety, Ergonomics, and the safe use of PC Display Screens, emphasizing injury prevention and employee well-being. Modules on Fire Management and Building and Office Evacuation prepare staff for emergency scenarios, while topics like Workplace Bullying, Work-Related Stress, and Fatigue at Work address psychosocial risks. Practical components include Manual Lifting, CPR (Cardiopulmonary Resuscitation), and Safe Driving, alongside responsible practices in Waste Management, Workplace Housekeeping, and Drugs and Alcohol Awareness. The course concludes with an introduction to Personal Protective Equipment (PPE), reinforcing the importance of proactive safety behaviors. This training equips employees with the knowledge and skills to maintain a safe, productive, and respectful workplace.

Enhance your Outlook skills with this e-learning course designed to help you craft effective, professional, and inclusive messages. Starting with the basics of using Outlook, you’ll learn to write impactful emails for clients and managers, manage email settings, and utilize copyright and trademark symbols. Practice techniques for creating polite, concise expressions, setting out-of-office replies, and designing email signatures. Finally, discover how to efficiently organize your email inbox for maximum productivity. Whether you're new to Outlook or looking to refine your email skills, this course equips you with practical tools for professional success.

This course covers the following topics:

Appraisal process - nuts and bolts• Process of appraisal discussion • Rating methods • Common errors in appraisal • Feedback • Appraisal discussion with poor performer • Managing emotional situations • Development planning

Course Completion Certificate Available on Passing Final Quiz.

The course covers the following Topics:

•Understanding CALCULATE •Clear filter on one column only (calculate with filter function) •YTD functions •Previous year and DATEADD functions •Periodic calculation •Understanding Report view and creating a new report •Page display settings in a Power BI report •Setting color theme aligned to project/company color theme & Theme Gallery •Adding non-visualization object •Inserting Basic charts and understanding format tab •Creating Comparison visuals (Doughnut Chart) •Creating Bar chart for Top 5 Customers •Plotting Values on a Map Visual •understanding Matrix visual along with Conditional Formatting •Comparing Actual vs. Target using Gauge Chart •Using Slicers and understanding its impact on the report •Showing Monthly trend with a line chart •Setting up forecast in line chart •Creating area chart with tooltips •Building amazing KPI’s •Drillthrough report pages •3rd party visuals/Custom Visuals •Bookmarks •QnA •Sync slicers •Key Influencer Example 1 •Key Influencer Example 2 •Function based visual title •What if parameters •Setting RLS (Row level security) •Tooltip Page •Different types of filters in report view •Change how visuals interact in a report •Publish the Report to Cloud •PBI Service Overview, types of accounts and users