fbpx

Surekhabhosale.com

Advanced Excel Online Mastery
&
Tally.ERP9 Online Mastery

Attention!!🙄

Students and Working Professionals!!

Do you know which are the most important and powerful skills needed in industries today?

It’s having knowledge of Advanced Excel skill and Tally.ERP9 skill which is used by almost 90% of businesses.

I Can Help You TO MASTER this SKILL

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

Advanced Excel Mastery Value:
Rs 8,999 Rs 1,999/-

Tally.ERP9 Mastery Value:
Rs 6,999 Rs 1,999/-

BUNDLE COURSE OFFER!!

Advance Excel + Tally
at just Rs 15,998/- Rs 3,998/-

Rs 2,999/-

Trainer - Surekha bhosale

Get INSANE, CRAZY, & Never Before Offer on Tally.ERP9 / Advanced Excel At just 90% Price of offline training with Unbelievable Bonuses for the limited time of 5 days

Why should one have detailed knowledge of Excel?

  • Today’s world is digital and every information is stored digitally.
  • Nowadays most of the office tasks related to Accounts, Admin, HR, Sales, Purchase, Stock etc. are managed by using Excel.
  • The person who has just basic skills can just do a data entry job in Excel and will not be able to generate meaningful reports from the entered data.
  • Every now and then the information which is stored digitally needs to be analysed to make proper decisions
  • The person who has advanced excel skills plays a major role in the management of information systems (MIS) by Analyzing, Sorting, Tabulating Raw Data and presenting it to Managers in proper form.
  • Most of the business decisions based upon analysis of historical data such as trends in sales, profit, customer complaints over the years. This task can be very well performed if one has excellent advanced excel skill.
  • The person who has advanced Excel skills can analyse raw and voluminous data and presents it to the Managers using charts and graphs so that they can quickly make decisions on the most complex problems.

Advantages of learning advanced excel

  • The person having good advanced excel skills give more productive output in less time.

  • All most 90% of Job opportunities prefer person having Advanced Excel Skills who can generate more productive output for the company.

  • While learning Advanced Excel Skills you get access to practical aspects of the business which gives you more clarity.

  • Learning Advanced Excel will train your brain to think logically and deeply, which helps improve Intelligence Quotient and also builds on decision-making capabilities.

  • One can automate his entire workflow by using advanced concepts of Excel which leads to higher productivity.

  • It improves visualisation ability. You can create a proper tracking system around your workflow.

  • Advanced Excel Skill leads to Career Advancement as it adds value to your CV and helps you get the desired Job

  • You will get increased value as an employee as you have more skills to offer to your company as you will become faster and efficient at your work.

  • A person with Advanced Excel skill has the ability to organize, calculate and evaluate quantitative data which is the most commonly required skill in business and managerial decision-making

Hurry Up!! Limited Period Offer!!

Get Ready To Take Your Skills To The Next Level And Save Up To 90% With Our Course Bundles!

Why should one have detailed knowledge of Tally.ERP9?

  • Today’s world is digital and every information is stored digitally. Learning Tally.EP9 gives access to the practical world of accounting where you implement all theory concepts learned in academics.
  • Learning Tally during college days gives you a clear understanding of theory accounting concepts by implementing it practically and boost your academic performance.
  • Doing accounting with Tally saves lots of time. It provides accurate results and efficiently carries business transaction securely.
  • Every now and then the information which is stored digitally needs to be analysed to make proper decisions. Tally generates different reports as per need to do the analysis in seconds.
  • The person who has Tally skills plays a major role in the management of the accounting system by Analyzing, Sorting, Tabulating Data and present it to Managers.
  • Most of the business decisions based upon analysis of historical data such as trends in sales, profit over the years. This task can be very well performed if one has excellent Tally skill.
  • A Tally is a software which can perform all the work, therefore, it is called ERP 
  • The growth of almost every business is tracked by amazing accounting software Tally.ERP9 in all areas like Billing, Inventory, Debtors, Creditors, Auditing, Tax Compliance etc.. which are the crucial aspects of business

Advantages of learning Tally.ERP9

  • Debtors, Creditors management, Income Expense management becomes easy with Tally.

  • The person having good Tally skill give more productive output in less time

  • All most 90% of accounting Job opportunities prefer person having Tally Skills who can generate more productive output for the company.

  • While learning Tally Skill you get access to practical aspects of the business which gives you more clarity and understanding.

  • Tax compliance became hasslefree with Tally. Tally ensures all GST compliance norms and provides audit facilities too

  • Payroll management is integrated into Tally.

  • Remote access facility gives you the flexibility to connect different branches at different locations from anywhere

  • Learning Tally will train your brain to think logically and deeply, which helps improve Intelligence Quotient and also builds on decision-making capabilities.

  • Tally Skill leads to Career Advancement as it adds value to your CV and helps you get the desired Job.

  • You will get increased value as an employee as you have more skills to offer to your company as you will become faster and efficient at your work

Get INSANE, CRAZY, & Never Before Offer on Tally.ERP9 / Advanced Excel At just 90% Price of offline training with Unbelievable Bonuses for the limited time of 5 days

Hurry Up!! Limited Period Offer!!

Get Ready To Take Your Skills To The Next Level And Save Up To 90% With Our Course Bundles!

Why choose our online course ?

I believe in Smart Work and Smart work can happen only if you know right path to do it.

I do have offline training institutes where we have taught more than 35000+ students which has produced amazing results. This experience will be shared to you as per your convenience in online course

You will get lifetime access to the course once you sign up

If you have any doubts, you can ask in special group and you will get live doubt clearing support

This online course is available at an affordable price from an experienced faculty. (Almost at just 10% cost of offline classes)

You will get a free career guidance session to plan your career path in the right way.

Many students who want to go for offline training also prefer this course online as it is at very low cost and time constraint, travelling constraints are eliminated.

Counselor - Surekha bhosale

I am

Good news for you

Get INSANE, CRAZY, & Never Before Offer on Tally.ERP9 / Advanced Excel At just 90% Price of offline training with Unbelievable Bonuses for the limited time of 5 days

bonus 1 private facebook group

Bonus 1
Value: Rs 299/-

Bonus 2 - Private Whatsapp group

Bonus 2
Value: Rs 299/-

Bonus 3 - Additional Assignments

Bonus 3
Value: Rs 999/-

Bonus 4 - Live review & Doubt clearing session

Bonus 4
Value: Rs 1,999/-

Bonus 3 - Additional Assignments

Bonus 5
Value: Rs 999/-

Bonus 6 - Program review call with student

Bonus 6
Value: Rs 599/-

Total Value of these Bonuses: RS 9,193/-
Get access TODAY
for
Rs 9,193/- FREE

FREE
Bumper Bonus
Value: Rs 3,999/-

Bonus - Free MS-word & MS-PPT

For pursuing a knowledge you must consider this online course to get trained in Advanced Excel skill and Taly.ERP9 Skill, designed by Hrishi Online Buddhi and taught by experienced faculties. Hrishi is one of the top institutes in Mumbai north region offering different skill courses online.

Under the Guidance of

Hear what she has to say

Surekha Bhosale

Take this important step to excel in your career and sign up for the best Advanced Excel and Tally.ERP9 course for just 8% of the price of offline training. This offer is valid for just the next 5 days. You will get course access on 9th April 2020.

I've made these tutorials from my 19+ years of experience of training. I also run an offline institute as well as a Software Development Company

Trainer - Mrs. Surekha Bhosale

So it's up to you to decide

Want to learn from an expert at a fraction of the price? Why Not ?

"Advanced Excel/Tally.ERP9" with Online Access.

It's only available for a limited time.

Get INSANE, CRAZY, & Never Before Offer on Tally.ERP9 / Advanced Excel At just 90% Price of offline training with Unbelievable Bonuses for the limited time of 5 days

we love them

what our Students have to say

What You will Learn

  • Advance Excel
  • Tally.ERRP 9
  • Section 1
  • Section 2
  • Section 3
  1. Excel Start Screen The Ribbon (Customization and Developer Tabs)
  2. Tabs, Groups, Commands, Dialog Box Launcher ,Quick Access Toolbar
  3. File Tab (Backstage View),Excel Options, Views and Zooming, Keyboard Shortcuts
  4. Workbook Windows, Document Inspector, File Formats, Compatibility and Versions
  1. Using auto formatting option for worksheets
  2. Using conditional formatting option for rows, columns and cells
  3. Protecting and un-protecting worksheets
  4. Using slicers with table
  5. Cells Formatting, create and modify table
  1. Naming Cells and Ranges
  2. Use Excel Names, Create a Dynamic Named Range
  3. Use a Named Excel Table, Dynamic Named Range Based on Formula
  1. Relative Reference, Absolute Reference
  2. Using cell references with multiple worksheets
  1. Highlighting Cells Rules
  2. Top/Bottom Rules
  3. Data Bars, Icon Sets, Color Scales
  4. Editing Standard Formatting Rules
  5. Using Formulas in Conditional Formatting
  1. Creating Pivot tables
  2. Formatting and customizing Pivot tables
  3. Using advanced options of Pivot tables
  4. Pivot charts, Creating Slicers
  5. Viewing Subtotal under Pivot
  6. Consolidating data from multiple sheets and files using Pivot tables
  7. Importing Pivot Table Data
  8. Calculated Fields in Pivot Tables
  9. Creating Custom Pivot Tables Styles

 

  1. Filtering data for selected view (AutoFilter)
  2. Using advanced filter options
  1. Sorting table
  2. Using multiple-level sorting
  3. Using custom sorting
  1. Creating subtotals
  2. Multiple-level subtotals
  3. Outlining and Grouping Data
  1. Exploring Scenarios
  2. Goal Seek and Data Tables
  3. Using Solver
  1. VlookUP with Exact Match, Approximate Match
  2. HlookUP with Exact Match, Approximate Match
  3. Nested VlookUP with Exact Match
  4. VlookUP with Tables, Dynamic Ranges
  5. Nested VlookUP with Exact Match
  6. Using VLookUP to consolidate Data from Multiple Sheets
  1. Consolidating data from multiple sheets and files
  2. Using data consolidation feature to consolidate data
  3. command on multiple ranges to calculate sums, averages, products, minimum and maximum values
  1. Text to Columns
  2. Flash Fill
  3. Remove Duplicates
  1. Specifying a valid range of values for a cell
  2. Specifying a list of valid values for a cell
  3. Specifying custom validations based on formula for a cell
  4. drop Down list, prevent duplicates entries, product Codes, Reject invalid dates
  1. Using Charts, Formatting Charts, Using 3D Graphs
  2. Trend lines, Error Bars, Using Bar and Line Chart together
  3. Using Secondary Axis in Graphs
  4. Sharing Charts with PowerPoint / MS Word, Dynamically
  5. (Data Modified in Excel, Chart would automatically get updated)
  1. Creating Sparkline
  2. Editing Sparkline
  1. DATE, TIME, DATEVALUE, TIMEVALUE
  2. Now, Today, Hour, Minute Second
  3. Day, month, year, weeknum, weekday
  4. EDATE, EOMONTH, WORKDAY, WORKDAY.INTL, DAYS, DAYS360
  5. NETWORKDAYS, NETWORKDAYS.INTL, YEARFRAC
  6. PMT function, Dollar Function, CUMIPMT function
  1. And, False, IF, If error
  2. Ifna, Ifs, not, or
  1. Using Error Functions
  2. Using Logical Functions
  3. Using Array Formulas
  4. Using Rounding Functions
  1. average, median, mode, large, max, min
  2. percentile, quartile, rank, small
  3. average if, averageifs, count, correl
  1. CLEAN, trim, lower, proper, upper, concatenate
  2. Left, right, mid, right, rept, text
  3. Len, find, search, exact, t, char, code, replace, substitute
  1. Basics of Accounting
  2. What is bookkeeping
  3. What is account
  4. Rules of Accounting
  5. Introduction to Tally.ERP9
  1. Types of business organization
  2. Features Of Business Organization
  3. Nature Of Business Organization
  1. Company Creation
  2. Ledgers & Groups
  3. Vouchers (Purchase & Sales)
  4. Vouchers (Receipt, Payment)
  5. Vouchers (Contra, Journal)
  1. Stock Items
  2. Stock Category
  3. Stock Group
  4. Godown
  5. Units of Measures
  1. Purchase order
  2. Sale Order
  1. Cost Center
  2. Bank Reconciliation
  3. Point Of Sale
    • Single Payment Mode
    • Multiple Payment Mode
    • Invoice Printing
  4. Debit Note Credit Note
  5. Bill wise Details
  6. Price List
  7. Multiple Currency
  1. Split Financial Year
  2. Import & Export Of Data (In Excel & Other Format)
  1. Financial Statements
  2. (Balance sheet, Profit & loss, Trial Balance)
  3. Statement of Account
  4. Statutory & Taxation Reports
  1. Introduction to tds
  2. Tds process

GST Compliance

    • Introduction to GST
    • Dual GST Concept 
    • ITC mechanism
    • Time of supply
    • Place of supply
    • Integrated Tax Concept 
    • GST on Goods(single rate)
    • GST on Services(single rate)

Advancedexcel-tallyMastery©2019.All Rights Reserved