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

Outlook On Steroids 2.0: Tips and Tricks to Make Outlook a Time Management Tool

Learn Microsoft Outlook features that Could Reduce Your Work-Time and Boost Productivity If you have Microsoft Outlook installed on your computer, you have an amazing time-management tool at your fingertips. Unfortunately, many folks use Outlook for their primary email client without ever realizing its full, efficiency-enhancing potential. Recent studies have 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