DSE – Data & Spreadsheet Essentials

Master Excel, Google Sheets, and data analytics with our comprehensive live course DSE – Data & Spreadsheet Essentials, designed for professionals, students, and data enthusiasts. This 10-week (80-hour) interactive training program will equip you with essential data skills, helping you analyse, clean, and visualise data effectively.

Through live sessions on Google Meet (Tuesdays, Thursdays, and Saturdays, 6:30 PM – 9:00 PM), our expert instructors will guide you through hands-on exercises, real-world case studies, and practical applications.

Whether you’re a business professional, researcher, or student, this course will enhance your ability to interpret data and make informed decisions. By the end, you’ll have a strong foundation in data analytics, setting the stage for advanced learning in business intelligence, machine learning, or financial modelling.

Looking for more? Explore our Data Analytics Bootcamp for advanced data science courses.

රු12,350.00

Building a Strong Data Foundation

Upon completing this course, a strong foundation in data management will be developed. You will understand how to capture essential information from everyday events, whether in a business setting such as tracking sales and stock levels or in research by recording experimental observations. Key concepts such as identifying what data needs to be stored, maintaining data integrity, and structuring information meaningfully will be emphasised to help you develop effective data management habits.

Practical Spreadsheet Skills

Comprehensive skills in spreadsheet handling will be acquired using both Excel and Google Sheets. You will master tasks such as cleaning messy data, performing essential calculations, and applying conditional formatting to enhance readability. Through practical exercises, you will learn how to create various charts and graphs to visualise patterns and insights clearly. Additionally, advanced summarisation techniques using pivot tables will be explored to help make large datasets manageable and insightful for decision-making.

Preparing for Real-World Applications

Whether entering the workforce immediately after GCE Advanced Levels or pursuing higher studies, confidence in managing and analysing data will be essential. You will be equipped to efficiently handle data-driven tasks, solve practical problems, and support decision-making in diverse industries. By the end of the course, you'll be ready to contribute meaningfully to academic research, business operations, or even personal projects by leveraging your newly acquired data skills.

Course Content

  1. Introduction to Data
    Discover the fundamentals of data, its types, and real-world sources like surveys and databases. Learn how data-driven insights influence decision-making in business, education, and everyday life, empowering you to make informed choices.
  2. Introduction to Spreadsheets
    Master the basics of Microsoft Excel and Google Sheets, from navigating the interface to creating, saving, and sharing files. Learn essential tools like formatting, formulas, sorting, and chart creation to streamline data handling and collaboration.
  3. Data Handling in Microsoft Excel and Google Sheets
    Learn to organize and structure raw data in Microsoft Excel and Google Sheets for analysis and visualization. Master importing data, efficient data entry, sorting, filtering, and conditional formatting to highlight key insights and streamline decision-making.
  4. Data Visualization in Microsoft Excel and Google Sheets
    Learn to create compelling charts and graphs in Microsoft Excel and Google Sheets to visualise data effectively. Master various chart types, customisation techniques, and best practices to enhance clarity and communicate insights with impact.
  5. Summarizing Data in Microsoft Excel and Google Sheets
    Efficiently summarize and simplify large datasets in Microsoft Excel and Google Sheets using essential functions like SUM, AVERAGE, and COUNT. Learn to leverage pivot tables, filters, and grouping tools to extract key insights and present data more effectively.
  6. Working with Multiple Sheets in Microsoft Excel and Google Sheets
    Learn to efficiently organise, manage, and analyse data across multiple sheets in Microsoft Excel and Google Sheets. Master techniques like linking data with formulas, using IMPORTRANGE to pull external data, and consolidating information for comprehensive analysis.
  7. Advanced Microsoft Excel Functions
    Enhance your Excel skills with advanced functions like XLOOKUP, INDEX, and MATCH for efficient data lookup and dynamic referencing. Learn to manage complex decision-making with advanced conditional functions and master error handling to build robust, professional spreadsheets.
  8. What-If Analysis, Scenario Planning & Forecasting in Excel
    Master advanced Excel techniques for decision-making with What-If Analysis, Scenario Manager, and Goal Seek. Learn to forecast trends, perform sensitivity analysis with data tables, and apply forecasting methods for more accurate business and financial planning.
  9. Introduction to Power Query in MS Excel
    Learn to efficiently extract, transform, and load (ETL) data using Power Query in Excel. Master data cleaning, column transformations, and combining queries from multiple sources to streamline your data preparation for analysis and reporting.
  10. Basics of Statistics in Excel
    Explore key statistical concepts in Excel, including measures of central tendency, variability, and percentiles. Learn to create frequency tables, perform hypothesis testing, and use the Analysis ToolPak to conduct regression and more advanced analyses.
  11. Developing Dashboards in Excel
    Learn to design and structure impactful dashboards in Excel by embedding charts, pivot tables, and key metrics. Enhance interactivity with slicers and dropdowns, and master the best practices for finalizing and securely sharing your dashboard with others.

Course Audience & Prerequisites

  • Beginners:

    • Ideal for those new to data analysis, Excel, and data visualization.
    • Focuses on building foundational skills for working with data in Excel and Google Sheets.
  • Intermediate Learners:

    • For individuals with basic Excel knowledge looking to advance their skills.
    • Covers advanced Excel functions, data visualization techniques, and statistical analysis.
  • Business Professionals:

    • Perfect for professionals who need to analyze data, create dashboards, and make data-driven decisions in business environments.
    • Focuses on practical applications of Excel and Google Sheets in business settings.
  • Students & Data Enthusiasts:

    • Aimed at students and anyone interested in improving their data analysis and visualization skills.
    • Ideal for personal projects, academic work, or further career opportunities in data fields.
  • No Prior Experience Needed:

    • While no specific prerequisites are required, basic knowledge of Excel or Google Sheets is helpful to get the most out of the course.

How to Register, Start Date, and Duration

  • Registration Process:

    • You can register from here.
    • Fill out the registration form with your details (name, email, and payment information).
    • Once registered, you will receive a confirmation email with course access instructions.
  • Start Date:

    • The course starts on specific dates, which are published on our website.
    • Sessions are conducted live through Google Meet.
    • New start dates for upcoming cohorts are updated regularly on our website.
    • You can also reach out to us via WhatsApp or email to inquire about the next session’s start date.
  • Course Duration:

    • Total Duration: 10 weeks
    • Total Class Hours: 80 hours
    • Class Schedule:
      • Classes are held on Tuesdays, Thursdays, and Saturdays.
      • Each class session lasts 2.5 hours.
      • The classes are scheduled from 6:30 PM to 9:00 PM.
    • Estimated study time outside class: 3-5 hours per week to complete lessons, assignments, and interactive activities.
  • Course Access:

    • Live sessions are hosted via Google Meet.
    • After registering, you will receive a link to join the sessions.
    • All course materials, including session recordings and resources, are accessible after each live session.
×

 

Hello!

Click one of our contacts below to chat on WhatsApp

×