Learn Microsoft Excel from Begineer to the Expert Level

Saurabh Bhardwaj

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
19 Videos (5h 7m)
    • Introduction to MS Excel Window, Tabs, Icons, Quick Access Toolbar

      8:03
    • Adding commands to QAT, Status Bar, Formula Bar, Insert column and rows

      19:15
    • Autofill, Date

      14:44
    • Time, Comment, Copy, Move

      12:10
    • Formulas, Percentage change, Absolute in Excel

      22:02
    • Other common functions in Excel, If condition, Countif condition, Sumif condition

      28:29
    • Formatting, Alignment, Merge and Center, Wrap

      16:32
    • Borders, Currency

      9:48
    • Sorting & Filter

      19:00
    • Conditional Formatting

      14:20
    • Tables, Shapes, Smart Art

      18:49
    • Hide Unhide rows & columns, Find & Replace

      11:58
    • Printing, Page Layout, Page Break Preview

      15:02
    • Charts

      20:34
    • Vloopup, Vlookup Exact

      18:25
    • Subtotals, Freezing of rows and columns, Protection of sheets

      18:18
    • Data Validation

      11:19
    • Pivot Table

      13:55
    • VBA and Macros

      14:40

About This Class

Do you get frustrated by dealing with so much data? Do you want to excel Microsoft excel, so that you can perform better than your colleagues and friends? Awesome, you are at the right place!

Microsoft Excel is an important tool for organizing and understanding data about the world you live in! You will learn to navigate your way through all necessary functions of the software, understand practical applications, and gain the confidence to use it for your information needs. Having taught 1000s of people this software, they were able to make an instant improvement in their skill level.

Join now and make the commitment of going through our course. It is sure to enhance your skills and level of knowledge with Excel.

Look forward to see you in the course.

==

Apply essential Excel operations to your list of data

ASSIGNMENT

Take some data you have from a project you are working on and prepare the data to be analyzed. The data could be a list of your expenses, a list of your colleagues or something else.

DELIVERABLE  
Do the following things

Filter and/or sort it by a column
Apply fill and font colors to your data
Write a SUM() and/or CONCATENATE() formula in a blank cell to summarize and clean up your dataUse VLOOKUP, HLOOKUP and INDEX - MATCH formulas

15

Students

--

Projects

0

Reviews (0)

Technology Microsoft Excel Data Science