ICT | Graphic& Web Design| SPSS | 3D Animation |QuickBooks| Tally | Sage | SAP Business One | AutoCAD | Computer Training
   
0722838044
  ==================================================================================
====================================================================================

 

Spreadsheet Using Microsoft Excel

Microsoft Excel was first released in 1985 and it is still one of the most widely used and comprehensive spreadsheet programs today. Thanks to its functionality, Excel provides a variety of organizations and users simplified data solutions including, basic calculations, advanced data analysis, and data visualization. Having any skill level in this program is truly beneficial because Excel proficiency is in high demand by employers. And now users can leverage business intelligence tools within Excel to easily manipulate and combine data from multiple touchpoints.

With real-world experience, our Excel instructors ensure that lessons and course materials are applicable for job responsibilities. We offer courses for all levels of Excel users. Learning Excel will let you increase productivity and speed up daily tasks. Our Excel curriculum includes courses in which you could learn:

  • Excel basics, formulas, charts and database features
  • Excel data visualizations for advanced data and trend analysis
  • Excel for business intelligence (BI) forecasting and reporting
  • Basic formulas
  • Pivot Tables Charts
  • VLOOKUP
  • HLOOKUP
  • INDEX
  • MATCH
  • Macros
  • Programming with VBA
  • Workbooks
  • Business Intelligence (BI) tools
Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced feature allow you to access huge data sets within Excel.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Computerized Accounting

 

ICT

Graphic Design

Technical

 

 

 

 

 

     

Class Timings

Monday – Friday: 07:00AM – 08:00PM
Saturday: 08:00AM – 01:00PM
Sunday: Closed

About Montech

As one of Kenya's leading tertiary education providers, Montech offers a personalised experience enhanced by world-class programs and innovative digital engagement. We lead by creating opportunities to live and work in a connected, evolving world.

 

Copyright © Montech Training Centre. All rights reserved