Computer & Career Programs
Explore Lalsot's most comprehensive range of professional computer courses, accounting diplomas, and coding workshops.
RS-CIT WITH AI
Rajasthan State Certificate in Information Technology
RS-CIT WITH AI is a government-recognized computer course. Students learn computer fundamentals, MS Office, Internet, Cyber Security, Digital Payments and modern AI tools with practical training. **Syllabus:** • Computer Fundamentals • Windows • Microsoft Word • Microsoft Excel • Microsoft PowerPoint • Internet & Email • Cyber Security & Online Safety • Digital Payments & Government Services • ChatGPT & Google Gemini • Canva AI & NotebookLM • Generative AI Basics & AI for Office Productivity **Highlights:** • Government Recognized & VMOU Examination • 100% Practical Training & AI Enabled Curriculum • Audio & Video Learning & Useful for Government Jobs • Hindi + English Support **Certificate Provider:** VMOU Kota **Instruction Language:** Hindi + English
- Computer Fundamentals
- Windows
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Internet
- Cyber Security
- Digital Payments
- ChatGPT
- Google Gemini
- Canva AI
- NotebookLM
- Generative AI Basics
- AI for Office Productivity
- Digital Government Services
- Online Safety
Tally Prime with GST
Professional Accounting & Inventory Management
Learn professional accounting using Tally Prime with complete GST, Inventory, Banking, Payroll, Manufacturing and Financial Reporting. **Syllabus:** • Accounting Fundamentals, Company Creation & Features • Voucher Entry & Accounts Masters • Purchase, Sales & Inventory Management • Bills Management & Order Processing • Tax Management (GST Complete, Case Studies & Returns) • Payroll Introduction, Masters & Reports • Manufacturing, Job Work & Job Costing • Financial Statements & Reports **Modules Included:** • Sales & Purchase Management, Inventory & Bills Management • Payroll, GST, Manufacturing & Job Work **Tools Covered:** Tally Prime, GST Portal, Microsoft Excel, PDF Reports, Business Documents **Instruction Language:** Hindi + English
- Account & Company Concept
- Balance & Licensing
- Company Creation & Working with Company
- Accounts Masters
- Voucher Types
- Voucher Entry
- Inventory Management
- Purchase Order & Sales Order
- Reports
- Tax Management
- Security Management
- Banking Utilities
- Multi Currency
- Interest Calculation
- Financial Statements
- Utility Features
- Value Added Features
- Job Work
- Job Costing
- GST Complete
- GST Case Studies
- GST Return Filing
- Payroll Introduction
- Payroll Masters
- Payroll Vouchers
- Payroll Reports
Microsoft Office 365
Master cloud-based productivity apps: Word, Excel, PowerPoint, Outlook, OneDrive, and MS Teams
Master cloud-based productivity apps: Word, Excel, PowerPoint, Outlook, OneDrive, and MS Teams.
- MS Word
- MS Excel
- MS PowerPoint
- MS Outlook
- OneDrive
- MS Teams
Advanced Excel
Learn Microsoft Excel from beginner to advanced level including formulas, dashboards, Pivot Tables, Power Query concepts, Data Analysis, MIS Reporting, automation techniques and industry-level projects
Learn Microsoft Excel from beginner to advanced level including formulas, dashboards, Pivot Tables, Power Query concepts, Data Analysis, MIS Reporting, automation techniques and industry-level projects. Students will gain practical skills required for office jobs, MIS Executive roles, Data Analyst careers and reporting automation.
- Excel Basics
- Excel Introduction
- Data Entry
- Basic Formulas
- Conditional Formatting
- Advanced Conditional Formatting
- IF Formula
- Data Formatting
- Sheet Options
- Practice Assignment
- Data Handling
- Sorting
- Filtering
- Advanced Filter
- Paste Special
- Go To Special
- Find & Replace
- Practical Assignment
- Data Transformation
- Flash Fill
- Text to Columns
- Remove Duplicates
- Consolidate
- Data Validation
- What-if Analysis
- Scenario Manager
- Goal Seek
- Group & Ungroup
- Subtotal
- Practical Assignment
- Pivot Table Mastery
- Pivot Table
- Pivot Chart
- Slicer
- Timeline
- Top Bottom Analysis
- Pivot Analyze Options
- Calculated Field
- Dynamic Range
- Auto Refresh
- Multiple Pivot Tables
- Show Values As
- Recommended Pivot
- Pivot Assignment
- Power Pivot
- Lookup Formulas
- VLOOKUP
- Large Data Lookup
- VLOOKUP + MATCH
- Approximate Match
- Double VLOOKUP
- INDEX + MATCH
- XLOOKUP
- Practical Assignment
- Advanced Formulas
- COUNT
- COUNTA
- COUNTIF
- SUMIF
- SUMIFS
- AVERAGEIF
- MAXIFS
- MINIFS
- SORT
- FILTER
- TAKE
- TEXT Functions
- DATE Functions
- Financial Functions
- Projects
- Industry Level Dashboard
- MIS Dashboard
- Sales Dashboard
- HR Dashboard
- Financial Dashboard
- Interactive Reports
- Interview Preparation
- Excel Interview Questions
- Practical Assessment
- Mock Interview
- Resume Guidance
Power BI
Learn Microsoft Power BI from beginner to advanced level including Data Loading, Power Query, Data Modeling, DAX, Dashboard Design, Business Intelligence, Interactive Reports and Real Industry Projects
Learn Microsoft Power BI from beginner to advanced level including Data Loading, Power Query, Data Modeling, DAX, Dashboard Design, Business Intelligence, Interactive Reports and Real Industry Projects. Students will become capable of creating professional dashboards and business reports.
- Getting Started with Power BI
- Power BI Introduction
- Power BI Desktop Installation
- Loading Data
- Transform Data
- Canvas Settings
- Visualization Basics
- Basic Visualizations
- Formatting Visuals
- General Formatting
- Advanced Visualizations
- Line Chart
- Area Chart
- Ribbon Chart
- Waterfall Chart
- Funnel Chart
- Scatter Chart
- Pie Chart
- Donut Chart
- Treemap
- Map
- Filled Map
- Shape Map
- Azure Map
- Gauge Chart
- Card Visual
- Multi Row Card
- KPI
- Table
- Matrix
- Decomposition Tree
- Key Influencer
- Smart Narrative
- Conditional Formatting
- Power BI Service
- Publish Reports
- Filters
- Drill Through
- Buttons
- Edit Interaction
- Cards
- Bookmarks
- Sync Slicer
- Performance Analyzer
- Dashboard Development
- Dashboard Creation
- Relationships
- Measures
- IF Measures
- Basic Measures
- Emoji Measures
- Data Modeling
- Data Model
- Normalization
- Relationships
- Filter Flow
- Model Properties
- DAX Mastery
- DAX Introduction
- Measures
- Calculated Columns
- Quick Measures
- DAX Syntax
- Operators
- Date Functions
- Logical Functions
- Text Functions
- CALCULATE
- SUMX
- RANKX
- COUNTX
- Calendar Table
- MTD
- QTD
- YTD
- SAMEPERIODLASTYEAR
- PREVIOUSMONTH
- DATEADD
- DATEBETWEEN
- RELATED
- HASONEVALUE
- SELECTEDVALUE
- SWITCH
- Variables
- Practical DAX
- Business Usage
- Free Service
- Publish to Web
- New Slicer
- Power BI Pro Tips
- Unique Layout
- Image without Visual
- Image Tooltip
- PL-300 Preparation
- PL-300 Preparation
- Practice Questions
- Visualization Questions
- Interview Preparation
- Power BI Interview Questions
- Mock Interview
- Projects
- Sales Dashboard
- HR Dashboard
- Finance Dashboard
- Executive Dashboard
- Data Analytics Dashboard
- Interactive Business Dashboard
SQL Database
Learn SQL from beginner to advanced level including Database Design, Queries, Joins, Window Functions, CTE, PostgreSQL, Data Analysis and Industry Projects
Learn SQL from beginner to advanced level including Database Design, Queries, Joins, Window Functions, CTE, PostgreSQL, Data Analysis and Industry Projects.
- Getting Started
- SQL Introduction
- SQL Server Installation
- pgAdmin
- SQL Commands
- Database Creation
- Create Database
- Create Table
- Data Types
- Constraints
- ALTER
- Insert Data
- Delete Data
- Data Modification
- UPDATE
- DELETE
- TRUNCATE
- DROP
- Import Data
- Identity Column
- CSV Import
- Command Line Import
- SQL Queries
- Basic Queries
- WHERE
- ORDER BY
- GROUP BY
- HAVING
- Logical Operators
- UNION
- Practice Queries
- Functions
- Date Functions
- Age Function
- String Functions
- Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- UNION
- UNION ALL
- Sub Queries
- Sub Query
- IN Operator
- Practice Assignment
- Window Functions
- Aggregate Window Functions
- Analytic Window Functions
- Ranking Functions
- CASE Statement
- CASE
- Multiple CASE
- CASE with WHERE
- CASE with VALUES
- CTE
- Common Table Expression
- Recursive CTE
- Interview Questions
- Projects
- Industry SQL Project
- Data Analysis Project
- Interview Preparation
- SQL Interview Questions
- Mock Interview
Python Programming
Learn Python Programming from beginner to advanced level including Programming Fundamentals, NumPy, Pandas, Matplotlib, Data Analysis and Industry Projects
Learn Python Programming from beginner to advanced level including Programming Fundamentals, NumPy, Pandas, Matplotlib, Data Analysis and Industry Projects.
- Python Fundamentals
- Introduction to Python
- Installation & IDE
- First Program
- Workflow
- Variables
- Data Types
- String Practice
- Operators & Strings
- Operators
- Type Casting
- Input Function
- Calculator Program
- String Slicing
- String Methods
- Decision Making
- IF
- ELSE
- Nested IF
- Loops
- For Loop
- While Loop
- Nested Loop
- Advanced Loop Practice
- Functions
- Function Introduction
- Return Functions
- Calculator Project
- Function Arguments
- Lists
- List Basics
- List Methods
- List Iteration
- List Comprehension
- NumPy
- Arrays
- Multidimensional Arrays
- Random Arrays
- Indexing
- Slicing
- Data Cleaning
- Pandas
- Series
- DataFrame
- CSV Files
- Data Access
- Sorting
- Updating
- Grouping
- Export
- Matplotlib
- Data Visualization
- Charts
- Histograms
- Scatter
- Pie Chart
- Advanced Plotting
- Projects
- Exploratory Data Analysis Project
- Interview Preparation
- Python Interview Questions
Data Analytics Program
Learn Data Science & Visualization
A complete job-oriented Data Analytics Program covering Advanced Excel, SQL, Power BI, Python, Statistics and Tableau with real-world projects and dashboard development.
- Advanced Excel (6 Months)
- 200+ Advanced Excel Formulas
- Lookup Functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
- Pivot Table
- Pivot Chart
- Power Pivot
- Dashboard Development
- Data Cleaning
- Data Validation
- Conditional Formatting
- Financial Analysis
- Real Industry Projects
- SQL (3 Months)
- SQL Basics
- Database Design
- CRUD Operations
- Joins
- Sub Queries
- Window Functions
- CTE
- Projects
- Power BI (3 Months)
- Power Query
- Data Modeling
- Relationships
- DAX
- Dashboard Development
- Interactive Reports
- Business Intelligence
- PL-300 Preparation
- Projects
- Python (3 Months)
- Python Fundamentals
- Variables
- Operators
- Loops
- Functions
- NumPy
- Pandas
- Matplotlib
- EDA Project
- Statistics (1 Month)
- Descriptive Statistics
- Probability
- Inferential Statistics
- Hypothesis Testing
- ANOVA
- Chi-Square
- Tableau (3 Months)
- Data Visualization
- Dashboard Development
- Filters
- Calculations
- HR Analytics Project
- Final Industry Projects
- Sales Dashboard
- HR Dashboard
- Finance Dashboard
- Executive Dashboard
- Business Dashboard
- End-to-End Data Analytics Project
Web Designing
Design beautiful web layouts: HTML5, CSS3, JavaScript, responsive design, and CSS frameworks
Design beautiful web layouts: HTML5, CSS3, JavaScript, responsive design, and CSS frameworks.
- HTML5 Layouts
- CSS3 Styles & Grid/Flexbox
- JavaScript Interactivity Basics
- Responsive Web Design
- Tailwind CSS Basics
ADCA (Advanced Diploma in Computer Applications)
Comprehensive diploma program covering computer fundamentals, OS, MS Office, HTML/CSS, Tally Prime with GST, and advanced Excel modeling
Comprehensive diploma program covering computer fundamentals, OS, MS Office, HTML/CSS, Tally Prime with GST, and advanced Excel modeling.
- Computer Fundamentals
- Office Productivity Suites
- HTML/CSS Basics
- Tally Prime with GST
- Advanced Excel Modeling
RS-CFA (Rajasthan State Certificate in Financial Accounting)
Official Rajasthan government approved financial accounting certification course covering Tally Prime, GST, and business taxation
Official Rajasthan government approved financial accounting certification course covering Tally Prime, GST, and business taxation.
- Accounting Basics
- Tally Prime Setup
- Voucher & Ledger Configuration
- GST Returns & Filing
- Income Tax Basics
- RSCFA Practice Tests