4G Accounts
Its All About Knowledge
  • Home
  • Accounting & Finance
  • Education
  • Microsoft Excel
  • General
  • Privacy Policy
092011_1930_AnatomyofRi1.png

Anatomy of Ribbon and its user interface in Microsoft office 2010

For those people who use to work with MS office 2003 , Ribbon in excel 2010 is a new and distinctive feature, Microsoft has vanished the standard tool bar which you can see in previous version and tools of office like in MS Excel 2003, Ms word 2003, Ms access 2003 and In MS power […]

Effect of Depreciation Business functions

Cash flow—if it is used for tax purposes then declining-balance (DB) method is proffered because early tax deduction provides better result than later tax deduction. Under DB depreciation expense method Highest depreciation is deducted; therefore, lower taxable income is yield, that’s why lower income tax payable (and lower cash outflow) in

Window Shortcuts

1. Windows key+M: This keystroke combination will instantly minimize all open windows. (Note:This shortcut differs slightly from Show Desktop. While both options will minimize all open Windows, Show Desktop allows you to maximize all Windows as a group, whereas Windows minimized using Windows key+M must be maximized individually.)

How to Freeze Pane or cell in Excel

when you are using Excel it is some time required to Keep some data always visible on top , especially when table is very large and you need to keep the header visible when browsing the lower rows of  table , the solution to this problem is to freeze the pane and this is how you can […]

How to Delete or Hide an excel column using a formula?

I was once challenged to tell a formula which can hide or delete the excel coulomb, depends on the calculation , …. for you information Dum people usually asked such question while inferring the other , so there is very simple answer to this question

How to transfer and view MS-word, excel and power-point files iPhone

This is general question asked that how to transfer MS office files to iphon and how to view them easily, there are many ways to answer this question but the most simple way is ,

070611_1930_HowtoFormat1.jpg

How to Format Multilevel outline in few Clicks

We all use multilevel outline lists in word, some time we spend too much time to format various level in list its very hectic and tedious process, there is as easy way to do it in Word 2007 and Word 2010 and option is Smartart Vertical Box List , from this option you can format […]

070411_1653_PrintMicros1.jpg

Print Microsoft Excel Spread Sheet just on one page

While printing in excel there is easy way to ensure that you work sheet prints out as wide as possible but it should fit to one page in excel 2003 it is bit traditional while in 2007 it’s inbuilt function

062811_2226_EasywaytoPu1.png

Easy way to Put Paragraph in Excel

When producing working papers or financial statements it difficult to put long statements in Excel as Excel doesn’t give the option to word wrap or justification or other features that are available in Ms-Word , different solutions such as Excel’s Justify command, and pasting from Word is available but all these are not enough.

remove dubicate

How to remove Duplicate date in Excel

Lot of data base work done by accountant is done by using Excel , in last decade Excel in one of the most powerful tools used by accountant it helps them analyzing the huge data with single clicks or few basic formulas. Today I am going to tell you how to remove duplicates while analyzing,

«< 3 4 5 6 7 >»

Newsletter

Recent Posts

  • 3890B565CDetailed Excel Keyboard Shortcut Cheatsheets
  • print-1Customize your Excel Sheets for Printing
  • Increment cell values in excel5 Ways to Increment the Cell Values in Excel
  • func-vlookup6 Ways to Search Data in Excel
  • DAverage Function in Excel 2013Handy Database Functions in Excel 2013

↑

© 4G Accounts 2023