# Excel tips for Accountants

### Resume excel session with Save workspaces feature

In accounting world some work is repetitive and accountants have to open certain set of files almost on daily basis. Opening each file by reaching the location and double clicking might not be that...

### Making Profit and Loss Statements in Excel using Pivot tables

Being an accountant myself trust me I hate numbers and all that journals and "T" accounts. But its necessary to get to much meaningful financial statements like Statement of Financial Position (Balance sheet) and Profit...

### Using SUMIF function with Dates in Excel

I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially accountants. In many instances SUMIF can be used as an...

### Excel Pivot Tables – Grouping Dates by Week Within Months, Quarters or Years –...

Earlier we learned about grouping and ungrouping time related information very easily using excel pivot tables. It saves huge amount of time in preparing summary pivot table reports with different dimensions of time. However, we...

### Remove leading Apostrophe (‘) in Excel Data from Numbers and Text – How To

This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business...

### Payroll Calculation in Excel – Differential Piecework with Multiple Scales – How To

This Excel tutorial is part of: Payroll calculator with Piece Work wage payments in Excel - How to To access complete list of payroll calculation tutorials for piece work wage system visit this page. Differential piece work...

### Payroll calculation in Excel – Straight Piecework Wage System – How To

This Excel tutorial is part of: Payroll calculator with Piece Work wage payments in Excel - How to Series To access complete list of payroll calculation tutorials for piece work wage system visit this page. Straight Piecework Wage...

### Excel Pivot Tables – Grouping Data by Date and Time

Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for...

### How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency...

In almost every office of the world when it comes to money accountants come to excel. Although excel can handle money matters but when it comes to currency by default we have Dollar (\$)...

### Building a reference to specific Worksheet based on Cell value using Formula

Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more...