We are in process of building the inventory of good professionals in this categoryGot it!
Connect With Rashmi
You have reached a limit!
We only allow 20 Tutor contacts under a category. Please send us an email at email@example.com for contacting more Tutors.
Further Information Received
Thank you for providing more information about your requirement. You will hear back soon from the trainer
Sarjapur Road, Bangalore
******************************************** Learn From Industry Expert. If you want to excel in MS-Excel, then you should know Formula and Functions are basic building block to MS-Excel. In this training session, I am going to cover, how you can improve work performance by using numerous formulas and functions in MS- Excel. How to use formula with other formulas? What component can be replaced with other components? How to write formulas to avoid error? Evaluation of formula. And 20 MOST IMPORTANT SHORTCUT KEYS IN EXCEL 2007 and EXCEL 2010. NOTE: Excel Training is all about hands-on session. Guided learning. Practice Exercises. Post Training Support. Don't hesitate to clear your queries.
Module 1: Overview of the Basics Difference between Excel 2003 and Excel 2007 Screen Interacting with Excel(2007) screen Special feature in MS-Excel that can help you excel. Module 2: Cell Reference and its usage in formulas Absolute and Relative and Mixed cells reference Preferred References in Formula Module 3 A: Working with Functions Writing conditional expressions (using IF, NESTED IF) Using logical functions (AND, OR, NOT, COMPOUND IF) Other Functions: Date and time functions: Date Today Now Day Month Year Time Hour Minute Second Weekday DateDif Networkdays WORKDAY Text Functions: Upper Lower Proper Left Right Mid Concatenate Len Exact Search Find Clean Replace Substitute Char Code Dollar T TEXT Database functions: DAVERAGE DSUM DCOUNT DCOUNTA DGET DMAX DMIN Mathematical Functions: Abs Int Mod Sqrt Power Round Trunc Fixed Sum Sumif Count Statistical Functions CountA Countblank Min Max Small Large Information Functions IsBlank IsError Isnumber Istext VLOOKUP, HLOOKUP, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH Module 3 B: Evaluation of Formula Understanding Formula Evaluation concept Using "Evaluate Formula" Module 4: Handling Errors Types of Error Ways of handling Errors Module 5: 20 Shortcut keys combination for professionals
Management Professional BPO/KPO employee HR, MIS personnel Business person Commerce field, Would be C.A. Sales/HR.
Knowledge to manage your data. Knowledge specific to Business Solution no matter which field you are in.
Recommendations & reviews from previous Customers:
Not decided yet.
MS in Information Technology, MS-BI
Students Interested 1
Batches conducted 12
Total Students 29