| Professional Excel |
 |
| Useful Stuff to know |
| Custom designed with relevant examples to kick start your Excel productivity in various jobs. |
Professional Excel
Our Professional Excel series are custom designed with with relevant examples, to kick start your Excel productivity in various professional domains.
 |
 |
 |
 |
| Essential Excel for HR Professionals Backed with relevant HR examples so that you can understand and apply them in your HR work immediately. Duration: 1 day. |
Essential Excel for Accountants Practice essential accounting applications of important Excel functions and features to kick start your productivity. Duration: 1 day. |
Essential Excel for Financial Planners Duration: 1 day. |
Essential Excel for Marketing Managers Packed with practical steps and real life Excel tips for marketing professionals. Duration: 1 day. |
 |
|
|
|
 |
|||
| Essential Excel for Business Owners Provides the quick information you need to master Excel for running your business. Duration: 1 day. |
|||
|
Essential Excel for HR Professionals
|
Handling huge lists of HR information in Excel The most natural information you will deal with are personnel records. You will be shown how to load massive data into Excel, sort and filter this information to make sense of it. Essential Excel functions Being familiar with a useful library of Excel functions allows you to present data backed results to your management. Presenting Summary Reports We will show you how to create a quick summary report from a huge list of records using Excel’s Subtotals, and PivotTables. |
|
| Essential Excel for HR Professionals A quick-start Excel workshop designed for the HR professional. Backed with relevant HR examples so that you can understand and apply them in your HR work immediately. Duration: 1 day. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
Essential Excel for Accountants
|
Important Accounting Excel Functions Use VLOOKUP and Sum Wizard to manage various account codes. Accounting applications of SUMIFS, Text functions, Rounding functions and Array formulas. Build checks & controls to eliminate account errors. Managing Account Data Learn how to import and export accounting data to and from your backend systems. Sort and Filter data to analyse and report accounts. Protect your workbooks and worksheets. Use Data Validations to emilinate account entry errors. |
|
| Essential Excel for Accountants Practice essential accounting applications of important Excel functions and features to kick start your productivity when you return to work. Duration: 1 day. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
Essential Excel for Marketing Managers
|
Be a Marketing Genius with Excel Use Excel to perform competitive analysis, lead tracking, forecasting, manage pricing and more: * Competitive Analysis: Moving from Data to Information. * Presenting and Reporting Your Data. * Build a Marketing Mix. * Trade Shows: Make the Most of them. |
|
| Essential Excel for Marketing Managers Packed with practical steps and real life Excel tips for marketing professionals. Duration: 1 day. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
Essential Excel for Business Owners
|
Goal focused use of Excel Use Excel to monitor: * Profitability. * Delivery schedules * Financial status. Forecast the future Create trendlines in charts. Create business scenarios to forecast the future. Business Reporting Use Pivot Table to report key performance indicators for your business. |
|
| Essential Excel for Business Owners Provides the quick information you need to master Excel for running your business. Duration: 1 day. |
Things to note: Participants should have working knowledge of basic Excel functions, formulas and number formatting. |
|
