Get the
Basics Right in
Microsoft Excel
Excel Course to get you Started
Learn the basics of Microsoft Excel – One of the most popular Data Analytics tools to help you visualize and gain insights from your data.
FLAT 20% ON THE COURSE FREE
It pays to have friends!
12 Hours
Course Duration
Introductory
For beginners
Course Delivery
Classroom or Online
Familiar with the Basics? We have more for you
What Will You Learn in this Course
Data Formatting
Get a better View of your Data
Formula and Functions
Buidling Blocks to work with Numerical Data
Excel Pivots
Powerful utility to Calculate, Summarize, and Analyze Data
Data Visualization
Done using Charts and Graphs
Before You Start
Prerequisites
- No prerequisites
- This course is for beginners
Course Format
- 12 Hr Course contains assignments on due dates but you can progress through the course at your own speed.
Course Overview
Target Audience – The target audience for this course are those who have never used Excel before or those who have elementary knowledge in Excel.
Agenda of the Course – To make you a functional user of Excel.
Topics Covered
1) Intro to Excel
- Introduction towards various basic tools and tabs.
- Formatting sheet & creating links between sheet
- Usage of Filters and Sorting in Excel.
2) Functions
- SUMIF, SUMIFS, SUMPRODUCT, VLOOKUP, HLOOKUP
- COUNTIF, COUNTIFS, SUM, AVERAGE,COUNT, MAX, MIN
- Use of Relative and Absolute references
3)Working with If Conditions
- Usage of the “IF” Conditions
- “IF” Conditions for Conditional formatting (Basic Level)
4) Pivots and Charts Explained
- Creating Pivots
- Charts and Graphs with Data
5) Excel Tips and Tricks
- Some tips that will not only make your simple but also help you to be more productive.
Know your Trainer
With nearly a decade of experience in this industry and training over 2000+ working professionals and delivering 100+ Corporate training – Ravi Saini is the founder of TechnoExcel. He’s been working on Microsoft Excel since a really long time as a user, a Developer, and a Trainer.
About TechnoExcel – Today the most precious thing on the world is no more oil but data and here at TechnoExcel we try to leverage it and use it at its full potential. We offer Corporate/Personal hands-on training on Data Science, Advanced Excel , Power BI, VBA – Macros and MS – Access. Sourcing only the highest rated trainers from UrbanPro (India’s No 1 Education Platform) we make sure to deliver that ROI you expect and create long-term positive change in your professional journey.’
Have a Question?
Today the most precious thing on the world is no more oil but data and here at TechnoExcel we try to leverage it and use it at its full potential.
Connect with Us
Contact
TechnoExcel
connect@technoexcel.in
8801912200
Above Allahabad Bank,
Lal Bahadur Colony,
Trimulgherry, Hyderabad