Who is this course for?
- People who have not used Excel before and have no knowledge of the subject, and now they wish to learn the subject from the ground level up, i.e. zero levels can join this course.
- People who have got some idea about the subject but they are not very clear about the various concepts available in Excel can join this course and start learning the subject afresh.
- Students and working individuals who are into accounts and finance can take up this course to enhance their knowledge of Excel.
- Anyone who wishes to learn something new and exciting can learn Excel Basics from ground level through this course.
What will the students learn in this course?
We start with an introduction to the Excel application to understand what is Excel?, what can you do with Excel? And who can use Excel?, next you familiarize yourself with the basic Excel definitions like what is a Workbook, Worksheet, Rows, Columns, Cells, Excel Functions, Tabbed toolbar and more.
Then we practically start learning step-by-step how to perform about 25+ Excel concepts like how to open Excel application, understanding the Excel application interface, navigating within the worksheet, entering data in the worksheet, save an active workbook, close an active workbook, open a new Excel workbook, open an existing workbook, insert / rename/copy/move / delete Worksheets, selecting a single range of Cells, selecting multiple ranges of Cells, copy, move and delete a range of Cells, insert, delete Rows, Columns, Cells, increase, decrease Column width, increase, decrease Row height, merge/unmerge Cells, wrap text, find, replace text, basic Sorting operation, basic Filtering operation, Format cells, range of cells, generating a series of Number, generating a series of Weekday names, generating a series of Month names, define Excel charts for your datasheets, Print a worksheet and exit Excel Application.
Next, we introduce you to about 50 basic Excel functions under the major categories like math functions, statistical functions, text functions, information functions, logical functions, data functions and lookup & reference functions and teach you step-by-step how to use them.
Is there anything the students need to bring to the class?
While attending the class, you just have a notebook and a pen to note down important notes and observations.