CAclubindia CCI

Search bar.

bookmark_border
search
person
Login  Register
  • Home
  • grid_view Explore
    • laptop
      CCI Online Learning Learn CA CS CMA
    • work_outline
      CCI Jobs Find/Post your vacancy
    • maps_ugc
      GST Plus Track everything in GST
    • menu_book
      Book Store
  • Online Learning
    Certification Course CA Final New CA Foundation CA Inter CS Executive New CS Professional New CMA Foundation CMA Inter CMA Final CSEET Class 12th Commerce View all courses
    Enrolled courses
  • INCOME TAX
    Articles News Forum Experts Files Notifications Judiciary
  • ACCOUNTANCY
    Articles News Forum Experts Files Notifications
  • CORPORATE LAW
    Articles News Forum Experts Files Notifications Judiciary
  • AUDIT
    Articles News Forum Experts Files Notifications Judiciary
  • GST
    Articles News Forum Experts Files Notifications Judiciary
  • STUDENTS
    Articles News Forum Experts Files Notifications Judiciary
  • Books
  • Jobs
  • GST Plus
  • More expand_more
    • Articles
    • News
    • Experts
    • Files
    • Forum
    • Judiciary
    • Jobs
    • Books
    • Events
    • Notifications
(LIVE) GST Certification Course to commence from 28th May 2022. Call Us: 011-411-70713 Register Now!!
Finology
Finology

  1. Home
  2. Forum
  3. Info Technology

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Dont miss this - Offset function made simple

Gobish Gopalakrishnan

Gobish Gopalakrishnan (Financial Analyst) (276 Points)

20 May 2011  

Check this link to know how to work with the Excel Offset function. 




Reply

Follow

Share

More
  •   Start a discussion
  •   Unanswered
  • Report Abuse

 3 Replies

Santhosh Poojary

Santhosh Poojary (SIEMPRE AHÍ PARA TI) (15597 Points)
Replied 20 May 2011

Thanks for d useful post.

Suresh Prasad

Suresh Prasad (www.aubsp.com) (15580 Points)
Replied 20 May 2011

 

Formula Tips

 

A formula to calculate a ratio

Alternatives to nested IF functions

Automatic list numbering

Avoid error displays in formulas

Calculate the day of the year and days remaining

Calculate the number of days in a month

Calculating a conditional average

Change cell values using Paste Special

Change the formatting of your subtotal rows

Compare ranges by using an array formula

Converting non-numbers to actual values

Count AutoFiltered rows

Counting distinct entries in a range

Creating a "megaformula"

Dealing with negative time values

Delete all input cells, but keep the formulas

Displaying AutoFilter criteria

Force a global recalculation

Hiding your formulas

Identify formulas using Conditional Formatting

Locate phantom links in a workbook

Perform math operations without formulas

Perform two-way table lookups

Referencing a sheet indirectly

Round values to the nearest fraction

Rounding to n significant digits

Sum the largest values in a range

Summing times that exceed 24 hours

Text and values in one cell

Transforming data with formulas

Using Data Validation to check for repeated values

Working with pre-1900 dates

 

CA ADITYA SHARMA

CA ADITYA SHARMA (CA IN PRACTICE ) (16719 Points)
Replied 20 May 2011

thanks for the good post


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Previous Thread
Next Thread

Recent Topics


  • Can director of a company get remunaration as prof
  • Incomes and cash deposits show in it returns
  • Labours provides unregistered person
  • Start ca course again after 10 years (some query p
  • Dissolution of Partnership form online
  • Gst registration services
  • TAX RATE 30%
  • GST rate on Waffle Store/ Bakery
  • Is it possible to edit GST bill for ITC?
  • CLAUSE 34C OF FORM 3CD

More | Post

Related Threads


Loading

Popular Discussion


view more »


Start a New Discussion
Lawsikho

odysseytec
Follow taxation Exam20 Book Book
zoho

Browse by Category


  • Income Tax
  • Audit
  • Students
  • Accounts
  • Custom
  • VAT
  • Career
  • Service Tax
  • Corporate Law
  • Info Technology
  • Excise
  • Shares & Stock
  • Exams
  • LAW
  • Professional Resource
  • Others
  • Taxpayers
  • GST




Subscribe to the latest topics :

Search Forum:

Forum Home
Popular Threads
Recent Posts
Unreplied Threads
Post New Topic
Settings

  • Articles
  • Forum
  • Career
  • Jobs
  • Judiciary
  • Income Tax
  • News
  • Experts
  • Budget
  • Feed
  • Top Members
  • Rewards
  • GST
  • Scorecard
  • Poll
  • Share Files
  • Bookmarks
  • Events
  • Trainee Corner
  • Notification
  • Tags
  • Books
  • CCI Online Learning

Member Strength 36,40,768 and growing..

Get latest updates


Download CCI APP

CCI Android App 


Our Network Sites

lawyersclubindia GccFintax
  • About
  • We are Hiring
  • Media Coverage
  • Advertise
  • Terms of Service
  • Disclaimer
  • Privacy Policy
  • Contact Us
© 2022 CAclubindia.com. India's largest network for Finance Professionals.

  • twitter
  • facebook
  • instagram
  • linkedin
  • youtube
  • whatsapp

CCI Menu

  • CCI Online Learning
  • Enrolled Courses

  • GST Plus
  • Books
  • Articles
  • News & Updates
  • Forum
  • Share Files
  • Experts
  • Notifications & Circulars
  • Judiciary
  • Tags
  • Budget 2022
  • GST
  • Income Tax
  • Accountancy
  • Corporate Law
  • Audit
  • Students
  • Jobs
  • Events
  • Bookmarks
  • Feed
  • Featured
  • Top Members
  • Rewards
  • Scorecard

Login at CAclubindia

cciCAclubindia

India's largest network for
finance professionals



login
Forgot Password ?

Alternatively, you can log in using:

Login with Facebook
Login with Google

Don't have an account? Register Now

click here to register

Site Search

Share
 Facebook
 Twitter
 Linkedin
 Reddit
 Email
 Whatsapp
 Gmail
 Google
 Pocket
 Print
 Pinterest
 PDF
 Translate
Whatsapp Groups
CAclubindia
CA Inter
CA Final
CA Foundation
CS
Income Tax
GST
Webinar