Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MS Excel for Beginners
Rating: 4.3 out of 5(82 ratings)
1,635 students

MS Excel for Beginners

Working on Hands on Experience in Excel for Students and professionals on MS Excel and provide some interesting insights
Created byKritika Dhiman
Last updated 4/2024
English

What you'll learn

  • Identify the different components of the Excel worksheet
  • Working With Rows, Columns and Cells
  • Working With Text and Various text features
  • Working with worksheets in a workbook and understand their difference
  • Gets Hands on experience on Basic level of using MS Excel

Course content

6 sections • 19 lectures • 1h 23m total length

  • Components of MS Excel4:35

    Learn the core components of Excel, including the active cell, columns, rows, cell address, and essential features like the workbook, sheet tabs, formula bar, ribbon, and quick access toolbar.

  • Hide/Unhide Ribbon, Total number of Rows and Columns5:40
  • Move Within Cells3:12

    Move within Excel cells with arrow keys and select multiple cells by dragging with the mouse or using shift arrow keys. The Name Box shows the active cell, like f9.

  • File Menu1:40

    Explore the file menu to create new workbooks, open existing worksheets, save or save as to a destination, and print with preview, orientation, margins, and scaling options.

  • Cell Destination2:29

    Identify the cell by its column and row (I9) in the name box, then jump to P25 or AQ197 using Ctrl+G, the Go To dialog, or by typing the address.

Requirements

  • Microsoft Excel (Any version) (Preferred 2019)

Description

The  Course on MS Excel aims to supplement the core curriculum by providing additional skills and knowledge that are relevant, practical, and align with the demands of the corporate world. This Excel course syllabus is designed for the beginner Excel user who desires to learn more advanced skills. Learn the new functions which will help students to become employable.

The outcome of an MS Excel course typically includes proficiency in spreadsheets creation. Participants gain practical skills for improved productivity in data management and reporting.

Areas Covered in this course includes basics of Microsoft Excel to usage of various functions such as Use of Ribbon, Working with Rows, Columns, and in between Cells.

The Details include:

Introduction to MS Excel , Organizing data ,Understanding the Row, Column, cells and basic layout of excel like Adjust row height and column width, Font formatting, Date, time, number and other formatting, Hide & unhide row and columns, cut, copy, paste, paste special, transpose, find, replace, merging and splitting of cells, freeze panes, inserting hyperlink and deleting hyperlink. Inserting worksheet, Change worksheet tab color, Rename a worksheet, Change worksheet order, moving, copying worksheet into new sheet and the same sheet.  Page break preview , Page layout view , Page setup dialog box , using print preview , printing worksheets .

Who this course is for:

  • Beginner's Excel Users

Report abuse