This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
What you'll learn?
- Macro and VBA for automation
- Basic analytics
- Data Validation, Pivot table, Vlookup
Course Overview
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
-
Basics in Excel
-
Graphical representation in Excel
-
Analytics in Excel.
-
Data validation, Advanced Pivot tables, Advanced lookup operations.
-
Macro used to send daily report.
-
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.
Pre-requisites
- Basic computer knowledge
Target Audience
- College students and office goers
- Newbies willing to learn excel
Curriculum 59 Lectures 05:07:50
Section 1 : Introduction
- 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
- 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
- Lecture 1 :
- Charts - An Introduction
- Lecture 2 :
- Conditional formatting and Sparklines
- Lecture 3 :
- Pivot table
- Lecture 4 :
- Other graphic options
Section 4 : Lookup functional
- Lecture 1 :
- Vlookup in Excel
- Lecture 2 :
- Hlookup in Excel
- Lecture 3 :
- Index and Match in Excel
Section 5 : Data validation in Excel
- 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
- 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
- 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
- Lecture 1 :
- Tracing in Formula Auditing
- Lecture 2 :
- Watch window and show formula
Section 9 : Macro in Excel
- 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
- 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
Our learners work at
Frequently Asked Questions
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.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 certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.Is there any free trial?
Currently, we do not offer any free trial.Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
278968 Course Views
6 Courses