We are Offering 30% Discount for the first 5 participants! Be early enough to reserve slots for you and your team or contact us to for group or corporate reservation
Microsoft Excel is the most commonly used spread sheet application in the world today. However, most users fail to harness the capabilities of this application in improving overall effectiveness. In fact, studies among regular excel users have shown that that at least 8 out of 10 of Excel's most powerful features are never used
MS Excel functions are now so valuable as they provide the tools needed to take full advantage of your data and resources! In Business and Finance, where time can be a vital factor and data analysis reigns, the most adept and efficient Excel User will always get the job done faster and better!
This is a highly interactive and hands-on programme designed to upgrade the skills of participants in Excel and expose them to a range of built-in advanced data processing and modelling tools and techniques that can be used to analyze data quickly and efficiently; maximizing Return on Investment! Participants will learn how to effectively organize, analyze, and summarize your data, and make impressive and powerful presentation of your reports. Course includes case studies and Excel-related challenges which are typically encountered at work.
Participants will be empowered to use tools such as advanced filters, VLookup, Pivot tables, data manipulation and searching, plus automation of tasks using macros. You will be able to design Excel-based templates for data collection, analysis and reporting and automate all manner of work activities/tasks in Excel
We are de-mystifying some of the most challenging of the over 350 functions in Excel.
Who Should Attend?
Anyone with basic knowledge of Microsoft Excel
Course Outline:
- Excel Hotkeys and Shortcuts
- Formatting of Data
- Data Validation Tools
- Analyzing Data with a PivotTable
- Automating Lookup calculations
- Business Projections & Forecasting with Excel
- Analyzing Business Profitability with Excel
- Performing "What-if" analyses
- Consolidating & Summarizing data in multiple worksheets and workbooks
- Presenting & Reporting of Data with Charts and Graphs
- Creating Interactive Reports with PivotTables
- Introduction to Macros
Course is hands-on based on MS EXCEL 2010 & 2013; Participants are expected to come to class with their laptops
Date: Saturday May 14, 2016: 9AM – 6pm
Sunday May 15, 2016: 12pm – 6pm
Venue: ACCELTAGE CONSULTING | 3 Noble Close, Off Ogunnusi Road, Omole, Lagos (Behind Bamboo Plaza by hotel Bus Stop)
Course Fee: N40,000 per participant. Fee covers: Course Materials, E Books, Tuition, Breakfast and Lunch for 2 Days, Certificate of Participation.
30% off for the first 5 participants! So you pay N28,000 instead of N40,000!
Certificate of Participation: Certificate will be awarded to participants at successful completion of all modules.
For Group registrations, Certificate will carry both your company and acceltage Logos
Course can also be handled in house in Clients’ premises.
To Register: Please send mail with your Full Name, Email, Occupation & Phone No. to info@acceltage.com
ENQUIRIES:
You can reach me on: 08022220341, 08033204608 | E: abiodun.adetula@acceltage.com | BB: 7AD48AE4 | Twitter: @acceltage | fb: www.facebook.com/acceltage
