TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel (ComboPack)

Descripción

Unlock Your Potential with Our Ultimate Accounting Mastery Bundle! Are you ready to take your accounting career to the next level? Look no further! Our comprehensive bundle course is designed to equip you with all the essential skills and knowledge needed to excel in the dynamic world of finance and accounting. Designed by Tally Certified Trainer, GST & Income Tax Practitioner, Tax Consultant this program has already helped over 3,00,000+ learners worldwide land jobs, grow businesses, and advance their finance careers. What You'll Learn: • Accounting Basics to Professional Bookkeeping • TallyPrime – All Levels, Latest Version (3.0-6.0) • GST Return Filing (GSTR-1, 3B), E-Invoice, E-Way Bill • Income Tax Filing (ITR 1-5), 26AS, Capital Gains • Payroll Management (PF, ESI, Gratuity, Bonus, CTC, Payslips) • TDS & TCS Filing (24Q, 26Q, 27EQ) with Traces & Portal Setup • MS Excel for Accountants – Functions, Dashboards, Payroll Sheets • Real-time GST, TDS, and IT portal integration with Tally & Excel • Case Studies, Assignments & Practical Simulations Why This Course Stands Out: • Premium Course on Udemy – Accounting & TallyPrime • 4.4+ Rating from 5,800+ Learners • Used by 2 million+ businesses – Learn Official Tally • Trained by a Faculty Who Trains the Trainers • Official Tally Content Developer Course Features: • 59+ Hours of HD Video Lectures (404+ Lessons) • Step-by-Step Modules with Real-Time Data • Section-wise Quizzes, Assignments & Practice Files per Chapter • Lifetime Access + Future Content Updates • Instructor Support through Q&A Section • Downloadable Lecture-wise materials What Will You Be Able To Do? After completing this course, you will: • Understand end-to-end accounting workflows • Manage books of accounts in Tally with 100% accuracy • File GST monthly, quarterly, and annual returns • Manage GST registration, amendments, refunds, cancellations • File TDS & TCS returns, and issue Form 16 & 16A • File Income Tax returns for individuals & businesses • Run full-fledged payroll with statutory compliance (PF, ESI, PT) • Analyze reports & build automation in MS Excel Check Course Curriculum : Section-1: Basics of Commerce, Accounting S1.1 What is Commerce S1.2 What is Accounting & Why do we need it S1.3 Double Entry Systems Step-Structure S1.4 Golden Rules of Accounts S1.5 Fundamentals of Accounting (pdf) S1.6 Accounting Standards, Principals (pdf) S1.7 Basic Terms Used in Accounting (pdf) Section-2: Course Tips, Download Materials, Practice Notes S2.1 Download Materials S2.2 How to Watch & Practice Videos S2.3 Promotions-Tally Certifications S2.4 Promotion-Text Books S2.5 Promotion – Tally License Section-3: TallyPrime Basics S3.1 Overview on Tally – History, Advantages, Releases S3.2 Pricing of Tally Application – Modules of licenses S3.3 Tally License Request for Practical’s S3.4 Download & Installation, Update TallyPrime S3.5 Licensing options – Education mode, License from network and Activate New License S3.6 Change default data saving path I Company Data Saving Path S3.7 Create your first company –Create, Alter, Shut, Delete, Default Loading Company S3.8 TallyPrime – pre-defined voucher an Introduction S3.9 Recording simple purchases & Sales S3.10 Recording Contra, receipt, payment vouchers S3.11 Recording Journals in TallyPrime S3.12 How to update opening balance for ledger, opening stock for items S3.13 TallyPrime DATA Recording Steps S3.14 Tally Prime - How to update to Future Releases Section-4: Billing in TallyPrime with GST S4.1 What is GST-a short Introduction to GST S4.2 GST Classifications and Place of Supply S4.3 Recording GST Purchases & Sales – Traditional Method S4.4 Recording GST with Auto Billing, Exclusive GST Ledgers for Input and Output S4.5 Billing Configuration – Company Logo S4.6 Billing Configuration – Additional Description for Stock items & Ledgers S4.7 Billing Configuration – Enable Rate Inclusive of Taxes column S4.8 Billing Configuration – Update Sales Voucher Numbering S4.9 Printing Configuration – Invoice Status, Bank Details, Jurisdiction, Customer seal & Sign S4.10 Optimize Paper Printing size S4.11 Recording GST Services S4.12 Recording GST Expenses Claimable and Non-claimable S4.13 Recording GST Assets – claimable and non-claimable Section-5: GST Filing, E-Invoice-E-way bill generations S5.1 Understanding GST Returns & Types S5.2 GST Tax Computation & Adjustments S5.3 Learn GSTR-1 Tables S5.4 GSTR-1 Filing using TallyPrime S5.5 GSTR-1 Nil Filing S5.6 GSTR-1 & GSTR-1A Amendments S5.7 GSTR-2A/2B Reconciliation S5.8 GSTR-3B Filing – with Tax Payments S5.9 E-Way bill Registration S5.10 E-Way bill Generation, Update & Cancellation (in Portal) S5.11 E-Invoice Introduction S5.12 E-Invoice GSTIN Registration, E-Invoice Enablement of GSTIN S5.13 E-Invoice Enablement for GSTIN on E Invoice Portal S5.14 E-Invoice - API User Creation for Your Accounting Software S5.15 Generate E-Invoice using Tally - Generate and E-Invoice, print within Tally using API Logins S5.16 E - Invoice Cancellation in Tally as well as E-invoice Portal S5.17 E-Invoice Generation - Tally to JSON, JSON Manual Upload on E Invoice Portal _ if API logins are not created S5.18 E-Invoice Generation Using Official Excel kit - Excel to JSON, JSON upload on E-Invoice Portal S5.19 GST Composition scheme introduction, Slabs, Eligibility S5.20 GST CMP-08 Filing - Composition GST Return Filing Section-6: Inventory Management S6. 1 Inventory Management - Introduction, Importance, Advantages S6. 2 Creation of Unit of Measurement S6. 3 Stock Group - Creation and Alteration' S6. 4 Stock Category - Creation and Alteration S6. 5 Stock Items - Creation and Alteration S6. 6 Activation of Batches for Stock Item S6. 7 Allocation of batch details in purchase invoice S6. 8 selling of stock items from batch and identifying of expired batch in sales invoice, printing batch info S6. 9 Returning of Expired Batch Stock Item S6. 10 Activating Price Levels S6. 11 defining price levels, creating price list, usage of price list in sale voucher S6. 12 S6.12 Revise Price List S6. 13 Different Types of Inventory Valuations S6. 14 Activation of Purchase Order and Sales Order S6. 15 Activation of Delivery & Receipt Notes S6. 16 S6.16 Activation of Debit & Credit Note S6. 17 Purchases management - purchase order, receipt note, purchase, purchase returns S6. 18 Sales Management - Sales Order, Delivery Note, Sales, Sales Return S6. 19 Creation of Godown S6. 20 How to Create and Manage Multiple Godowns in TallyPrime S6. 21 Manufacturing in Tally Part-1 S6. 22 Manufacturing in Tally Part-2 S6. 23 Manufacturing in Tally Part-3 Section-7: Bill-wise accounts I Accounts Receivable & Payable Management S7.1 Bill-wise Accounts - An Introduction S7.2 Bills wise details for Purchases S7.3 Bill-wise Details for Sales - Bills Receivable S7.4 Bill-wise Accounts - Tracking Overdue Supplies S7.5 Bill-wise Accounts - Advances Management S7.6 How to view and analyse bills outstanding reports in tallyprime Section-8: TallyPrime with Banking S8.1 Cheque Book Configuration in TallyPrime S8.2 Cheque Printing in TallyPrime S8.3 Enabling All-Banking Transaction Types S8.4 An Introduction to Post Dated Cheques Management S8.5 Post Dated Cheques Management in TallyPrime S8.6 Introduction to Bank Reconciliation Process in TallyPrime S8.7 Bank Reconciliation in TallyPrime S8.8 How to Do Auto Bank Reconciliation Section-9: Tally Updates, New Releases, Enhancements S9.1 Calculator usage in Tally S9.2 Alternative units of measurements S9.3 Part numbers in TallyPrime S9.4 Standard rate setup in TallyPrime S9.5 Export reports from TallyPrime S9.6 Group company creation in TallyPrime S9.7 Release 5.0 How to Create Ledgers using GSTIN, Import GSTIN S9.8 Release 5.0 How Check Party's GST Filing Status S9.9 Release 5.0 How to View ITC at Risk Balance S9.10 Release 5.0 How to Enable Strip View S9.11 Release 5.0 How Print and Export Multi Vouchers S9.12 Release 5.0 Dashboards - Report Analysis S9.13 Release 5.0 How to Download GST Returns Data S9.14 Release 5.0 GSTR-1 Filing within Tally S9.15 Release 5.0 Download & Installation of Edit Log S9.16 Release 5.0 Tracking data Alterations using Edit Log - for Ledgers, Items and Vouchers S9.17 Release 5.0 User Management - Admin Creation, Edit Log, Audit Features S9.18 Release 5.0 User Management - User Creation, Edit Log, Audit Features S9.19 Release 5.0 User Management - User Roles S9.20 Release 5.0 User Management - Password Policy S9.21 Access Tally Data on Cloud - Browser Access Section-10: TallyPrime Closing S10.1 Golden Rules of Accounts S10.2 Capital & Drawings related adjustments S10.3 Party settlements, Discounts, Bad debts S10.4 Appreciation & Depreciation Adjustments S10.5 Prepaid & Outstanding Adjustments S10.6 Data Backups & Split Company Setups for New Financial Year Section-11: Tally - Case Studies & Assignments S11.1 Tally Comprehensive Case – Test Paper-1 S11.2 EMI Management in Tally Section-12: GST Portal + E Invoice Portal + E Way bill Portal Concepts S12.1 What is GST-a short Introduction to GST S12.2 GST Classifications and Place of Supply S12.3 Understand GST Number S12.4 GST Registration Threshold Limits and Documents Required for GST Registration S12.5 GST Registration-Proprietorship and Partnership S12.6 Track Submitted Application Status S12.7 GST Registration - Filing Clarifications S12.8 GST Practitioner Registration S12.9 How to Download GST Certificate S12.10 GST Amendments- Core Fields and Non-Core Fields S12.11 GST - Opting Regular or Composition S12.12 GST Cancellation and Revocation S12.13 What is GST Returns, Types of GST Returns S12.14 Learn GSTR-1 Tables S12.15 GSTR-1 Filing using TallyPrime S12.16 Filing Nil-GSTR-1 I when there is no Sales S12.17 GSTR-1 Amendments I Modify Previous Months Invoices S12.18 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods S12.19 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary - Adjustments S12.20 GST Composition scheme introduction, Slabs, Eligibility S12.21 SGST CMP-08 Filing - Composition GST Return Filing S12.22 GST Refund- Compete Process S12.23 How to Generate E-way bill, Registration, Print, Cancellation, Masters Creation, User Creation, 3 methods S12.24 E Invoice Introduction S12.25 E-Invoice - GSTIN Registration of E Invoice Portal S12.26 E-Invoice Enablement for GSTIN on E Invoice Portal S12.27 E-Invoice - API User Creation for Your Accounting Software S12.28 S13.28 Generate E-Invoice using Tally - Generate and E-Invoice ,Print within Tally using API Logins S12.29 E - Invoice Cancellation in Tally as well as E-invoice Portal S12.30 E-Invoice Generation - Tally to JSON , JSON Manual Upload on E Invoice Portal _ if API logins are not created S12.31 E-Invoice Generation Using Official Excel kit - Excel to JSON, JSON upload on E-Invoice Portal Section-13. Payroll Management S13.1 What is Payroll I An Introduction S13.2 What is Basic Salary, methods of calculating basic salary S13.3 What is DA, methods of Calculating DA S13.4 What is HRA, how to Calculate HRA, Taxability and Exemption Calculation S13.5 Pay heads CA, TA, LTA I Conveyance Allowance I Travel Allowance I Leave TA S13.6 EPF I Employee Provident Fund I Calculation I Employee and Employer Contributions I Taxability S13.7 ESI I Employee State Insurance I Rules I Percentages I Contribution Period S13.8 What is Gratuity I Calculation of Gratuity I Taxability I Ceiling Limit S13.9 Bonus Act 1965 I What is Bonus, How to Calculate, Taxability S13.10 Income Tax on Salary I TDS Computation, Cess, Surcharges, Salary Increment Cases S13.11 Professional Tax - Stat-wise I Applicability I Slabs S13.12 CTC vs Gross Salary Vs Net Salary S13.13 Attendance Sheer Preparation I Present, Paid Leaves, Absents, Holidays using Countif, Countif, Sum Formulas with Data Validation S13.14 Complete Payroll Calculation-Gross Salary, Deduction, Income Tax, Sur-charge, Net Salary Calculation S13.15 PaySlip Generation from Paysheet in MS Excel S13.16 TDS Deposit on Income Tax Portal S13.17 Employer Contributions PF ESI S13.18 EPF, ESI Establishment Registration S13.19 Add - Exit of Employee Records on EPFO website S13.20 EPF Returns Preparation, Filing S13.21 EPF Nill Return Filing S13.22 How to Add Employee in ESI website I generate IP Number S13.23 ESI Returns Preparation and Filing S13.24 Tally Prime Step-1 – Creation of Company and Enabling Payroll S13.25 TallyPrime Step-2- Creation of Employee Groups and Employees S13.26 Tally Prime Step-3- Creation of Attendance Types S13.27 Tally Prime Step-4 -Creation of Pay Heads-Part-1 – Basic, DA, HRA, CA and more S13.28 Tally Prime Step-4-Creation of Pay Heads -Part-2- Income Tax, Cess and more S13.29 Tally Prime Step-5-Define Salary Details S13.30 Tally Prime Step-6-Payroll Monthly Routine- Calculate Salary, Generate Pay Slip Section-14: TDS & TCS S14.1 Ways of Collecting Income Tax- Self Assessment Tax- Advance Tax, TDS, TCS S14.2 Know Basic Terms used in TDS and TCS S14.3 TDS Process Overview I Cycle of TDS S14.4 TDS Deposits - Payment Due Dates, Penalties S14.5 TDS Returns Forms Dues Dates, Penalties S14.6 TDS Certificates Form 16-16a S14.7 How to Apply for TAN - Form 49B S14.8 VV Imp PAN and TAN Registration ON INCOME TAX PORTAL - first time users S14.9 VV Imp TAN Registration on TDS Traces Portal S14.10 TDS Recording – Deduction- Deposit – Case-1 S14.11 TDS Recording – Deduction- Deposit – Case-2 S14.12 TDS Recording – Deduction- Deposit – Case-3 S14.13 TDS Returns – Download Software’s, CSI, Java, RPU S14.14 TDS Returns – Filling 26Q, Generate FVU, File Returns on Income Tax Portal S14.15 How to View Submitted TDS Returns and Collect Token RRR Number on Income Tax Portal S14.16 How to View TDS Return Status on TDS Traces Portal S14.17 How to Download TDS Certificates Form 16A S14.18 TDS on Salary – Computation S14.19 TDS Deposit – Single and Multiple Employees S14.20 TDS Returns – Download Software’s, Winrar, CSI, Java, RPU S14.21 TDS Returns – Filling 24Q, Q1, Q2, Q3 Generate FVU, File Returns on Income Tax Portal S14.22 How to Download TDS Certificates Form 16 S14.23 TCS Overview – TCS Cycle S14.24 TCS – Collection- Deposit – Case-1 S14.25 TCS – Collection- Deposit – Case-2 S14.26 TCS – Collection- Deposit – Case-3 S14.27 TDS Returns – Download Software’s, CSI, Java, RPU S14.28 TCS Returns – Filling 27EQ, Q1, Q2, Q3 Generate FVU, File Returns on Income Tax Portal S14.29 How to Register PAN on TDS Traces Portal - Using Aaddhar Info, Deductos Info, Challan Info S14.30 How to Download Provisional Form 16-16A from TDS Traces Portal S14.31 TDS Returns – Filling 24Q, Quarter-4 Generate FVU, File Returns on Income Tax Portal Section-15: Income Tax S15.1 What is Tax, History of Taxes in India S15.2 Direct Taxes vs Indirect Taxes S15.3 What is ITR, When to File ITR Forms S15.4 Types of ITR Forms and Applicability S15.5 Ways of Collecting Income Tax- Self Assessment Tax- Advance Tax, TDS, TCS S15.6 Taxation Overview on Individuals, Firms, Companies, Political Parties S15.7 Old vs New Slabs comparison S15.8 PAN Registration on Income Tax Portal S15.9 How to Check 26AS and AIS S15.10 Advance Tax - Calculation and Deposit on Income Tax Portal S15.11 How to Register PAN on TDS Traces Portal - Using Aaddhar Info, Deductos Info, Challan Info S15.12 How to Download Provisional Form 16-16A from TDS Traces Portal S15.13 ITR-1 Draft Preparation and Computation of tax-new S15.14 ITR-1 Filing - Case-1 - Taxable Income but No Tax Liability S15.15 ITR-1 Filing - Case-2 NO Taxable Income but TDS Deducted - Apply for Refund S15.16 ITR-1 Filing - Case-3 Applying for Refund by reducing Taxable Income S15.17 ITR-1 Detailed Filing with the Help of Computation S15.18 Income Tax Computation - as per 44AD, 44ADA Non-Audit - for Individuals and Firms Income from Business or Profession S15.19 Filing Form 10IEA I Opting Old Regime for Individuals having income from Business or Profession S15.20 ITR-4 Filing for Individuals I Income from Business - Presumptive Taxation S15.21 Computation - Capital Gains on Property Transfers S15.22 ITR-2 Filing - Capital Gains from Property Transfer S15.23 Filing - Capital Gains from Stocks S15.24 Important Notes on ITR-3 and ITR-4 Selection S15.25 ITR-3 Filing with as per Book of Accounts S15.26 ITR-3 Filing Comprehensive Case Study S15.27 ITR-4 Filing for Individuals and Firms - Presumptive Taxation Scheme S15.28 ITR-5 Filing Over view Firms, LLPs, AOI, BOI, Co-operative society, Govt Authorities Section-16 Updates, Notifications, Circulars S16.1 UPDATE Budget 2025 I Capital Gains - Stock Market S16.2 UPDATE Budget 2025 I Capital Gain - House Property Transfer S16.3 UPDATE Budget 2025 I Old Vs New Slabs Comparison S16.4 UPDATE Budget 2025 I TDS on Salary Computation S16.5 UPDATE Budget 2025 I Advance Tax Calculation What Are You Waiting For? This course has already transformed thousands of careers — yours could be next. Enroll now and take the first step toward becoming a complete accounting professional. See you inside the classroom!

Lo que aprenderás

• Basics of Accounting, TallyPrime All Levels
• GST & GST Portal Concepts
• Income Tax & TDS, TCS
• Payroll Management
• E-Way bill, E-Invoice, MS Excel
• MS Excel
• Capital Gains
• TallyPrime - Download , Install , Activation
• Golden Rules of Accounts
• Tally Prime with GST - Course Material
• Company-Creation, Alteration, Deletion & Securing
• Understanding Tally Pre-defined Vouchers
• Tally Data Processing Structure
• Understanding Tally with Basic Illustrations
• Recording & Maintaining Installments in Tally ERP9 I Bill-wise Accounts
• Recording & Maintaining Supply against Advances - Advances Management
• Tracking OverDue Supply - Credit Sales
• Multi-Currency Accounting in Tally ERP9 & Adjustment Entries for Forex GainLoss
• Cheque Book Configuration in Tally ERP9
• Banking - Transaction Types
• Post Dated Cheques Management in Tally ERP9 I PDC's
• Bank Reconciliation Introduction
• Bank Reconciliation in Tally ERP9 Practical I Case Study 1
• Bank Reconciliation In in Tally ERP9 I Case Study 2
• GST Revenue Sharing Ratios between Center & State Govt's
• GST Classifications
• Enabling GST Features in Tally ERP9
• Recording GST Transactions SMART RECORDING METHOD
• Recording GST Transactions TRADITIONAL METHOD
• Recording GST Transactions - CaseStudy 2
• GST Tax Invoice Configuration - Voucher Numbering
• Recording GST Transaction with Auto-Billing
• GST Tax Invoice, Bank Details-Cus Seal &Signature, Jurisdiction -Printing Confin
• Rate Inclusive of GST I Enabling Item Description in Tally ERP9
• Recording GST Transactions - Services
• Recording GST Transactions - Assets I with Input Tax Credit I without ITC
• Recording GST Transactions - Expenses with & without Input Tax Credit
• Recording GST Transactions - Sales with Additional Expenditure
• Genarate E-Way Bills Creation, Alter & Cancellation Online Offline methods
• GST- Recording RCM in Tally ERP9
• GST Overview Introduction
• Key Points about GST Council
• Introduction to GST Returns
• GSTR - 3B Filing
• GSTR-1 Filing ( GST-Regular) Offline Online Methods Explained with Live Data
• GST Registration - Live (Case Study 1)
• GST Registration - Filing Clarifications
• GST Registration - Tracking Submitted Applications
• Viewing Submitted Applications - GST Registration
• GST Registration - Core Filed Amendments
• GST Registration - Non-Core Filed Amendments
• GST Application for Refund
• GST Registration -CANCELLATION
• GST Tax Practitioner Registration
• Opting Withdrawal of Composition Levy in GST Portal
• What is TDS ( Tax deduction at source ) - How to calculate TDS - Introduction
• How to Configure TDS in Tally ERP9 & Recordinng TDS Entries in Tally
• Recording TDS Transaction in Tally ERP9
• Purchase Returns & Sales Returns in Tally ERP9
• Delivery Notes & Receipt Notes in Tally ERP9
• Sales Orders Quotations in Tally ERP9
• Tally ERP9 Discounts I Trade Discounts & Cash Discounts
• PriceList's in Tally ERP9 I Party Level & Product Level
• Auto-Interest Calculation on Overdue Installments
• Basic of Manufacturing
• Standard Manufacturing Practicals in Tally ERP9
• Cost Centres in Tally ERP9 (Departments Handling)
• Branch-Wise Accounts-Using Cost Centers & Godowns in Tally ERP9
• Multi User Creation in Tally ERP9
• Security , Password for Users in Tally ERP9
• Tally Internal Data Verification & Tally Audit
• Recording - Year End Adjustments in Tally ERP9
• Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split
• Payroll - in Tally ERP9 Introduction to Steps
• Payroll-Complete Setup Monthly Process & Stop Computation - Overall Coverage
• Budgets in Tally ERP9
• Calculator Usage in Tally ERP9
• Tally Data Backup & Restore
• Alternate Units of Measurement in Tally ERP9
• GSTR1 GSTR3B New Due Dates Late fee Updates (Feb-Mar-Apr-May) 2020
• Batches Management (with Date of Manufacturing & Expiry )
• Data Searching in Tally ERP9
• DayBook Features in Tally ERP9
• POS in Tally ERP9
• Splitting in Tally ERP9
• Part Numbers in Tally ERP9
• Standard Rate Setup in Tally ERP9
• Zero Valued Transactions
• Export to Excel, JPEG, PDF, HTML
• DATA Export & Import in Tally ERP9
• Live Mailings from Tally ERP9
• Tax Audit Due Date Extention
• Reply to Students Request Refund Applied I Deducted on GSTN INot Credited2 bank
• Reply to Students Request Know Your PAN Status
• Budget 2020 I Highlights I Income Tax Slabs I New & Old I Benefits
• 37th GST Council meeting I 2 major decisions I Relaxtion of Filing GSTR-9 &+more
• Highlights of 38th GST Council Meeting
• Microsoft Excel - Beginner to Advanced A Master Pro Course An Introduction to Microsoft Excel
• How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Cells
• MS Excel - Copy Cells, Move Cells
• Learn How to Create Tabs, Groups and add Toll to it in MS Excel
• MS Excel - Home Tab - Group Clipboard Features Functions Explained
• MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
• Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
• MS Excel - Characteristics of Cell
• Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
• MS Excel - Fill Series - with formatting, without formatting & more
• Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add,
• Fill Series - Flash Fill
• Excel - Editing Data I over writing I Go to I find & replace I undo & redo
• MS Excel - Text to Columns
• MS Excel - Comments - add, edit, delete & Show all
• MS Excel - How to Hide and Unhide Rows, Columns, Sheets
• Freeze Panes - Top Row, Columns & Multiple Rows & Columns
• MS Excel - Filters - Learn How to Use Filter to analyse Big Data
• MS Excel - Split Sheet Window
• MS Excel - How to Insert & Delete Cells, Rows, Columns
• MS Excel - Working with Sheets
• MS Excel - Format Multiple Sheets at a time I Sheet Formatting
• MS Excel - View Sheets Side by Side from One Excel File
• MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
• MS Excel - Sheet & Cells Protection
• MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
• Concatenate - Join Multiple Text Strings into ONE
• MS Excel - Trim Functions - Remove unnecessary Elements from strings
• MS Excel - Print Formulas Left, Right, Middle
• MS Excel - Date Related Formulas
• MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
• MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
• MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
• MS Excel - Create & Remove Drop Down List
• Introduction to Data Validation - Time limitation
• Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
• Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Inform-
• Data Validation - Dependent - Multiple Drop Down Lists
• MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
• MS Excel - Import Data from Websites - Live Data
• MS Excel - Import Data from Text Document - with Auto Refresh
• MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
• MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
• MS Excel - Charts - Columnar, Bar, Line Charts
• Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I
• Logical Test - IF Function
• Logical Functions - Nested IF - Learn How to work with Nested if Formula
• Logical Functions - AND function
• Logical Function - Not & IFERROR
• MS - Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Mu
• Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Av
• MS Excel - 3D Sum I Calculate Multiple Sheet Data at a time
• MS Excel - Consolidate ( 3d Sum extension)
• Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula
• Formulas - sumproduct, mround, floor, ceiling
• Index Formula - Find a Position of the Value, and Call cells references
• Match Formula - Find Position of the Value
• MS Excel - Age Calculator in Multiple Ways - Exclusive formula
• StudentMark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
• V Lookup - Introduction
• V Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
• H Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
• X Lookup - Introduction
• Download, Add & use X Lookup New Formula in MS Excel
• X Lookup New Formula in MS Excel
• Pivot Table Introduction & Basics of Pivot Table
• Create a Pivot Chart from Table & Pivot Table
• Pivot Table - Use slicers to filter data
• Pivot Table, Charts, Progress Dashboard
• MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
• Working with Tables
• Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Date Valid
• Share a workbook with Co Authors, Employees or with Anyone
• Commission Calculation in MS Excel
• Attendance Sheet Preparation in MS Excel
• Salary Calculation with CA, DA, Commission, Advance, PF, ESI
• Excel to SMS
• Macros
• VBA

Requisitos

• a desire to learn new skills