In this Basic Data Analytics course, you will learn how to collect, clean, analyze, and visualize data using essential tools and techniques. You will work with tools such as Microsoft Excel, Google Sheets, and basic data visualization tools like Power BI. You'll also gain an understanding of data interpretation, reporting, and making informed decisions through basic analytics.
• Introduction to Microsoft Office Suite
• Overview of MS Office applications
• Licensing, installation, and interface tour
• MS Word Basics
• Creating, saving, editing documents
• Text formatting, paragraph alignment, bullets and numbering
• MS Word Intermediate Features
• Tables, headers/footers, page background
• Page layout, margins, and styles
• MS Word Advanced Tools
• Mail merge, references, table of contents
• Templates, collaboration, printing options
• PowerPoint Basics Creating slides, themes, and
• Layouts Adding and formatting text and images.
• Design and Multimedia
• Animations, transitions, audio/video
• Slide Master and templates.
• Presenting and Sharing
• Presenter view, printing handouts
• Exporting presentations, sharing tips
• Introduction to MS Outlook
• Email setup, composing, folders
• Calendar, tasks, and scheduling meetings
• Outlook Productivity Tips
• Rules, quick steps, search folders
• Integration with Word and Excel
• Understanding Excel
• Downloading and Installing Excel
• Operators and Functions in Excel
• Formatting Data in Excel
• Importing Data in Excel
• Data Cleaning in Excel
• Handling Missing Values
• LOOKUPs in Excel
• Pivot Table in Excel
• Data Modeling in Excel
• Data Analysis in Excel
• Making Charts in Excel
• Understanding Power Query
• Transforming Data in Power Query
• Understanding Power BI
• Downloading and Installing Power BI
• Basic Functionalities of Power BI
• Making Charts in Power BI
• Power BI Operators and Functions
• Data Cleaning in Power BI
• Data Transformations using Power Query
• DAX Functions in Power BI
• Data Modelling in Power BI
• Visualizing Data using Power BI
• Making Reports and Dashboards in Power BI
• Understanding Power BI Service
• Using Power BI Service
· Real-World Project
· Quiz + Practical Assignment
· Final Assessment & Certification
No reviews yet. Be the first to review this course!
Enroll in your desired course
Secure payment gateway
Click the button below to proceed with payment
Copyright © 2026 DITRP INDIA. All Rights Reserved