About Rajkaran IT Solutions

Empowering skills for career growth through expert-led training in various industry-relevant courses.

Expert Training Courses

Enhance your skills with our industry-relevant courses for career growth and success.

Tally Prime

• Company & Ledger creation

• Inventory / Stock creation

• Sales and Purchase Management

• Point of Sales, Interest calculation

• Bank reconciliation.

• Manufacturing with Mfg. and Expiry Date

• TDS , TCS , Stock category

• Cost category and Cost center

• Multiple Godowns

• Price list / Multiple Currency

• Payroll Management Etc.

• MIS Reports

Good & Services Tax

• Introduction to GST

• Registration of GST

• SGST, SGST, IGST

• Regular, Composition scheme

• GST Rate & HSN/SAC

• Reverse Charge Mechanism

• Returns under GST -GSTR 1, GSTR3 B, GSTR 2A,

• GSTR 2B , GSTR9.

• Input Tax Credit

• Intro Previews Taxes VAT, CST, Service Tax,

• Excise Duty Etc.

• Overview of the Basics of Exce

• Functions/ Data Validations

• Formulas If, OR, NOT, INDEX, Sum, Count, Min Etc.

• Cell Reference: Relative, Aboslute, Mixed.

• Basic fundamentals of Table & Pivot Table

• Insert Slicer, Insert Timeline Slicer

• Logical Functions IF(), AND, OR, IFERROR()

• Basic to Advanced VLOOKUP(),

• Sorting and Filtering Data.

• Reports/Goal seek

• Conditional Formatting

• Macros /What If Analysis

• Create Dashboard

Advanced Excel

Graphic Designing

Digital Marketing

Data Analyst

• Introduction to Data Analysis

• Role & responsibilities of a Data Analyst

• Basic to Advance Excel with formulas and Pivot Tables & Pivot Charts, filter

• Basic to Advance PowerPoint

• Slide masters, layouts & themes

• Best practices for data visualization in PPT

• Creating impactful business presentations

• Introduction to Power BI

• Importing data (Excel, CSV, SQL, Web, etc.)

• Data cleaning & transformation with Power Query

• Data modeling & relationships

• DAX basics (calculated columns, measures)

• Visualizations: charts, tables, maps, KPI cards

• Filters, slicers & drill-through reports

• Building interactive dashboards

• Canva (Graphic Designing) ,Create Template / Video for Marketing

• Website Development

• SEO-Search Engine Optimization

• Social Media Optimization- Facebook, Instagram, Linked and YouTube.

• Google My Business [GMB]

• Artificial Intelligence

• Facebook Ads

• Youtube Ads

• Whatsapp business

• Content Wriiting

• Email Marketing

• Introduction Corel Draw

• Drawing and Coloring

• Mastering with Text

• Applying Effects

• Working with Bitmap Commands

• Introduction Photoshop

• Top Menu Tool

• Drawing Things on the Canvas

• The Tool Box

• Modifying Things on the Canvas

• Logo Text in 3D

• Advanced Tool

• Backboard Under painting

• Selecting Things Etc.

Rajkaran IT Solutions transformed my career with their practical training in digital marketing and data analytics.

Amit Sharma

★★★★★