Excel VBA in Depth Level 1 - Weekend Online 24 Hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Topics will be covered• VBA IDE o Project Explorer o Property Window o Script Window o Immediate Window o Locals Window o Watchs Window o Object Browser... Read More

Excel VBA in Depth Level 1 - Weekday Online 24 Hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Topics will be covered• VBA IDE o Project Explorer o Property Window o Script Window o Immediate Window o Locals Window o Watchs Window o Object Browser... Read More

Excel VBA in Depth Level 2 - Weekend Online 24 Hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Topics will be covered• Error Handling o Types of errors o Trap the errors o Error Handler o On Error Resume Next o On Error Goto Label, Line Number o... Read More

Excel VBA in Depth Level 2 - Weekday Online 24 Hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Topics will be covered• Error Handling o Types of errors o Trap the errors o Error Handler o On Error Resume Next o On Error Goto Label, Line Number o... Read More

Corporate Training - Advanced Excel

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

This Advanced Microsoft Excel training class is designed for Trainees to gain the skills necessary to work with advance formulae and functions. Trainees... Read More

Basic Excel Training - Weekend 16 hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Session 01 Getting Started • Starting Excel• Understanding the Display Screen• Exploring the Office Menu• Opening a Workbook• Managing Open Workbooks•... Read More

Basic Excel Training - Weekday 16 hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Session 01 Getting Started • Starting Excel• Understanding the Display Screen• Exploring the Office Menu• Opening a Workbook• Managing Open Workbooks•... Read More

Advanced Excel in Depth Level 1 - Weekend Online (Formulae & Functions) 30 Hours

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

• References o Relative references o Mixed references o Absolute references• Logical functions o IF, Nested IF o AND, OR, NOT o IF with AND, OR, NOT• Statistical... Read More

Advanced Excel in Depth Level 2 - Weekend Online (Other Excel Functionalities)

By Umasankar NatarajanMicrosoft Excel TrainingBannerghatta Main Road, Bangalore

Topics will be covered• Filter o AutoFilter o Text Filter with Condition o Filter by Color o Advanced Filter• Data Validation o Whole Number, Decimal Number,... Read More

SQL in Depth Level 1 Weekend - 24 Hours

By Umasankar NatarajanSQL ProgrammingBannerghatta Main Road, Bangalore

ANSI SQL Concepts• Writing SQL from scratch• Writing queries for realtime data• SQL Commands DDL, DML, DQL, TCL, DCL• Writing query to create, rename,... Read More

SQL in Depth Level 1 Weekday - 24 Hours

By Umasankar NatarajanSQL ProgrammingBannerghatta Main Road, Bangalore

ANSI SQL Concepts• Writing SQL from scratch• Writing queries for realtime data• SQL Commands DDL, DML, DQL, TCL, DCL• Writing query to create, rename,... Read More

SQL in Depth Level 2 Weekend - 24 Hours

By Umasankar NatarajanSQL ProgrammingBannerghatta Main Road, Bangalore

About the Course• Sub Queries (Step by step to create subqueries) • Normalization • Entity-relationship • One to One relationship • One to Many relationship •... Read More

SQL in Depth Level 2 Weekday - 24 Hours

By Umasankar NatarajanSQL ProgrammingBannerghatta Main Road, Bangalore

About the Course• Sub Queries (Step by step to create subqueries) • Normalization • Entity-relationship • One to One relationship • One to Many relationship •... Read More

Python programming in depth Level 1 (Weekday - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics will be covered in depth with step by step.Introduction• What is Python?• Why do we learn Python?• Applications of PythonIDEs • IDLE• Pycharm•... Read More

Python programming in depth Level 1 (Weekend - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics will be covered in depth with step by step.Introduction• What is Python?• Why do we learn Python?• Applications of PythonIDEs • IDLE• Pycharm•... Read More

Python programming in depth Level 2 (Modules and Packages) (Weekday - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics will be covered in depth with step by step.Modules• Create module• Use module• Variables in module• Naming module• Renaming moduleLoad module... Read More

Python programming in depth Level 2 (Modules and Packages) (Weekend - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics will be covered in depth with step by step.Modules• Create module• Use module• Variables in module• Naming module• Renaming moduleLoad module... Read More

Python programming in depth Level 3 (OOPs) (Weekend - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics (Object oriented programming) will be covered in depth.Classes and Objects• Class definition with example• Object definition with example•... Read More

Python programming in depth Level 3 (OOPs) (Weekday - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics (Object oriented programming) will be covered in depth.Classes and Objects• Class definition with example• Object definition with example•... Read More

Python programming in depth Level 4 (Data) (Weekend - Online)

By Umasankar NatarajanPython TrainingBannerghatta Main Road, Bangalore

Below topics will be covered in depth.Web scraping (Data extraction)• Inspect Data Source• Scrape HTML Content From a Page• Parse HTML Code With Beautiful... Read More