Microsoft Excel Basic

Inquire now

Microsoft Excel Basic Training is a beginner-friendly course designed to help participants develop the essential skills needed to work confidently with Microsoft Excel. Whether used for workplace tasks, academic activities, business reporting, or personal data organization, Excel provides a practical way to manage information, perform calculations, and present data clearly.

 

Duration: 1 day – 7 hr.

 

Overview

The Microsoft Excel Basic Training course provides a practical foundation for beginners who want to develop essential spreadsheet and data management skills using Microsoft Excel. Designed for learners with little to no prior Excel experience, the course introduces the core features and functions needed to create, organize, calculate, format, and present information efficiently.

Participants will learn how to navigate the Excel interface, create and manage workbooks and worksheets, enter and organize different types of data, and apply professional formatting techniques. The training also introduces essential Excel formulas and functions, enabling learners to perform calculations and summarize information accurately.

A strong emphasis is placed on productivity and efficient data handling. Participants will explore time-saving tools such as AutoFill, AutoSum, Flash Fill, AutoComplete, sorting, filtering, and Find and Replace. These features can help reduce repetitive work and make everyday spreadsheet tasks faster and more manageable.

The course also covers practical techniques for preparing spreadsheets for professional use, including worksheet organization, formatting, page setup, print settings, headers and footers, and customizing the Excel interface. Through guided demonstrations and practical exercises, learners will develop skills that can be immediately applied to workplace, academic, administrative, and personal tasks.

By the end of the Microsoft Excel Basic Training, participants will have the confidence to create and manage well-organized spreadsheets, perform basic calculations, work with data efficiently, and prepare professional-looking Excel workbooks for sharing or printing. This course also provides a strong foundation for progressing to intermediate and advanced Microsoft Excel training, including data analysis, PivotTables, dashboards, Power Query, and automation.

Learning Objectives

  • Create and format workbooks
  • Enter and format data
  • Summarize data using formulas and functions
  • Sort and filter data
  • Use time-saving tools such as AutoFill, AutoSum, and FlashFill
  • Properly prepare a spreadsheet for printing

 

Audience

  • Anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing.

 

Pre- requisites 

  • No Pre-requisites anyone can attend this course 

 

Course Content

The Excel Interface

  • Getting Started
  • Signing In
  • The Ribbon, Groups, and Tabs
  • Excel Templates
  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook

 

Entering Data

  • Selecting Data
  • Entering Text, Numbers and Dates
  • Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste
  • Using Paste Special
  • Using Find and Replace

 

Working with Cells, Rows and Columns

  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Hiding and Unhiding Cells
  • Hiding and Unhiding Rows
  • Hiding and Unhiding Columns
  • Sorting a Column
  • Filtering Rows

 

Working with Worksheets

  • Adding Worksheets
  • Deleting Worksheets
  • Copying Worksheets
  • Moving Worksheets
  • Hiding a Worksheet
  • Adding Color to Worksheet Tabs
  • Viewing Multiple Worksheets at Once
  • Viewing Multiple Parts of a Worksheet at Once
  • Freezing the Top Row
  • Freezing the First Column

 

Using Formulas and Functions

  • Understanding Cell References
  • Using SUM()
  • Using AVERAGE()
  • Using COUNT()

 

Using Time-saving Tools

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate

 

Formatting Text

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting
  • Using Format Painter

 

Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format
  • Changing Date Format

 

Formatting the Workbook

  • Changing the Theme
  • Inserting Page Breaks
  • Adding a Background

 

Printing Your Workbook

  • Using Excel’s Different Views
  • Using Print Preview
  • Specifying Number of Copies to Print
  • Selecting a Printer
  • Other Printing Settings
  • Specifying Page Orientation
  • Specifying Page Size
  • Changing Margins
  • Centering on Page
  • Adding Headers and Footers
  • Printing Portions of a Worksheet
  • Scaling to Fit Page
  • Repeat Headers on All Printed Pages

 

Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy