Muhammad Asif

Mastering in Excel Formula & functioning on Dated Oct 17, 2024 Resource Person: Ms. Sumaira Ghouri The first female Microsoft office corporate trainer in Pakistan Certified Microsoft office Specialist (MOS) Master level Certified IT Essential from CISCO. MS(BA), MBA (HRM&MIS), Ma (Eco.) M.Ed. 12 Year of Corporate trainer Experience Course fee Rs. 1500/- 10:00AM to 01:00PM Course Overview: Excel Formulas and functions can greatly enhance your ability to perform tasks in day to day activities in Excel. So, don’twaste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel Formulas and functions to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. This course will cover all main aspects related to Excel Formulas and Functions i.e. implementation, calculation and Errors etc. Course Outcomes: 1. To learn about working with absolute and relative cell referencing, and techniques for copying Formulas. 2. Use to understand the anatomy of Excel functions, and what their components mean. 3. Tolearn to work with Logical, Lookup, Text, Date & Time, Math and Statistical functions. 4. To know the tricks of formula auditing. Course Contenet An Overview Of Formula & Function Unit 2: Operators and Operands Unit 3: Formula References Unit 4: Name Ranges & Name Manager Unit 5: Conditional Logic Unit 6: Lookup & Reference Formulas Course Methodology Multimedia presentation with demonstration discussion Comprehensive Handouts Practical examples on Excel Sheet Group discussions to enable sharing of expertise Videos and future assistance will be provided. Unit 7: Text Formulas and Who is this course for? This Microsoft Excel Forecasting & Data Analysis course is aimed at people who want to expand their knowledge into forecasting and more specialised analytical functionality offered by Microsoft Excel. Unit 8: Date & Time Formulas Unit 9: Math Formulas Unit 10: Statistical Formulas Unit 11: Formula Auditing Unit 12: Formula Errors& Correction Methods For Registration Whatsapp #- Email:-NPO Pakistan Regional office Faisalabad 3rd floor FCCI Complex Building East canal Road Faisalabad Registration Deadline October 16, 2024