Master Microsoft Office Excel

Supercharge your productivity with the ultimate Microsoft Office Excel course designed for power users. Master every aspect of Excel and more with expert guidance and hands-on exercises. Unleash your full potential and become a proficient MS Office Ecel user. Enroll now and transform the way you work with Microsoft Office Excel.

Beginner 0(0 Ratings) 0 Students enrolled English
Created by Magson Fernandes
Last updated Sun, 17-Mar-2024
+ View more
Course overview

Experience the true power of Microsoft Office by joining our highly acclaimed Complete Microsoft Office Excel Training Course. With a focus on Microsoft Excel—an essential tool for calculations, data analysis, and data consolidation—this course is your gateway to mastering the entire Microsoft Office suite.

Unleash your potential and become proficient in Microsoft Excel. Our comprehensive training program covers all aspects of these vital MS Office products, empowering you to excel in every professional endeavor.

However, the true gem of this course lies in our in-depth coverage of Microsoft Excel. Unlock its full potential as you learn to manipulate data with ease, perform complex calculations, generate insightful charts and graphs, and leverage advanced formulas and functions. From basic tasks to intricate data analysis techniques, we guide you from beginner to expert level, equipping you with indispensable skills that set you apart from the crowd.

This isn't just another run-of-the-mill Microsoft Office training course. It's a comprehensive journey that takes you from novice to master. Our expert instructors provide step-by-step guidance, ensuring that you grasp each concept thoroughly and enabling you to apply your newfound knowledge in real-world scenarios.

Don't miss this opportunity to elevate your Microsoft Office skills to new heights. Enroll in our Complete Microsoft Office Excel Training Course today and embark on a transformative learning experience that will revolutionize the way you work with MS Office. From beginners seeking a solid foundation to experienced users aiming for mastery, this course caters to all skill levels. Join us now and unleash your full potential with Microsoft Office!

What will i learn?

  • Learn Microsoft Excel from Beginner to Expert Level
  • Learn the Mathematical Functions
  • You learn the Logical Functions
  • Learn the LOOKUP Functions
  • Learn the Excel Sheet Auditing Tools
  • You learn Data Consolidation in Excel
  • Learn Printing the Excel File
  • Learn About Form Controls
  • Learn the VBA & Macros
  • You learn the Shortcut Keys of Microsoft Excel
Requirements
  • Microsoft Office Installed in your System
Curriculum for this course
69 Lessons 06:05:22 Hours
Microsoft Excel
69 Lessons 06:05:22 Hours
  • Microsoft Excel Shortcut Keys
    .
  • 001 Introduction to Microsoft Excel Interface
    00:05:09
  • 002 Basic Math Functions
    00:06:46
  • 003 AutoSum Functions
    00:05:27
  • 004 Sum IF Function _ Remove Duplicates Option
    00:09:17
  • 005 Sum IF _ Sum IFs, Count IF _ Count IFs Functions
    00:10:41
  • 006 Sub Total Function
    00:05:57
  • 007 Arrays _ Sum Product Functions
    00:04:49
  • 008 Other Math Functions
    00:07:48
  • 009 Cell or Range Name
    00:02:25
  • 010 Absolute _ Relative References
    00:04:40
  • 011 Formatting Techniques in Excel
    00:12:08
  • 012 Excel Data Types
    00:04:12
  • 013 Roaming in Excel
    00:05:43
  • 014 Go to _ Replace Options
    00:05:27
  • 015 Auto Fill Options
    00:04:13
  • 016 Flash Fill Option
    00:05:50
  • 017 Copy, Paste _ Paste Special Options
    00:07:07
  • 018 Conditional Formatting
    00:06:10
  • 019 Sort _ Filter
    00:10:40
  • 020 Excel Operators
    00:08:53
  • 021 Equations Solving in Excel
    00:04:53
  • 022 Errors in Excel Sheet
    00:03:42
  • 023 Logical Function IF
    00:10:24
  • 024 Logical Function IF Error
    00:03:02
  • 025 Logical Function (IF, Nested IF, OR)
    00:11:09
  • 026 Logical Function AND
    00:10:12
  • 027 VLOOKUP Function
    00:03:51
  • 028 VLOOKUP with Data Validation
    00:05:19
  • 029 VLOOKUP Function with Wildcard
    00:05:26
  • 030 VLOOKUP Function with Helper Column
    00:04:08
  • 031 Nested VLOOKUP
    00:05:45
  • 032 HLOOKUP Function
    00:05:33
  • 033 Quick Audit Using Charts
    00:03:07
  • 034 Sheet Formulas Auditing Tools
    00:07:28
  • 035 Selecting the Chart
    00:05:53
  • 036 Charts in Excel
    00:08:21
  • 037 Tables in Excel
    00:04:29
  • 038 Pivot Table Chart
    00:08:35
  • 039 Sparklines _ Slicer Filter Options
    00:05:47
  • 040 Inserting Comments
    00:02:52
  • 041 Inserting Hyperlink
    00:05:27
  • 042 Info Functions
    00:02:53
  • 043 Text Functions
    00:04:28
  • 044 Date, Time _ Reference Functions
    00:07:33
  • 045 Printing _ Viewing the Excel Sheet
    00:09:54
  • 046 Text to Columns Tool
    00:03:54
  • 047 Data Consolidation
    00:09:15
  • 048 Scenario Manager Option
    00:10:15
  • 049 Goal Seek Option
    00:04:15
  • 050 Data Table Option
    00:04:38
  • 051 Queries in Excel _ Importing External Data
    00:09:38
  • 052 Dashboards
    00:12:23
  • 053 Form Controls
    00:12:41
  • 054 Recording _ Using Macros
    00:03:46
  • 055 Creating _ Using Macro Button
    00:04:41
  • 056 Visual Basic for Application (VBA) _ Macro Coding
    00:06:23
  • 057 Selecting The Chart for Data
    .
  • 058 Practice file.xlsx
    .
  • 059 All Regions.xlsx
    .
  • 060 CANADA Region.xlsx
    .
  • 061 UK Region.xlsx
    .
  • 062 US Region.xlsx
    .
  • 063 Yearly Consolidated Sheet.xlsx
    .
  • 064 Data File-01.xlsx
    .
  • 065 Data File-02.xlsx
    .
  • 066 Dashboard 01.xlsx
    .
  • 067 Dashboard 02.xlsx
    .
  • 068 Excel Macros _ VBA.xlsm
    .
+ View more
Other related courses
01:10:38 Hours
0 0 ₹11038
02:06:27 Hours
Updated Sun, 17-Mar-2024
0 0 ₹20627
02:22:04 Hours
Updated Sun, 17-Mar-2024
0 0 ₹22204
00:50:12 Hours
0 0 ₹5012
About instructor

Magson Fernandes

Educator in the Digital Age

1 Reviews | 3 Students | 27 My Courses
Teaching Learning Experimenting IT Web Designing App Designing Graphic Designing Etc
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

₹60522
Includes:
//send gift when already purchased by user