5 must have excel skills for Accountants

1
5 Must-Have Excel Skills for Accountants
2
Use of Keyboard Shortcuts
3
Presenting Data with Charts
4
Understand How Cell Referencing Works

• here are four ways you can format your cell
  reference
• Keep row constant and column changeable
• Keep row moveable and column constant
• Keep both row and column constant
• Keep both row and column moveable.

5
Use Pivot Table to Summarize Data
Click this link View Infographic about
Advance excel training in Chandigarh
6
Repeating Last Action Quickly

• The easiest way to repeat the last action is to
  press F4. If you have formatted a cell with
  yellow and you want to format another cell in the
  same way, just press F4 If you have copied
  something and wanted to paste it on multiple
  cells, select them and press F4.

7
Address SCO 23-24-25, Sector 34A Chandigarh, IN
160022 Mail counselor.cbitss_at_gmail.com Phone no-
9914641983 Website http//cbitss.co.in/advance-ex
cel-training-in-chandigarh.html
8
(No Transcript)