info@rareminds.in

+91 85537 89574

Colleges
Recruitment Program
College's Recruitment Program

Consulting, Recruitment & Training

Recruitment
Recruitment Program
College's Talent Programs

Consulting, Recruitment & Training

Colleges
Corporate Program
College's Consulting Program

Talent Acquisition. Talent Development . Talent Management

previous arrow
next arrow

Microsoft Excel Training Program

Personalized Training
Learn the Microsoft Excel skills you need with our unique online instructor-led live training. Our highly personalized Excel workshops are designed to equip you with the right set of skills you need to succeed in your organization or industry. We provide domain-specific training to make sure that you get to learn only what is relevant to you. We provide specialized classes for Corporate users, MBAs, Mechanical Engineers, Electrical Engineers, Civil Engineers, Architects, among others. Kindly contact us to know the details of our specialized classes. In case there is a specific skill or a tool you want to learn during the program, you can request for it to be taught. You can also request
for time slots as per your convenience.

From Basic to Advanced
Our courses have been segregated into three proficiency levels: Basic, Intermediate and Advanced. Based on your current level of expertise, you can choose to start where you feel most comfortable, and gradually progress to master spreadsheets with confidence. Familiarize yourself with the fundamental Excel tools such as formulas and functions, charts, sorting and filtering, report creation, etc., or refine your knowledge by learning advanced capabilities such as pivot tables, data linking and consolidation, lookup functions, macros, Power BI and Visual Basic programming.

Learn from Experts
All courses are delivered by veteran professionals with decades of industry experience. They have a keen awareness of current industry trends and in-demand skills.

Get Certified
On successful completion of your course, you will earn a Certificate which you can add to your CV and share with prospective employers and your professional network. Certified Excel skills can increase the likelihood of promotions and lift earnings by 12% on average compared to non-certified users.

Excel Programs

Excel Basic


This program is designed for those who are new to Excel. Learn to navigate the user interface, pick up useful shortcuts, work with workbook, sheets, ribbons and get familiar with basic formatting tools and functions. Learn through demonstrations as well as hands-on activities based on real-world applications.


Who should do this course?


This course is designed for people who are either new to Excel, or want to refresh their knowledge of the fundamentals. Prerequisites No prior knowledge or experience of MS Excel is required.

Course Units

Ribbons , Workbooks, Worksheets
•Format Cells, Tables
•Keyboard shortcuts
•Numbers to Text
•Custom Edit List, AutoFill
•Name Box, Set Name Ranges
•Special Paste Functions, transpose
•Excel Status Bar
•Basic (Sum, SUMIFS)
•Data Validation :
•Input & Error Message
•Reject Invalid Dates |
•Budget Limit |
•Product Codes |
•Drop-down List |
•Dependent Drop-down Lists |
•Kg to lbs – Assignment|
•Prevent Duplicate Entries Assignment
•Protect Books

Excel Intermediate
Boost your productivity with essential lookup and reference functions and expand your knowledge of statistical functions. Learn to manipulate text as well as date and time. Perform data analysis with sort, filter, conditional formatting and create visualizations with charts and pivot tables.

Who should do this course?

This course is for active users of Excel who are looking to build on their elementary skills and want to enhance their efficiency, or expand their use cases.

Prerequisites
Participants must have completed the Excel Basic program or have equivalent skills.

Course Units

Functions & Formulas
Text (Join Strings | Left | Right | Mid | Len )
Number ( ISNUMBER, VALUE)
Date & Time (Year, Month, Day | Date Function | Current Date & Time | Hour,
Minute, Second | Time Function)
Logical Operations (IF, AND, OR and NOT)
Cell, Worksheet References (Relative Reference | Absolute Reference | Mixed
Reference) , Indirect Function
Lookup & Reference Functions (VLOOKUP, HLOOKUP, MATCH, INDEX and
CHOOSE)
Statistical Functions (Average | Averageif | Median | Mode | Standard
Deviation | Min | Max | Large | Small)
Sort
Filter
Conditional Formatting (Manage Rules , Data Bars, Color Scales, Icon Sets, Find
Duplicates, Shade Alternate Rows, Compare Two Lists, Conflicting Rules,
Checklist, Heat Map)
Pivot Tables , Multi Level & Slicers
Charts & Pivot Charts

Excel Advanced

This course will teach you how to use Excel to masterfully perform data
analysis. Learn to clean and prepare data for analysis, use data analysis tools,
work with pivot tables and charts to summarize, explore and visualize data,
and build professional dashboards.
Who should do this course?
This course is for those users who are looking to use Excel professionally
and/or interested in data analytics or data science and use to improve business
decision making.
Prerequisites
Participants must have completed the Excel Intermediate program or have
equivalent skills.

Units

• Data Preparation
• Data Analysis
• Design Principles
• Pivot Dashboards
• Pivot tables for Analysis
• Pivot Charts
• Slicers
• Updating pivot-based Dashboards
• Formula Dashboards
• Formulas for Analysis
• Form Controls
• Slicers for Formulas
• Updating Formula based dashboards
• Choosing Charts
• Heat Maps
• Maps

• Protecting Data

Excel Power BI

Power BI is an analytics tool that turns unstructured data into custom visuals which generate valuable actionable insights. It is a powerful business intelligence platform that can be used for data modeling. In this course you will
learn how to extract, transform and apply the query editor, manage relationships and model data and utilize Power BI to build reports, dashboards and visualizations.


Who should do this course?


This course is for those users who currently use Excel and build Dashboards but want to enhance their skills or are looking for an accessible Business Intelligence tool.


Prerequisites


Participants must have completed the Excel Intermediate program or have equivalent skills.

Units
 Accessing Data Types from Query
 Transforming Data in Query
 Data Model Relationships
 Transforming Data in PowerPivot
 Text Based Calculations
 Power View Chart Visualisations
 Power Maps

About the Instructor

The trainers in the program come with vast corporate experience. The trainers come in from different sectors of the industry and bring in their rich experience to share with us.