TRANSFORMING

FROM FRESHERS
TO IT WORKING
PROFESSIONAL
SOFTWARE
TRAINING WITH
YESS INFOTECH

Mr. Sandip Bhutare

10+ years Accenture experience
Author, Motivational speaker, Founder of Yess
InfoTech

The Largest Training

and Placement LEARN
Company NOW!
Classroom and
Online Training
Get 10% OFF

10000+ Happy Students

We have placed many students in software
companies and supported thousands of
students since 2017

Offered Trainings Our Expertise

Devops Industry Expected Latest Curriculum
Data Science 100% Practical Oriented training
Data Analytics Live Projects
Software Testing Industry Working Trainers
Digital Marketing Small Batch Size
Python Web Development Assured Placement Calls
Full Stack Web Development
Spoken English for Beginners www.yessinfotech.com
Multi Language Web Development
 100%
placement
assistance
Data Analytics

Introduction to Python Built-in Python Functions Debugging with the

User-defined Python debugger
Introduction of Python function Testing with unit Test
Installation of python Defining function module
Feature of python Calling Function Database connectivity
History of python Parameters and
Installing Python and code arguments Basic Excel Course
editor IDE Positional Arguments Syllabus Introduction to
Introduction to the Default Arguments Computers
anaconda distribution Keyword Arguments Font formatting
platform Arbitrary Arguments Number formatting
Introduction to Jupytrt Docstrings Table formatting
Notebook and how to work Recursive Functions Conditional formatting
on it Lamda Functions Hide/ Unhide
Introduction to google Sort/filter
collaboratory Object Oriented Paste special
Running python programs Programming Find and select
using terminal Objects Insert
Variables Classes Illustrations
Data type Creating empty class Charts
Working on Integers, Creating class and Tex
Floats, Booleans in Python defining attributes Basic Functions
Playing with Strings in Class methods and Sum/Average/Count/Max/
Python attributes Min
Working on Lists Constructors Basic
Working on Sets Generators Text/date/time/lookup/inf
Working on Dictionary Decorators ormation functions
Operators Instance and class Name manager
Arithmetic Operator variables Formula Auditing
Relational operators Inheritance Data
Assignment operators Polymorphism Import from web
Logical operators File Handling Import from text
Special operators Reading and writing files Text to columns
Bitwise Operators Opening and closing files Remove duplicates
Control Structures Deleting Testing and Grouping and ungrouping
Conditional Statements debugging Files Review
Expressions and Errors and Exception Proofing
Statements Handling Comments
Indentations Modules and Packages Protection
Writing Comments Importing Modules Views
terations and Iterables Creating and importing Typesofviews
Loops packages Zoom
Namespaces Windows
Python Functions Testing and Debugging Developer
Introduction to Python Debugging with print Enable developer
function statement Using checkbox/option
Types of Python Functions buttons
 100%
placement
assistance
Data Analytics

Excel 2007 & 2010,2013, LOOKUP Functions–Advance Advanced Filters

MATCH with VLOOKUP Extracting Records with
2016 Quick Overview
Functions Advanced Filter
Difference between
INDEX& MATCH Functions Using Formula sin Criteria
Excel2003, 2007 and 2010, OFFSET/INDIRECT functions
2013, 2016 Advanced Sorting
Logical Functions–Advance
Use of Excel, its boundaries Sorting by Top to
If Loop and Nested IF Loop
& features Functions Bottom/Left to Right
Basic Formula Using IF/IS ERROR Functions Creating/Deleting Custom
Formulae that Add/ Chart Data Techniques List
Subtract/ Multiply/ Divide The Chart Wizard Sort by using Custom List
BODMAS / Formula Error Chart Types Hyper/Data Linking
Checking Adding Title/Legends/ Hyper linking data,within
The Sum Function Labels sheet/workbook
Absolute Referencing Printing Charts Linking&Updating links
Problems with Absolute Adding Data to a Chart between
/Relative Cell Referencing Formatting/Renaming/Deleti workbooks&application
Creating Absolute /Mixed ng Data Series Math & Trigonometry
References Changing the Order of Data Functions
LOOKUP Functions Series Using SUM PRODUCT
The VLOOKUP/ HLOOKUP Functions
Functions Using
Date / Time Functions
Pivot Tables FLOOR/CEILING/MROUND/
Using The Today
Creating,Formatting Simple MOD/QUOTIENT Functions
Now& Date Functions
Pivot Tables Summarizing Data
Using The Dated if/ Network
Page Field in a Pivot Table Creating Subtotals/Nested
days/Eomonth Functions
Formatting a Pivot Table Subtotals
Using The Week num
Creating/ Modifying a Pivot SUBTOTALS Formula
Functions
Chart Outlining
Using The Edate/Network
Logical Functions Creating/Working with an
days.Intl/Weekdays.Intl
IFs and Nested IF Functions Automatic/Manual Outline
Functions
Using AND/OR/ NOT Grouping/Un grouping
Text Functions Using
Functions Consolidation
The Mid/Search/Left/Right
Statistical Functions Consolidating Data with
Functions
Using The SUM IF / COUNT IF Identical/Different Layout
Using The
Functions Using Auditing Tools
Trim/Clean/Upper/Lower
Using The Displaying/Removing
Functions
AVERAGE/COUNT/LARGER/S Dependent&Precedent
Using The Substitute/Text
MALLER Functions Arrows
Functions
Pivot Tables–Advance Evaluate Formula–
Using The
Adding new calculated StepIN/StepOut
Trim/Clean/Proper/Dollar
Fields/Items Custom Views
Function
Changing the Summary Creating Custom Views
Validations
Function Displaying Custom Views
Input Messages/Error
Consolidate Pivot table Deleting Custom Views
Alerts/Drop-Down Lists
Conditional Formatting
 100%
placement
assistance
Data Analytics
Sharing and Protecting SQRT() Query,Power Pivot,Power View)
Workbooks MOD() Flow of Working PowerBI Desktop
Sharing Workbooks&Tracking SQL CLAUSE PowerBI Report Server,PowerBI
Changes Service,PowerBI Mobile Flowof
WHERE
Protecting Working PowerBI/PowerBI
GROUP BY
Architecture
sheets/workbooks/Files ORDER BY A Brief History of PowerBI
Importing & Exporting Data HAVING Data Transformation,Benefits of
Importing Data from Database/ SUB QUERIS Data Transformation
TextFiles/Web JOINS Shape or Transform Data using
Exporting Data inner join Power Query
Changing External Data Range outer join Power Query
left join Overview of Power Query/Query
SQL right join Editor, Query Editor User Interface
Introduction of SQL The

SQL Statements TABLEAU Ribbon(Home,Transform, Add

Column,View Tabs)
DDL Understanding Data
The Queries Pane,The Data
What is data Where to find data
DML Foundations for building Data
View/Results Pane,The Query
DQL Settings Pane,Formula Bar
Visualizations
Saving the Work
DCL Creating Your First visualization
Datatypes,Changing the Data type
SQL CONSTRINTS Getting started with Tableau
of a Column Filter in Power Query
Software Using Data file formats
UNIQUE Auto Filter/Basic Filtering
Connecting your Data to Tableau
PRIMARY KEY Creating basic charts(line,bar
Filter a Column using Text Filters
Filter a Column using Number
NULL charts,Tree maps) Using the Show
Filters
NOT NULL me panel
Filter a Column using Date Filters
Tableau Calculations
CHECK Filter Multiple Columns
Overview of SUM, AVR, and
DEFAULT Aggregate features
Remove Columns/Remove Other
FOREIGN KEY Columns
Creating custom calculations and
Name/Rename a Column
SQL OPERTORS fields
Reorder Columns or Sort Columns
Applying new data calculations to
AND Add Column/Custom Column Split
your visualization
OR Formatting
Columns
LIKE Merge Columns
Visualizations
PIVOT,UNPIVOT Columns
IN Formatting Tools and Menus
Transpose Columns
BETWEEN Formatting specific parts of the
Header Row or Use First Row as
view
IS Editing and Formatting Axes
Headers
SQL FUNCTIONS Keep Top Rows,Keep Bottom Rows
Keep
MIN() Manipulating Data in Tableau
Range of Rows
MAX() Advanced Visualization Tools
Keep Duplicates,Keep Errors
Creating Dashboards & Stories
COUNT() Remove Top Rows, Remove Bottom
Distributing & Publishing Your
SUM() Visualization
Rows,Remove Alternative Rows
Remove Duplicates,Remove Blank
AVG()
Rows,Remove Errors
LENGTH() POWER BI Group Rows/Group By
REVERSE() Power BI Introduction
Data Visualization,Reporting
REPLACE() Visualizations
Business PowerBI Service
INSTR() Intelligence(BI),Traditional BI,Self- Creating Dashboards
SUBSTR() Serviced BI
TRIM() Cloud Based BI,On Premise BI
ROUND() Power BI Products
Power BI Desktop(Power
ABS()
 Lets Talk
about your
career

Job Placement Learn Coding Career Guide

Our Expert Placement
Provide free job call Provide 100% practical
Team and highly qualified
assistance to students oriented approach and
trainers put good efforts
like CV making, mock easy learning approach.
to shape students career
interview and interview Explanation is in Hindi
and help & understand
scheduling and English language
there every aspect.

About Our Company

We are the largest Software Training and Placement Institute in Pune, India. We serve students all over INDIA. We provide
all types of software trainings for freshers as well as working professionals in online and offline(classroom) modes at
Hadapsar, Pune. We provide Software Testing (Manual+Automation with Selenium Web-Driver, API, Cypress), Data Science
with ML, Data Analytics, Digital Marketing and Full stack Java , Full front end development trainings. We consult our
students for career opportunities and 100% placement assistances 1 year at free of cost.
Keep Learning. Keep Growing.

Follow us on
@yess_infotech YessInfoTechPvtltd YessInfoTech @InfotechYess
@yess_infotech_pune

90678 32489 Office Timing

Monday
Address : Office Number 101, Floor No 1, Manisha Blitz, Solapur - Pune Hwy,
near Shankar Math, near Magarpatta City, Hadapsar, Pune, Maharashtra
80807 47767 to Saturday
9AM to 6PM
411013
：
Phone 7038384365
Mailbox : [email protected]