Learn to create your first own spread-sheet on Excel with formulas and see how it can simplify your work. This innovative and an interactive course is specially designed for professionals, students and casual users. Take advantage of all Excel's very cool features and capabilities. All this can be learnt at your comfort from home, work or from a cyber café. Training will be facilitated in English, and if required in Hindi as well. Separate sessions can be arranged for those who would like to learn Advance Excel functions. (Post your questions if you have any)

Topics Covered

Excel Level 1: • The Fundamentals of Excel • A quick tour on Excel Basics • Explore different ways of moving around Workbook • Quick Copying Using the Fill Handle (Advance features revealed on this function) • Pasting Using Paste Special • Using the Format Painter (If you already know this, I will show something new on this function) • The Basics of Excel Formulas • Excel Cell References. Relative and Absolute Cell References • Excel Arguments and Syntax in Formulas • Excel AutoSum Function/Formula • Excel Auto Calculate. Calculate Without Formulas • Using Some of Excel's most Common Functions • Using Named Ranges in Excel (Create magic using this function) • Excel Calculations/How Excel Calculates/The Order of Calculations • Sorting Data in Excel • Creating a Basic Spreadsheet • Excel Worksheet Protection • Level 1 – Short Cut Keys to improve fluency using excel

Who should attend

If you feel Excel is complicated, then you must attend this session where you easily learn Excel with some innovative and interactive techniques and see how useful this tool can be to you. Also everyone who uses Excel in their daily life or who has never used Excel in their life before and Everyone who has a passion to learn and know this beautiful tool should attend.

Pre-requisites

This is a online training provided with lot of practical examples to learn and understand every concepts and know their application You will need a Desktop with a good internet connection with skype installed. Just before the session, I will send you a sample workbook which you can use during the training to practice the concepts learnt during the training

What you need to bring

Desktop / Laptop with a good internet connection with skype installed.

Key Takeaways

Understand how Excel works You will learn some important basic functions in Excel and its application. Also learn how you can use these functions in your daily work This training will also build a strong base for you to be prepared for the big picture Take this first step of you getting certified as a Microsoft Office Specialist (MOS) from this training and the trainings to come soon…. Good Luck!!