Excel for Beginners

  • Overview
  • Course Outline
  • Reviews
  • None (0 Rating)
  • 0 Reviews

Course Overview

    Excel for Beginners is a comprehensive introductory course designed to help individuals with little to no prior experience in using Microsoft Excel become proficient in the application. Whether you are a student, professional, or someone looking to enhance your spreadsheet skills, this course will provide you with a solid foundation in Excel's core features and functions. You will learn how to create, format, and analyze data, as well as build basic charts and graphs.

Requirements

    No prior knowledge of Excel is required. Students should have access to a computer with Microsoft Excel installed.

    Teaching Methodology:

    • Interactive lectures and demonstrations.
    • Hands-on exercises and practice activities.
    • Group discussions and Q&A sessions.
    • Practical assignments to reinforce learning.
    • Final project to apply Excel skills in a real-world scenario.

What you’ll learn

    By the end of this course, participants should be able to:

    • Navigate the Excel interface with ease.
    • Create, save, and manage Excel workbooks and worksheets.
    • Enter, edit, and format data effectively.
    • Utilize basic Excel functions and formulas.
    •  Employ data analysis techniques such as sorting, filtering, and tables.
    • Create and customize charts and graphs.
    • Apply conditional formatting to highlight data trends.
    • Work with multiple worksheets and protect workbook content.
    • Be prepared for further Excel courses or real-world Excel usage

     

    Certificate

    ** Certificate will be awarded, upon successful completion of the course

Why Charterd Skills

    Chartered Skills is a professional & educational e-learning & hiring platform that provides a wide range of skill-oriented courses helping individuals reach their professional goals. Our platform enables entrepreneurs to learn their industry know-how, helps job seekers match their skill sets with the ideal jobs & allows professionals to remain relevant in their industries through upskilling & microlearning. When you complete a course on Chartered Skills, you become a certified expert through our accreditations. 

    Along with access to the finest technology & industry experts, Chartered Skills also provides support all the way during & after your course. With access to a personalised dashboard, you will be able to access the courses you have completed, quizzes you have taken and of course, the Certificate of Completion for all completed courses. So start upgrading your skill sets, establish yourself as a leader in your industry and stay relevant in the dynamic ways of the current world, only through Chartered Skills. 

Instructors

A.B.M. KALIM ULLAH

PMP, ACS, CGIA, DASSM, CLSSGB

Course Outline

    Week 1: Introduction to Excel 

    • Lesson 1: What is Microsoft Excel? 
    • Lesson 2: Navigating the Excel Interface 
    • Lesson 3: Workbook and Worksheet Basics 
    • Lesson 4: Saving, Opening, and Closing Workbooks 
    • Lesson 5: Entering Data and Editing Cells

    Week 2: Basic Excel Functions and Formatting 

    • Lesson 6: Simple Formulas and Functions 
    • Lesson 7: Formatting Cells and Text
    • Lesson 8: Number and Date Formatting
    • Lesson 9: Cell Styles and Themes
    • Lesson 10: Basic Data Validation

    Week 3: Data Management and Analysis

    • Lesson 11: Sorting and Filtering Data 
    • Lesson 12: Using Tables for Data Organization
    • Lesson 13: Data Cleanup and Text Functions
    • Lesson 14: Introduction to Charts and Graphs
    • Lesson 15: Creating Bar and Pie Charts

    Week 4: Advanced Excel Features

    • Lesson 16: Conditional Formatting 
    • Lesson 17: Working with Multiple Worksheets
    • Lesson 18: Introduction to PivotTables
    • Lesson 19: Data Protection and Workbook Security
    • Lesson 20: Final Review and Course Recap


This course includes:

  • Start at: Nov. 20, 2023
  • Access from Mobile/Tab/PC
  • Professional Resources
  • Personal Mentor Support
  • Student Support Community
  • Certificate of completion
Tk. 5000.0

Tk. 2500.0

Duration: 16 hours
(2 Class/Week)
New batch Start Soon
Download Curriculum    Download Brochure