Master Excel Basics Get in touch!

and Beyond
Saisantosh Technologies
510, 5th Flooor, Annaapurna
Data Visualization Block,Ameerpet,Hyderabad,500016
info@[Link]
Made Simple
[Link]

Efficient Data
+91-9553428515
Management

Real-World
Applications
Welcome
TO OUR INSTITUTE!

Boost Productivity
with Shortcuts

Certification for
Career Edge
Discover
What Our Institute
Interactive and
Copyright © 2024 Saisantosh technologies. Has to Offer!
Engaging Learning
All rights reserved.
 Our Mission & Values
Our mission at Saisantosh Technologies
is to provide expert Basic & Advanced
excel education, equipping individuals
"Education is not the
with the skills and strategies needed to
filling of a pail, but the succeed in trading and investing.
lighting of a fire." We are committed to excellence, integrity,
practical learning, and empowering
people with real-world stock market
knowledge for financial success.

About Us Why choose us?

Saisantosh Technologies is a leading
educational center focused on
Apply Expert Practical

Now
providing high-quality, industry- Instructors Training
relevant training programs.

The institute offers a supportive Limited seats available, apply now Comprehensive Student
environment, fostering personal at [Link] Curriculum Support
growth and professional success
across various fields.

Class Timing Open

OFFLINE CLASS TIME:
08:00AM To 10:00AM
10:30 AM To 12:30 PM
Enrollment
ONLINE CLASS TIME: for students of all backgrounds and
06:00AM To 08:00AM abilities. Come visit us to learn more!
08:30 PM To 10:30 PM
Recent Corporate Training’s
 Basic & Advanced Excel Syllabus

Introduction to Excel Basic Formulas and Functions

s
eIntroduction to formulas and
Overview of Excel interface gi
Understanding workbooks, lo functions
Arithmetic operations (addition,
worksheets, and cells
no subtraction, multiplication,
Navigating within a workbook
ch division)
Creating, opening, and saving e Using common functions (SUM,
workbooks T AVERAGE, MAX, MIN)
sh Writing basic formulas (cell
to references, operators)
Data Entry and Formattingn
sa Working with Ranges and Data
i
Sa
Entering data into cells
Editing and deleting data
Tables
Selecting and manipulating
Formatting text, numbers, ranges
and cells Copying, cutting, and pasting
Using cell styles and themes data
Using autofill and flash fill
Creating and formatting tables
Managing Worksheets
Charts and Graphs
and Workbooks

Inserting, deleting, and Creating basic charts (bar,

renaming worksheets s
column, line, pie)
e
Moving and copying
giFormatting and customizing
worksheets
lo charts
Grouping and ungrouping
no Adding titles, labels, and legends
worksheets Using recommended charts
Managing multiple workbooks ch
Te
sh Printing and Sharing
Sorting and Filtering Data o
nt
sa Page setup options (margins,
i
Sorting data in ascending orientation, scaling)
and descending orderSa
Filtering data by criteria
Printing worksheets and
workbooks
Using advanced filter options Sharing workbooks and
Using conditional formatting collaborating with others
Protecting worksheets and
workbooks
Introduction to Data Analysis
5. Logical Functions
Tools
IF, IFERROR, IFBLANK, etc.
Introduction to PivotTables AND, OR, NOT, etc.
Creating PivotTables from 6. Lookup and Reference Functions
data VLOOKUP, INDEX/MATCH, etc.
Filtering and summarizing data
e s HLOOKUP, LOOKUP, etc.
[Link] Functions
with PivotTables
Introduction to data analysis
g PMT, IPMT, PPMT, etc.
o 8. Information
tools (What-If Analysis, Goal ol XNPV, XIRR, etc.
Functions
Seek, Scenario Manager)
hn ISNUMBER, ISTEXT, ISBLANK, etc.

ec TYPE, [Link], etc.

9. Cube Functions (for PowerPivot and
Formulas and Functions T Power BI)
sh
1. Arithmetic and Trigonometric Functions
CUBEVALUE, CUBERANKEDMEMBER,

t
SUM, PRODUCT, QUOTIENT, etc. o etc.
SIN, COS, TAN, etc.
2. Statistical Functions a n
s etc. Data Analysis Techniques
i
AVERAGE, MEDIAN, MODE,
STDEV, VAR, CORREL,
3. Text Functions
Saetc. Advanced sorting and filtering
LEN, LOWER, UPPER, etc. techniques
CONCATENATE, TEXTJOIN, etc. Subtotal function for data analysis
4. Date and Time Functions Data validation and drop-down lists
TODAY, NOW, DATE, etc. Conditional formatting with
HOUR, MINUTE, SECOND, etc. formulas
Advanced Data Tables and Advanced PivotTables
What-If Analysis and PivotCharts

Introduction to Data Tables Grouping and ungrouping

Creating one-variable and two-
es
data in PivotTables
variable Data Tables
giCalculated fields and items
in PivotTables
Using Goal Seek for scenario
lo Slicers and Timelines for
analysis
no interactive analysis
Scenario Manager for managing
multiple scenarios ch Creating PivotCharts from

Te PivotTables

sh Data Cleaning and

Advanced Charting and o
Graphs nt Transformation
sa Text-to-columns for data
i
Dynamic charts with named
Sa
splitting
ranges
Removing duplicates and
Customizing chart axes and
managing errors
labels
Using Flash Fill for data
Creating combination charts
cleaning
Trendlines and forecasting in
Introduction to Power Query
charts
for data transformation
 Collaboration and Data Advanced Data Analysis
Protection Techniques
Sharing workbooks and Advanced Filtering:
managing changes Advanced Filter
Tracking changes and
e s Dynamic filtering with formulas
comments
gi
Protecting worksheets and Statistical
o Functions:
workbooks with passwords ol AVERAGEIFS, COUNTIFS, SUMIFS
Managing external data
hn Statistical analysis functions:
connections
ec STDEV.P, VAR.P, etc.

Dynamic Array Functions T

sh Database Functions:
Sort
to DSUM, DCOUNT, DMAX, DMIN
Filter
an Using D functions with criteria
Unique
is
Sa
Xlookup
Working with Large Data Sets:
Xmatch
Wrapcols Excel Tables and structured
Wraprows references
Textsplit Data Model and Power Pivot for
larger datasets
Advanced PivotTable Advanced Charting and
Techniques Visualization

Calculated Fields and Items Sparklines and Data Bars

Grouping and Sorting Options Advanced Chart Types:
Slicers and Timelines: es
Waterfall charts
Advanced filtering techniques giPareto charts
Connecting multiple lo Heatmaps
PivotTables with slicers
no Dynamic Charts:
Using dynamic ranges and
PivotTable Options:
ch formulas
Custom layouts and designs
Conditional formatting within Te Chart animations and interactivity
PivotTables
sh
to Review and Practice
an
is Review of key concepts and
Sa functions
Hands-on practice exercises and
projects
Troubleshooting common issues
Tips and shortcuts for efficient
Excel usage
510,5th Floor, Annapurna Block, Ameerpet,500016
info@[Link]

+91-9553428515