Technology

How do you know your spreadsheet is right?

You know it’s true: Spreadsheets have errors like dogs have fleas. It is generally accepted that nine out of every ten spreadsheets suffer some error, and consequences can be severe: A cut-and-paste error cost TransAlta $24 million when it underbid an electricity-supply contract. A missing minus sign caused Fidelity’s Magellan Read more…

By Nia, ago
Technology

Excel Power Tips, Techniques, and Shortcuts

Microsoft Excel has a tremendous amount of capability and features and is filled with shortcuts and methods not always visible to the casual user. Whether it’s a keystroke shortcut or a hidden command sequence, such shortcuts can make you much more proficient and productive as you use this powerful and Read more…

By Nia, ago
Technology

Advanced Excel Formulas and Functions

Top 10 Useful Advanced Excel Formulas and Functions Every financial analyst spends more time in Excel than they may care to admit.  Based on years and years of experience, we have compiled the most important and advanced Excel formulas that every world-class financial analyst must know. 1. INDEX MATCH Formula: =INDEX(C3:E9,MATCH(B13,C3:C9,0),MATCH(B14,C3:E3,0)) This Read more…

By Nia, ago
Technology

Mastering Excel PivotTables

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In this page, you can learn about Excel Pivot Tables, How to use them, Examples Pivot Table Reports & More. What is a Pivot Table? Excel Pivot Read more…

By Nia, ago
Human Resource and Payroll

EEO-1 Reporting Requirement

For many years, the Equal Employment Opportunity Commission (EEOC) and the Department of Labour’s Office of Federal Contract Compliance Programs (OFCCP) have collected data from certain private employers and federal contractors and subcontractors about their employees on the “Employer Information Report,” or the EEO-1 Report. The current EEO-1 Report collects Read more…

By Nia, ago
Technology

Excel Pivot Tables

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In this page, you can learn about Excel Pivot Tables, How to use them, Examples Pivot Table Reports & More. What is a Pivot Table? Excel Pivot Read more…

By Nia, ago