Microsoft Excel Basic & Intermediate

Enroll Now
  • Duration: 12 Hours
  • Module: 7 Modules
  • Platform: Online & In-Person

COURSE OVERIVEW

  • Certified Training on Microsoft Excel is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets using Excel.
  • Students will also work with charts and advanced formatting including styles, advance their skill set by learning to work with advanced formulas, lists, and illustrations.
Course Benefits
  • Hands-on learning with up to Date Projects.
  • Certified Instructors.
  • Course Material and Additional Self Study Resources.
  • Certificate of Completion.
Registration Policy (Check before registration)

COURSE OUTLINE

  1. Lesson 1: Introduction to Microsoft Excel
    • Overview of Excel interface
    • Ribbon, menus, and tabs
  2. Lesson 2: Workbook and Worksheets
    • Creating, opening, and saving workbooks
    • Managing multiple worksheets
  3. Lesson 3: Basic Excel Navigation
    • Cell addressing and referencing
    • Navigating within worksheets
  1. Lesson 4: Entering Data
    • Typing and editing data in cells
    • Using AutoFill and Flash Fill
  2. Lesson 5: Formatting Cells
    • Font, size, and color
    • Number formatting
    • Cell borders and shading
  1. Lesson 6: Introduction to Formulas
    • Understanding basic mathematical operators
    • Creating simple formulas
  2. Lesson 7: Common Functions
    • SUM, AVERAGE, COUNT, MAX, and MIN functions
    • Using functions for basic calculations
  1. Lesson 8: Sorting and Filtering
    • Sorting data in ascending and descending order
    • Filtering data based on criteria
  2. Lesson 9: Data Validation
    • Setting rules for data entry
    • Creating drop-down lists
  1. Lesson 10: Introduction to Charts
    • Creating basic charts (bar, line, pie)
    • Customizing chart elements
  1. Lesson 11: Conditional Math
    • SUMIF, COUNTIF, and SUMIFS to add cells only when certain conditions are met.
  2. Lesson 12: Text Functions
    • LEFT, RIGHT, MID, FIND and SEARCH functions, and to combine text with the & character.
  3. Lesson 13: Statistics Functions
    • COUNT, COUNTA, AVERAGE, MAX, MIN, MEDIAN, and MODE.
  4. Lesson 14: External Links
    • Creating and updating external links, and about the potential dangers of external links in Excel.
  5. Lesson 15: Conditional Formatting
    • Highlighting cells based on conditions
    • Data bars, color scales, and icon sets
  1. Lesson 16: Pivot Table 
    • Creating pivot table
  1. Lesson 17: Sharing and Protecting Workbooks
    • Collaborating with others on a shared workbook
    • Protecting worksheets and workbooks
  2. Lesson 18: Print Documents
    • Print areas and titles
    • Print preview and adjustments

COURSE PREREQUISITES of Certified Training on Microsoft Excel

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.

WHY THIS COURSE?

In today’s data-driven world, proficiency in Microsoft Excel is a fundamental skill that opens doors to enhanced productivity, efficient data management, and informed decision-making. The “Microsoft Excel Basic & Intermediate” course is designed to empower individuals with the essential knowledge and practical skills needed to navigate Excel confidently, leverage its powerful features, and transform raw data into meaningful insights.

WHY CHOOSE ICDB

Experience

We have been in the market since 2016, and we kept accumulating experience in the training business, and providing training for more than 20,000 trainees ever since, in Bangladesh & India.

Premium Facilities

ICDB facilities are well-equipped with strong hardware and software technologies that aid both students and trainers lead very effective smooth training programs.

Customer Support

We provide our clients with the best solutions, customized to their specific needs and goals. Our team is highly qualified to answer whatever questions you have.

Global Accredited

ICDB is an authorized and accredited partner by technology leaders. This means that our training programs are of the highest quality source materials.

Up To Date

We keep tabs on every change in the market and the technology field, so our training programs will always be updated up to the World-class latest standards, and adapted to the global shape-shifting job market.

Certified Instructors

We select the best instructors, who are certified from trustworthy international vendors. They share their professional experience with the Trainees, so they can have a clear hands-on experience.

Our Strategic Clients