PrabasTech

  • prabas@prabastech.com
Youtube Facebook-f Twitter

Do you want to

Step up from your CAREER JOB GOAL

then start learning today

A Basic Excel Training for Student / Aged Person

Microsoft Excel

Basics
₨5500
₨ 3,999
  • Excel Introduction & Backstage View
  • Saving & Printing Workbooks
  • Navigating Excel, Walk-through
  • Excel Shortcuts
  • Creating and Manipulating Data
  • Managing Worksheets & Workbooks
  • Data Validation - Create, Enhance
  • Modify, Edit, Enter Cell Content
  • Layout, Views, Review
  • Formatting Data, Numbers, Text & Table
  • Understanding Functions
  • Referencing Functions
  • Name Ranges and Dates
  • VLOOKUP, HLOOKUP, XLOOKUP
  • Subtotals - Create, Remove, Modify
  • Nested Functions
  • IF Condition
  • SUMIF, COUNTIF, IFs, SUMIFs, COUNTIFs
  • Text, Data & Time Functions
  • Paste Special & Format Painter
  • Charts, Formatting, Modifying
  • Conditional Formatting
  • Adding Graphics to Spreadsheets
  • Outlining, Sorting, and Filtering
JOIN & LEARN
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Video recording for all classes
Popular

  • Introduction of Excel​

    All Excel Tabas - File, Home, Insert, Page Layout, Formulas, Data, Review, View, Developer, Help

  • Customize Interface

    Quick Access Toolbar, Toolbar Customization

  • Introduction to Backstage

    Document Properties, Titles/Tags/Categories, Related Dates/People, Document Inspector, Compatibility Checker

  • Creating and Manipulating Data

    Flash Fill, Creating Custom Lists

  • Managing Worksheets

    Copying/Moving worksheets to different excel book

  • Adding, Editing Graphics to Spreadsheets

    Inserting / Editing Pictures, Shapes & SmartArt

  • Sorting, Grouping and Filtering

    Grouping, Ungrouping, Sorting Data, Sorting Levels, Advanced Filtering, Shortcut to apply / remove filtering, Custom Sort, Sorting Row wise / Column wise

  • Formatting Background

    Watermarks in Excel, Inserting image as a background image

  • PivotTables And PivotCharts

    PivotTables, Creating PivotTables, PivotTable Layout, Updating/Modifying Data, Filtering PivotTables

  • Date / Time

    Date Formatting, Time formatting, Custom Formats

  • Formatting Numbers

    Modifying Cell Formats, Format Painter, Formatting Multiple Cells, Numerical Cell Values

  • Formatting Tables

    Formatting Table (Manual / Styles)

  • Behavior of formula

    Relative Cell References, Absolute Cell References, Effective ways of Copying Formulas, 10 types of Sum function, Formula Evaluation

  • Conditional Logic

    IF AND, IF OR, Sum IF, Count IF, Sum IFS, Count IFS

  • Nested Formulas

    Using multiple functions to get a decried output, Eg. multiple IF functions along with other functions

  • Text Formulas

    Convert Formula, Extraction Formulas (left, right, mid), Manual Concatenations, Text Formula

  • Name Reference in Formula

    Naming Ranges, Adding Named Ranges

  • Paste Special

    Quick Multiplication, Addition, Substitute along with 10 tips to effectively use Past Special in your day to day jobs

  • Charts

    Multiple type of charts, instant Chart with F9, Combination Chart, Add Secondary Y/Value Axis, Chart Styles, modify, edit, extend, change its type and more

  • Conditional Formatting

    Conditional formatting with formulas, Issue handling in conditional formatting, How to copy conditional formatting, Apply multiple conditional formatting to a cell / range

  • Excel Page Setup

    Page Setup, Custom header and footer

  • Protecting Data

    Locking Cells, Protect Workbook, Hiding Cells / formula, Hiding Worksheets, Calculated Fields, Slicer, PivotCharts, Hide worksheet using VBA editor, Hide excel file

  • Excel Shortcuts

    Function Keys - F1 to F12, CTRL Keys, ALT Keys, CTRL + Shift, ALT + Shift combination shortcuts

A Complete Excel Training for Working Professionals

Microsoft Excel

Advanced
₨7000
₨ 5,999
  • All items included from the basic training
  • PivotTables & PivotCharts
  • Protecting Data
  • WhatIFAnalysis & Forecasting
  • Power Query - Get and Transform Data
  • Data Cleaning
  • Quick Analysis
  • Consolidate, Merge, Append Data
  • Basics of Macros with VB for Applications
  • Video recording
  • Office 365 Subscription
JOIN & LEARN
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Video recording for all classes
Popular

Microsoft 365 Free (if available)

  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Word

We recommend you to Join this Online Training

All topics covered in the Excel Online Package will be covered in Excel Offline Package too. But, considering the current situation, it is better for you to choose online based training sessions. 

Learn PowerQuery along with Excel

Excel & Power Query

Advanced
₨9000
₨ 7,999
  • All items from the Advanced Excel
  • Data Extract / Transform / Load - ETL
  • Import Data from Excel Tables
  • Import Data from Multiple Excel Files
  • Consolidate Millions of Rows
  • Merge / Append Data
  • Import CSV and Other Data Sources
  • Data Cleaning
  • Transferring Data to Usage Insights
  • Data Sorting / Filtering
  • Power Query Functions
  • Video recording
  • Office 365 Subscription
JOIN & LEARN
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Video recording for all classes
Popular

Microsoft 365 Free (if available)

  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Word

We recommend you to Join this Online Training

All topics covered in the Excel Online Package will be covered in Excel Offline Package too. But, considering the current situation, it is better for you to choose online based training sessions. 

Preparing a Static / HQ Presentation High Level Presentation Video Promo or Animation

then, this course is for you

Microsoft PowerPoint

Basic Online Training
₨5500
₨ 3,999
  • Chapter 01: Introduction
  • Chapter 02: Why should i learn PPT?
  • Chapter 03: PowerPoint Basics
  • 3.1 Application Walk-through
  • 3.2 Adding Slide, Shape, Picture
  • 3.3 Editing Slide, Shape, Picture
  • 3.4 Textbox / Placeholder
  • 3.5 Multiple Layout Design
  • 3.5 Saving, Exporting, Presenting
  • Chapter 04: Learn Animation Effects
  • 4.1 Types of Animation
  • 4.2 Adding, Editing Animation
  • 4.3 Animation Timing
  • 4.4 Custom Animation
  • Chapter 05: Add, Modify Transitions
  • Chapter 06: Table, Shape, Object
  • Chapter 07: SmartArt, Chart, Equation
JOIN & LEARN
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Popular

Microsoft 365 Free (if available)

  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Word

Want be become a PRO in PowerPoint

Microsoft PowerPoint

Advanced Training
₨7500
₨ 5,999
  • All Items in Basic PowerPoint Training
  • Chapter 01: Presentation Ideas
  • Chapter 02: Essential Knowledge
  • Chapter 03: Slide Design - Part 1
  • Chapter 04: Creating Templates
  • Chapter 05: Slide Design - Part 2
  • Chapter 06: Tables in PowerPoint
  • Chapter 07: Beautifying Presentations
  • Chapter 08: Slide Design - Part 3
  • Chapter 09: ZOOM & MORPH
  • Chapter 10: Presenting Large Data
  • Chapter 11: Vector Files in PowerPoint
  • Chapter 12: SWOT Analysis Template
  • Chapter 13: Unknown Features
  • Chapter 14: Tips for a Business PPT
  • Chapter 15: Use and Create Templates
  • Video Recording
  • Office 365 Subscription
JOIN & LEARN
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Popular

  • PowerPoint knowledge

    Increase your PowerPoint knowledge

  • Custom Layouts

    Learn to make custom layouts with placeholders on slide master slides

  • Efficiency

    Reduce the time you need to complete a high-quality presentation

  • Work Ideas

    Be able to brand and build templates for you, your company, or your clients

  • Animation & Transition

    Create a fully-animated and transition-filled business presentation

  • Proper Usage

    Minimize text quantity on presentations by using graphs and images

  • Enhanced Animation

    People who want to learn how to animate and build engaging presentations and templates

  • Video Making

    Entrepreneurs who want to create, sell, or promote with help of animated presentations and videos

  • Who need this course?

    Business people, teachers, students or designers wanting to create outstanding slides

Microsoft 365 Free (if available)

  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Word

Are you Interested in VBA Macros Excel Automations

Excel VBA for Advanced Users

Microsoft Excel VBA

Basic
₨7500
₨ 5,999
  • Basics of VB & VBA
  • Coding Principles
  • Coding/Saving/Reusing
  • What are Comment Lines in VBA
  • MsgBox
  • InputBox
  • Understand variables & constant
  • Usages of Immediate Windows
  • Basics Operators
  • Taking Decisions using Decision Making concepts
  • Looping for Automation
  • Working with String Functions
  • Handling Date and Time
  • Creating and Working with Arrays
  • Create Custom Formulas using VBA - UDF
  • Sub Procedures
  • Working with Chart using VBA
  • Working with Tables using VBA
  • Working with Pivot Tables using VBA
  • Working with Shapes using VBA
  • Worksheet Events
  • Error Handling
  • Working with Forms
  • More
JOIN & LEARN​
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Open soon

Microsoft 365 Free (if available)

Tally ERP 9

Tally

ERP 9
₨7500
₨ 5,999
  • Accounting Basics
  • Fundamentals of Tally ERP 9
  • Basics Accounting & Inventory Masters
  • Voucher
  • Advanced Accounting & Inventory Masters
  • Tax Management in Tally
  • Sales Tax Management
  • Payroll Accounting
  • Reporting
JOIN & LEARN
Live interaction with trainer
Training from MOS Certified Trainer
Downloadable practical files
Popular

  • Voucher Entry

  • Interest Calculation

  • Integration of Ledgers

  • Individual Bill Tracking

  • Replacing Accounting Codes

  • Control

  • Audit and Budgeting

  • Billing Information

  • Multiple Currency Support

  • Service Tax

  • Income tax

  • Sales Tax

Chat
1
Join
Powered by Joinchat
PrabasTech Welcome you.
Would you like to join a course?