All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 9 Days!

Browse Library

Get Unlimited Learning Access
$29
9 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access to 16000+ online courses
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Free Instructor Support
  • Access valid for 1 user only
  • Cancel Anytime
$29
  • Macro and VBA for automation
  • Basic analytics
  • Data Validation, Pivot table, Vlookup

Get yourself equipped with knowledge in Excel.

 

What you will become after going through this course:

  • Master Microsoft Excel from Beginner to Advanced

  • Build a solid understanding on the Basics of Microsoft Excel

  • Learn the most common Excel functions used in the Office

  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA

  • Maintain large sets of Excel data in a list or table

  • Create dynamic reports by mastering one of the most popular tools, PivotTables, Data validation

  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

  • Access to a Professional Trainer with 10+ years of Excel Training- @[email protected]

     

This course will provide learning in the below mentioned topics

  1. Basics in Excel

  2. Graphical representation in Excel

  3. Analytics in Excel.

  4. Data validation, Advanced Pivot tables, Advanced lookup operations.

  5. Macro used to send daily report.

  6. Writing VBA code to automate the manual tasks.

Advanced excel topics will be provided as part my advanced course.

Basics covers all the topics related to introduction, What are the options available in excel

Graphical representation covers Graphs, Tables and other presentation materials

Analytics in Excel covers all the formulas and validation that can be performed in excel.

  • Basic computer knowledge
  • College students and office goers
  • Newbies willing to learn excel
View More...
  • Section 1 : Introduction 10 Lectures 01:02:06

    • Lecture 1 :
    • Lecture 2 :
    • Names and Ranges
    • Lecture 3 :
    • Cell formatting - Part 1
    • Lecture 4 :
    • Cell formatting - Part 2
    • Lecture 5 :
    • Searching and commenting
    • Lecture 6 :
    • Essential operation in excel
    • Lecture 7 :
    • Working with tables
    • Lecture 8 :
    • Fonts in Excel
    • Lecture 9 :
    • Styles and Themes
    • Lecture 10 :
    • File recovery and protection of Excel
  • Section 2 : Formulas and functions in Excel 5 Lectures 00:36:22

    • Lecture 1 :
    • Formulas and functions in Excel- Introduction
    • Lecture 2 :
    • Working with formulas and function
    • Lecture 3 :
    • Frequently used functions and formulas
    • Lecture 4 :
    • Frequently used formulas in Excel - Part2
    • Lecture 5 :
    • Working with dates in excel
  • Section 3 : Chart and graphical representation 4 Lectures 00:19:19

    • Lecture 1 :
    • Charts - An Introduction
    • Lecture 2 :
    • Conditional formatting and Sparklines
    • Lecture 3 :
    • Pivot table
    • Lecture 4 :
    • Other graphic options
  • Section 4 : Lookup functional 3 Lectures 00:24:29

    • Lecture 1 :
    • Vlookup in Excel
    • Lecture 2 :
    • Hlookup in Excel
    • Lecture 3 :
    • Index and Match in Excel
  • Section 5 : Data validation in Excel 5 Lectures 00:18:21

    • Lecture 1 :
    • Data validation in Excel and creation of list in Excel
    • Lecture 2 :
    • Other data validation options
    • Lecture 3 :
    • Error messages in data validation
    • Lecture 4 :
    • Input messages in data validation
    • Lecture 5 :
    • Dynamic LOV creation using Data validation
  • Section 6 : Pivot tables in Excel 5 Lectures 00:20:36

    • Lecture 1 :
    • Pivot table Introduction
    • Lecture 2 :
    • Pivot table modification and formatting
    • Lecture 3 :
    • Styles and gathering data in Pivot table
    • Lecture 4 :
    • Pivot chart
    • Lecture 5 :
    • Filter in pivot table and Slicer tool in pivot
  • Section 7 : Power Pivot 6 Lectures 00:20:37

    • Lecture 1 :
    • Powerpivot Introduction
    • Lecture 2 :
    • Activation of power pivot
    • Lecture 3 :
    • Customising data model in power pivot
    • Lecture 4 :
    • Creating power pivot
    • Lecture 5 :
    • Power pivot calculated fields
    • Lecture 6 :
    • Power pivot KPI
  • Section 8 : Formula Auditing 2 Lectures 00:07:04

    • Lecture 1 :
    • Tracing in Formula Auditing
    • Lecture 2 :
    • Watch window and show formula
  • Section 9 : Macro in Excel 5 Lectures 00:17:30

    • Lecture 1 :
    • Introduction of Macro
    • Lecture 2 :
    • Creating your first Macro
    • Lecture 3 :
    • Editing and saving Macro
    • Lecture 4 :
    • Running a Macro using Form
    • Lecture 5 :
    • Macro Mini-Project - Send Weekly report
  • Section 10 : VBA in Excel 14 Lectures 01:21:26

    • Lecture 1 :
    • Introduction of VBA and VBA Editor
    • Lecture 2 :
    • Creation of VBA Module and Procedure
    • Lecture 3 :
    • your First VBA Code and variable
    • Lecture 4 :
    • If Condition in VBA
    • Lecture 5 :
    • Loops in VBA
    • Lecture 6 :
    • Project 2: Introduction of project
    • Lecture 7 :
    • Recording Macro for formatting data
    • Lecture 8 :
    • Integrating Macro with VBA code
    • Lecture 9 :
    • Project3: Autosum using VBA macro in multiple sheet
    • Lecture 10 :
    • Autosum in a single sheet
    • Lecture 11 :
    • Completion of Autosum functionality
    • Lecture 12 :
    • Project 4: Consolidation of all VBA Code
    • Lecture 13 :
    • Usage of all Old codes
    • Lecture 14 :
    • Implementation by consolidating all the codes
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Chandramouli Jayendran,

I am a software engineer and stock market analyst with 8+ years of experience. Author of 12+ courses with more than 60,000 students. I am very passionate about teaching office productivity, software programming, and stock market analysis. I have gained experience in a wide range of industries Investment banking, Retail, and Insurance industry. Worked with teaching several corporate on Office productivity and Programming.
View More...
  • vba-web-connect-ms-office-to-the-web

    VBA WEB - Connect MS Office to the ...

    By : Daniele Protti

    Lecture 223
  • excel-vba-from-beginner-to-expert

    Excel VBA from Beginner to Expert

    By : Daniele Protti

    Lecture 66
  • mastering-office-365

    Mastering Office 365

    By : Chip Reaves

    Lecture 70
  • excel-tips-and-tricks

    Excel tips and Tricks

    By : Muhammad Ali Yasin

    Lecture 16
  • microsoft-powerpoint-2016-self-publishing-ebook-book-covers

    Microsoft PowerPoint 2016 Self-publ...

    By : Brian Jackson

    Lecture 34
  • powerpoint-2013-2016-beginner-to-advanced-with-animation

    PowerPoint 2013/2016 Beginner to Ad...

    By : Brian Jackson

    Lecture 114
Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password Request
Enter your email address and we'll send you a link to reset your password.