MS-Excel – (Basic to Advanced)

COURSE DESCRIPTION :

In this Microsoft excel online course, you’ll be taught about:

• Fundamentals of Excel
•  Text and Date Functions
• Excel Add-ins and basic configuration
• Camera, Translate, and Speak cells
• Excel Tips and Tricks
• Cell Reference and Custom Level Formatting
• Data Sort (horizontal and vertical)
• Data Filter and Advanced Filter
• Data Validation, Consolidate, Flash Fill
• Conditional Formatting
• IF and Nested IF functions
• Data Forecast, Goal Seek, Scenario Manager, Data Table, Solver
• Sum Functions, Subtotal
• VLOOKUP() Automation, HLOOKUP(), Index and Match functions
• View Freeze Panes, Macros
• Pivot Table, Chart, and Report Filtering
• Dynamic Trend Charts
• Pareto and Radar chart
• MIS dynamic dashboard using Pivot Tables, Insert Slicer and Timeline
• FAQs.

What Will You Learn From This Course?

• Basics to advance MS Excel
• Tips and tricks to save time
• Logical and conceptual usage of functions and formulas
• When to use what and why?
• MIS fundamentals
• Create their Dashboard in just 5 minutes
• Above all, the takeaway from this session will be self-confidence in using Excel.

Learning Outcome of the course:

• Can start using any function of excel
• Can begin understanding how the function and formula works
• How to use Excel effectively and logically
• Overcome all the repetitive activities
• Data analytics and presentation of data in pictorial form.

Course Details: 

• The batch starts on Sunday 9th Oct.
• Time: 7:30pm – 10:00pm (2.5 hrs everyday)
• Application: Zoom and Google Meet
• Resources / Support provided during & after Course Completion: MS Excel sheets for practice, Lifetime Mentorship 24/7, Pre and Post Assessment

Module-01:

File: Open, New, Save, Save As, Print

Home:  Clipboard, Font, Alignment, Number, Conditional Formatting, Cells, Editing

Insert: Pictures and shapes, Basic Charts, ScreenShots, Hyperlink, Table

View: Gridlines, Formula Bar, Headings, Ruler, Freeze Panes

Page Layout: Page Setup, Sheet Options

Module-02:

Others: Custom Level Formatting, Excel Tips & Tricks, Short-Cut Keys

Insert: Pictures and shapes, Basic Charts, ScreenShots, Hyperlink, Table

Module-03:

Formulas:  Auto Sum, Logical, Text, Date, Logical, Lookup & Reference Functions

Module-04:

Data: Sort & Filter, Advanced Filter, Flash Fill, Remove Duplicates, Data Validation, Consolidate, Forecast-What-if-Analysis, Goal Seek, Data Table, Solver, Forecast

Module-05:

Insert: Pivot Table, Table, Pivot Charts, Pivot Reports, Insert Fields, Insert Items

Module-06:

Data: Insert Slicer, Timeline, MIS Dashboard (Dynamic)

Review:  Spelling, Translate, Comments, Speak Cells, Macros, Introduction to ASAP Utilities

Manoj P Chakerwarti has 33 years of rich experience in software development, ERP implementation, and end-user training in ERP and MS Office. By Qualification, he has done M.Sc., M.Phil.(Applied Mathematics), MBA, DCS, PGDBA, PGEXIM, PMP (40PDUs). For the last two years, he has been fully involved in Corporate Training and has a good repo on LinkedIn with 12K+ followers in just one year. He is comfortable teaching in English, Hindi, and Gujarati language. 

In the last year, he has trained 3000+ students, 12 Corporate clients, and 4 NGOs. During training, he includes pre and post-assessment tests so that students can measure the difference in their knowledge while using easy language to make all the students understand logically and conceptually.

• We are India’s fastest-growing EdTech Startup.
• Our trainers can teach you in your local language.
• We have a network of India’s best skill trainers.
• Our courses are mostly live and online.
• We are students’ most trusted brand.
• 100% Satisfaction Guarantee, else full free refund to you