Microsoft Excel : Beginner to Expert
Learn withStarville Training Academy
6 modules
English
Lifetime access
Master Excel from beginner to expert level
Overview
In this course, you will start as a beginner and gradually work your way up to becoming an expert in Microsoft Excel. We will cover everything you need to know to navigate through Excel efficiently and effectively. From basic functions like formatting cells, creating simple formulas, and sorting data, to more advanced techniques such as pivot tables, data analysis, and automation using macros - this course has got you covered. You will learn how to create professional-looking spreadsheets, manipulate data with ease, and present your findings in a clear and visually appealing manner. By the end of this course, you will be confident in your Excel skills and be able to handle any data-related task with ease. Whether you are a student looking to enhance your job prospects, a professional wanting to boost your productivity, or simply someone who wants to be more proficient in Excel, this course is perfect for you. Join us on this journey from beginner to expert, and unlock the full potential of Microsoft Excel.
Key Highlights
Comprehensive Excel training
From basics to advanced techniques
Hands-on projects and exercises
What you will learn
Master Data Entry and Formatting
Learn how to effectively enter and format data in Excel
Advanced Functions and Formulas
Explore powerful functions and formulas to analyze data efficiently
Pivot Tables and Charts
Create dynamic pivot tables and charts to visualize data trends
Automate Tasks with Macros
Automate repetitive tasks using Visual Basic for Applications (VBA) macros
Modules
Introduction to Microsoft Excel
11 attachments • 52.55 mins
Introduction of Microsoft Excel :
Introduction of MS Excel
Introduction (Part-1)
Introduction (Part-2)
Introduction (Part-3)
Basic Worksheet Modelling :
Basic Worksheet Modeling
Range Function in MS Excel :
Range Function (Part 1)
Range Function (Part 2)
Range Function in Excel
6 pages
Essential Excel Tools
35 attachments • 6 hrs
MS Excel Basic Formatting, Formula and Functions :
Formatting options
Conditional Formatting
11 pages
Using formulas and functions
Vlook Up
11 pages
V-LOOK UP (part 1)
V-LOOK UP (part 2)
HLook-up
Index and Match Function
Text Function
Text Function
7 pages
Time Function
Time Function
10 pages
Date Function
7 pages
Date Function (Part 1)
Date Function (Part 2)
Date Function (Part 3)
Date Function (Part 4)
Date Function (Part 5)
MS Excel Financial Modelling and Business Accounting Functions :
NPV (Part 1)
XNPV (Part 2)
IRR Function
6 pages
IRR (PART 1)
IRR (PART 2)
MIRR (PART 1)
MIRR (PART 2)
XIRR Function
6 pages
XIRR (PART 1)
IF Function
10 pages
IF FUNCTION
IFERROR Function
2 pages
IFERROR Function
Data Sorting (Part 1) _Introduction
Data Sorting (Part 2)
Manipulating Data
26 attachments • 3 hrs
Data Analysis, Presentation and Statistical Functions
Paste Command
Paste Special Command
12 pages
COUNTIF Function
COUNTA Function
COUNT Function
COUNT BLANK Function
AVERAGEIF Function
AVERAGEIF
2 pages
AVERAGEIFS Function
AVERAGEIFS
6 pages
MAXIFS Function
MAXIIF Function
1 page
MINIFS Function
MINIIF Function
2 pages
SUMIF Function
SUMIF FUNCTION
3 pages
SUMIFS Function
SUMIFS FUNCTION
5 pages
Using tables and charts
Data Validation (Part 1)
Data Validation (Part 2)
Column Chart
Pie Chart
Descriptive Statistics
Descriptive Statistics in Excel
5 pages
Advanced Excel Techniques
36 attachments • 5 hrs
Data Models, Pivot Tables and Data Analysis
Introduction of Data Models
Data Model in Excel
Pivot Introduction
Pivot Tables
Pivot Table
5 pages
Advanced formulas and functions
Import Data
Export Data
Summarizing Data
Consolidating Data (Part 1)
Consolidating Data (Part 2)
Consolidating Data in Excel
Subtotal (Part 1)
Subtotal (Part 2)
Subtotal in Excel
12 pages
Formulas (Part 1)
Formulas (Part 2)
Formulas (Part 3)
MS Excel Business Analytics : Data Optimization and Solver -
Get Data and Transform
Optimization
Solver to Shedule Your Work Force
Solver to Schedule Workforce
3 pages
Using Solver to Solve Transporation Problem (Part-1)
Using Solver to Solve Transporation Problem (Part-2)
Solver to Solve Transportation problems
6 pages
Solver for Budgeting
SOLVER
10 pages
Using Solver for Financial Planning
Solver for Financial Budgeting
3 pages
Using Solver to Rate Sports Team
Solver to rate Sports Team
20 pages
Using Solver to Find Optimal Warehouse Location
Travelling Salesman Problem
Travelling Salesperson Problem
4 pages
MS Excel Data Sourcing Online : Its Analysis and Presentation
13 attachments • 2 hrs
MS Excel Data Types Linked through Online Sources
Trendlines
Geography Data
Stocks Data
Geography and Stock data types
4 pages
Get Data and Transform
Get and Transform
4 pages
Exponential Growth Formula
Power Curve
Correlation Matrix (Part 1)
Correlation Matrix (Part 2)
3D Maps (Part 1)
3D Maps (Part 2)
Becoming an Excel Statistical Expert
17 attachments • 3 hrs
MS Excel Statistical Functions :
Multiple Regression (Part 1)
Multiple Regression (Part 2)
Non-linear Regression
ANOVA Business Analytics
Anova Introduction
One-Way Anova
Two-Way Anova (Part 1)
Two-Way Anova (Part 2)
Time Series and Moving Avg (Part 1)
Time Series and Moving Avg (Part 2)
Ratio to Moving Avg Forcast Method
Introduction to Probability
Introduction to Random Variable
Page Layout
Exponential Distribution
Z-Scores
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
₹ 4000.00
₹12000
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
