Course / Course Details

Master excel skills for beginners

  • Gayathri Perumal image

    By - Gayathri Perumal

  • 0 students
  • N/A
  • (0)

Course Description

  • Master Excel Skills for Beginners is a comprehensive course designed to help you build a strong foundation in Microsoft Excel. Whether you're a student, job seeker, or professional, this course will guide you through essential Excel tools and techniques used in everyday tasks.
  • You will learn how to organize data, perform calculations, create charts, and use basic formulas to improve productivity and decision-making. With hands-on examples and practical exercises, this course ensures you gain confidence in using Excel efficiently for personal and professional purposes.

Course Outcomes

  • Understand the Excel interface, menus, and basic functions
  • Create, edit, and format spreadsheets professionally
  • Enter and manage data efficiently
  • Use essential formulas and functions (SUM, AVERAGE, COUNT, etc.)
  • Apply cell formatting, conditional formatting, and styles
  • Sort and filter data to extract useful information
  • Create basic charts and graphs for data visualization
  • Perform simple data analysis for better insights
  • Save, print, and share Excel files confidently

    • Course Curriculum

    • 1 chapters
    • 72 lectures
    • 0 quizzes
    • N/A total length
    Toggle all chapters
    1 How to Auto Number Rows in Excel
    2.43 Min

    2 How to create a GST Bill format in Excel
    17.29 Min

    3 Import Text files into Excel 5 Methods
    13.08 Min

    4 Sort Names in the Alphabetical Order Last Names SORTBY Function
    3.38 Min

    5 Import Linkedin Contacts into Excel
    4.13 Min

    6 Fill the blank cells in Excel
    5.29 Min

    7 Formula to Insert Sheet Name in Excel
    3.2 Min

    8 Pivot Table Trick to Add Multiple Sheets in Excel
    2.39 Min

    9 How to create more than 100 Folders with a Single Click
    5.14 Min

    10 How to Unpivot Data data in Excel
    5.08 Min

    11 Import Text files into Excel
    1.24 Min

    12 Import Text File into Excel using Power Pivot
    2.19 Min

    13 Drop Down List that hides used Items
    5.19 Min

    14 Power Query Tips and Tricks Excel Tutorial for Beginners
    33.16 Min

    15 How to create a Dynamic Dependent Drop Down List in Excel
    7.48 Min

    16 How to move Worksheets between Excel Workbooks
    2.22 Min

    17 Highlight the High and Low Points of a Chart in Excel
    8.43 Min

    18 Insert a Blank Row after Every Row in Excel
    3.49 Min

    19 Macro to Insert Blank Rows in Excel
    5.1 Min

    20 10 Methods to create a Number Series in Excel
    6.46 Min

    21 Highlight Active Cell Row or Column in Excel
    4.01 Min

    22 VLOOKUP from different sheets VLOOKUP with Excel Tables
    12.05 Min

    23 How to Prevent Duplicate in Excel
    8.11 Min

    24 How to Connect Tables in Excel
    12.38 Min

    25 How to connect Google Sheets to Excel
    5.31 Min

    26 Create PDF from an Excel sheet using a Single Click Macro for Generating PDFs from Excel sheets
    4.09 Min

    27 How to Reverse a List in Excel 3 Methods
    5.21 Min

    28 5 different methods to Find the Top n Numbers in Excel
    7.46 Min

    29 How to create Dependent Drop Down Lists using Excel Table
    9.18 Min

    30 How to Remove Duplicates in Excel
    10.24 Min

    31 5 different methods to Split Data in Excel
    11.4 Min

    32 How to Insert PDF file into an Excel File
    4.18 Min

    33 Excel formula to extract Text or Number between Parentheses
    7.1 Min

    34 Find the matching values between 2 Tables in Excel
    8.07 Min

    35 How to Add New Worksheets in Excel
    6.59 Min

    36 How to hide Zeros in Excel
    4.25 Min

    37 How to Copy only the Visible cells in Excel
    4.18 Min

    38 Dynamic Array Formula to Unstack data in Excel
    4.47 Min

    39 How to Unstack Data in Excel
    3.43 Min

    40 Unstack Data from a Single column to Multiple columns with Power Query in Excel
    4.25 Min

    41 Calculate Age from Date of Birth in Excel
    7.25 Min

    42 Advanced Conditional Formatting Tricks in Excel
    4.25 Min

    43 Formula to Insert Sheet Name in Excel
    3.2 Min

    44 How to link a Text box to a cell in Excel
    3.28 Min

    45 How to Split Cells Diagonally in Excel 3 Methods
    4.22 Min

    46 Create the list of files in a folder and link it to Excel without VBA
    3.01 Min

    47 7 methods to Copy formula into adjacent cells below in Excel
    5.37 Min

    48 How to print a Large Excel sheet into One page
    1.43 Min

    49 Formula to make a random selection in Excel
    2.44 Min

    50 Excel formula to Pick 3 random values from a list without Duplicates
    3.53 Min

    51 How to randomly assign people to different Teams using Excel
    7.27 Min

    52 How to Join Tables using VLOOKUP formula in Excel
    6.02 Min

    53 How to convert URL into QR Code using Excel
    2.38 Min

    54 Formula to Calculate Time Difference in Excel
    5.17 Min

    55 Excel formula for Multiple Match Results
    2.3 Min

    56 How to send WhatsApp Messages from Microsoft Excel
    4.17 Min

    57 Excel Custom Formatting Technique to display Variance with Symbols
    1 Min

    58 Python Program edit 1000s of Excel Files
    9.44 Min

    59 Greatest Excel Tricks of all time
    4.58 Min

    60 How to create Barcodes using Microsoft Excel
    4.03 Min

    61 Create QR Code in Excel 2 Methods
    3.07 Min

    62 Macro to combine data from Multiple Excel Worksheets
    4.59 Min

    63 Calculate Age from Date of Birth Excel formula
    4.19 Min

    64 Consolidate data in Excel
    1.59 Min

    65 How to find the Day Name from Date Excel Formula
    1.49 Min

    66 Find the Rank of only those students who have Passed excelshorts

    67 VLOOKUP formula Excel Beginners Tutorial
    5.2 Min

    68 How to convert Small letters to Capital letters in Excel
    2.48 Min

    69 Excel template for Stock Management
    14.51 Min

    70 Data Entry form in Excel
    4.11 Min

    71 Insert Page numbers in Excel Sheet
    3.18 Min

    72 How to Compare Two Excel Sheets and find differences
    3.1 Min

    Instructor

    Gayathri Perumal

    0 Rating
    0 Reviews
    0 Students
    36 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

    Enrol

    • Duration N/A

    • Lectures 72 lessons

    • Enrolled 0 students

    • Category: IT & Software

    • 0 Quizzes

    • Language: English

    • Skill Level Beginner

    • Certificate of Completion

    • Full lifetime access

    Remove Coupon
    Coupon Applied!

    Shopping Cart

    Loading...