Course / Course Details

Basics of microsoft excel for beginners

  • Gayathri Perumal image

    By - Gayathri Perumal

  • 0 students
  • N/A
  • (0)

Course Description

  • This beginner-friendly course introduces the fundamentals of Microsoft Excel, one of the most essential tools for data organization, calculation, and reporting. Learners will explore the Excel interface, worksheets, formatting, formulas, functions, charts, and basic data management techniques. Through practical exercises, participants will gain confidence in creating spreadsheets, analyzing simple data, and improving workplace productivity using Excel.

Course Outcomes

  • Understand the Microsoft Excel interface and workbook structure
  • Create, save, open, and manage Excel worksheets and workbooks
  • Enter, edit, and format data professionally
  • Use basic formulas and functions (SUM, AVERAGE, COUNT, MIN, MAX)
  • Apply cell formatting, borders, alignment, and conditional formatting
  • Sort and filter data efficiently
  • Create basic charts and graphs for data visualization
  • Manage rows, columns, and worksheets effectively
  • Perform simple data analysis and reporting tasks
  • Improve productivity using Excel shortcuts and best practices

Course Curriculum

  • 1 chapters
  • 40 lectures
  • 0 quizzes
  • N/A total length
Toggle all chapters
1 What is Rows and Columns in MS Excel Basics of Microsoft Excel for Beginners msexcelcourse
13.38 Min


2 Introduction to MS Excel Microsoft Excel Full Course Beginner to Advance Level exceltutorial
10.3 Min


3 MS Excel Basic Formulas Full Tutorial Most Important Formulas in Excel msexcelcourse msexcel
10.05 Min


4 How to Insert Rows and Columns in MS Excel Basics of MS Excel for Beginners msexcelcourse excel
5.37 Min


5 Learn MS Excel Data Entry Basics How to Data Entry Work in Excel for Beginners msexcelcourse
8.26 Min


6 How to Apply Formula in Tabular Format in Excel Tabular Format in Excel MS Excel Full Course
6.33 Min


7 What is Conditional Formatting in Excel How To Do Conditional Formatting in Excel exceltutorial
8.21 Min


8 How to use IF AND OR Functions in Excel MS Excel IF Function IF Formula in Excel excel
17.37 Min


9 How to Convert Excel Spreadsheet Data Into a Table Excel Data into Table Form MS Excel Course
7.56 Min


10 How To Use Sort and Filter Functions in MS Excel Sort Function Excel Filter Function in Excel
11.21 Min


11 How to Make a Chart and Graph in Excel MS Excel Chart and Graphs Step by Step Tutorial msexcel
9.2 Min


12 How to Print an Excel Sheet How to Print Out Large Excel Sheet in A4 Paper excelcourse
4.57 Min


13 How to Use Home Tab All Features in MS Excel Home Tab in Excel Complete Tutorial msexcel
18.15 Min


14 How to Add Bullet Points in Excel How to Insert Bullet in Excel MS Excel Course exceltutorial
4.44 Min


15 How To Group and Ungroup Rows and Columns in Excel Group and Ungroup in Excel excelcourse
4.26 Min


16 How to Add and Create Borders in Excel MS Excel Course for Beginners msexcelcourse
6.45 Min


17 How To Insert Watermark In MS Excel Excel Logo Transparent Background MS Excel Course
7.44 Min


18 How To Use Quick Access Toolbar in Excel How To Customize Quick Access Toolbar in Excel excel
5.01 Min


19 How To Hide and Unhide Columns and Rows in Excel How To Select and Fill Blank Cells in Excel
6.42 Min


20 What is Paste Special and How to use this Option in MS Excel Full Guide MS Excel Course
10.53 Min


21 How to use Header Footer Status Bar Number Format Change Case in MS Excel msexcelcourse
14.55 Min


22 How To Protect Your Excel Workbook How To Protect Excel File With Password msexcelcourse
8.38 Min


23 How to use Format Painter in Excel MS Excel Format Painter Shortcut msexcelcourse
4.57 Min


24 How To Use Hyperlinks in Excel How To Create a Hyperlink in Excel Excel Hyperlink Tutorial
10.22 Min


25 How To Do Spell Check In Excel Spelling Autocorrect In Excel Comments Function In Excel
4.2 Min


26 Array Function in MS Excel How To Use Array Formula in Excel arrayfunction msexcelcourse
5.36 Min


27 Using the Excel Average and Average IF Functions Excel Average Formula Explained
9.59 Min


28 How to use DAVERAGE Formula in Excel Microsoft Excel DAVERAGE Function MS Excel Course
4.46 Min


29 DGET Formula in Excel DGET Full Form Excel MS Excel DGET Function msexcelcourse
4.26 Min


30 MAX MIN D MAX D MIN Formulas in Excel Excel MAX MIN Formula MS Excel Course excelcourse
8.21 Min


31 Date Formula in Excel and Date Functions in Excel TODAY EDATE and NOW Formulas in MS Excel
6.04 Min


32 How to use COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS DCOUNT Formulas in MS Excel msexcelcourse
16.08 Min


33 MS Excel Formulas Reminder Even Odd Microsoft Excel Course For Beginners msexcel
7.26 Min


34 MS Excel Functions Round Round Down Factorial and Discount Explained msexcelcourse
8.47 Min


35 MS Excel Formulas INTEGER ROMAN NO TRIM ABSOLUTE CONCATENATE msexcelcourse
11.13 Min


36 How To Calculate Simple and Compound Interest in MS Excel msexcelcompletecourse
12.13 Min


37 The Excel FORECAST Function How to Calculate Depreciation in MS Excel msexcelcompletecourse
12.49 Min


38 How to Use Pivot Tables and Charts in Excel Advanced Pivot Table Pivot Chart Tricks
10.44 Min


39 What is Data Validation Excel Data Validation in Excel msexcelcourse datavalidation
14.34 Min


40 MS Excel Important Settings Best Tips and Tricks in Excel Microsoft Excel Course
13.3 Min


Instructor

0 Rating
0 Reviews
1 Students
137 Courses

Course Full Rating

0

Course Rating
(0)
(0)
(0)
(0)
(0)

No Review found

Sign In or Sign Up as student to post a review

Student Feedback

You must be enrolled to ask a question