Microsoft Excel - From Beginner to Expert

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Latest Version Excel for Windows.

Beginner 5(1 Ratings) 2 Students enrolled English
Created by Execl Expert
Last updated Mon, 06-Sep-2021
+ View more
Course overview

This training provides you everything you need to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel.

You will learn all of the following about Microsoft Excel:

    Learn how to navigate around Excel
    Learn how to enter and edit data in Excel
    Learn how to adjust the way data and information are displayed in Excel
    Learn how to write formulas quickly and easily with the point-and-click method
    Learn how to use relative, absolute, and mixed references in Excel
    Learn how to create powerful calculations with Excel functions
    Learn how to visually represent your data with charts and graphs in Excel
    Learn how to use Excel data tools like sorting, subtotaling, and filtering
    Learn how to "freeze columns and rows" with freeze panes in Excel
    Learn how to remove duplicates from data in Excel
    Learn how to "transpose data" - switching the columns and rows in Excel
    Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
    Learn how to format worksheets in Excel for impact and appeal
    Learn how to automate Excel tasks with time-saving macros
    Learn how to integrate Microsoft Excel with Microsoft Word
    Learn how to use passwords in Excel to protect your work in multiple scenarios
    Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
    Learn how to use printing and sharing in Excel

What will i learn?

  • Learn Microsoft Excel
  • From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel
  • Lifetime access to this Excel class allows you to easily review material and continue learning new material
  • After taking this training, you will be an expert at Microsoft Excel
  • Learn from a Microsoft Certified Master Instructor with over 15 years of experience teaching individuals of all ability levels
  • Presented with high-quality video lectures, this Excel course will visually show you how to easily do everything in Excel
  • Excel Project Files and Excel Templates are included allowing for enhanced learning through hands-on activities
Requirements
  • In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel.
Curriculum for this course
24 Lessons 00:00:00 Hours
Introduction
1 Lessons 00:00:00 Hours
  • Microsoft Excel Introduction
    .
Microsoft Exel Basics
10 Lessons 00:00:00 Hours
  • Understanding Cell
    .
  • File Options
    .
  • Format Painter
    .
  • Find and replace function, Modifing column and raw height
    .
  • Insert, Delete, Hide-Unhide Column Raw , Wrapping and Merging
    .
  • Font size, text alignment , Font colors and borders
    .
  • Fill colour Cell style Formatting text and numbers
    .
  • Renaming Insert Deleting move/copy tab columns
    .
  • Page Layout
    .
  • Headers and Footers , Printing a workbook
    .
Microsoft Excel Advanced
13 Lessons 00:00:00 Hours
  • Uses of Microsoft Excel
    .
  • Advanced Mathematical operators
    .
  • Creating Fuctions in Excel
    .
  • TRIM in Excel
    .
  • TRIM in Excel Example
    .
  • SUMIF Excel
    .
  • PROPER function
    .
  • Create Charts in Excel
    .
  • Relative & Absolute Cell References in Excel
    .
  • CONCATENATE Function
    .
  • The COUNTA function in Excel
    .
  • vlookup in excel
    .
  • Macros in Excel
    .
+ View more
Other related courses
About instructor

Execl Expert

1 Reviews | 2 Students | 1 Courses
Student feedback
5
1 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (1)

Reviews

  • Midhun Om
₹12000 ₹4999
Includes: