Enrolled Learners: 235
Validity Period: 31 days
This MS Excel course is designed under the expert knowledge of a known expert CA Santosh Apraj. All this was done with the use of the latest Office 365 and updated MS Excel software program on windows. Through this course, you will acquire the complete knowledge of Excel Fundamentals along with the necessary formulas and functions.
What Will You Be Learning?
Who Can Apply?
Our goal through this course is to ease the explanation and put down difficult formulae with easy explanations which could help you in your daily life. To make this course an interesting one, we have some Q&As after each session so that you can test your knowledge and skills as well!
|Section A - Introduction to MS Excel|
|Launching Excel: Startup Screen and User Interface, Different versions of Excel|
|Microsoft Excel Startup Screen|
|Introduction to Excel Interface_ Basic Shortcut|
|Customizing the quick access toolbar|
|More information of the Excel interface|
|Understanding the Structure of Excel workbook|
|Saving an excel document|
|Opening an Existing Excel file|
|Common Shortcut keys to use in Excel|
|Navigating Excel worksheet with Ctrl Shortcuts|
|How to save time with Function Shortcuts|
|Accessing Tools with Alt Keys|
|Introduction to MS Excel - Quiz|
|Section B - Entering Data and Editing Formulas|
|Entering Text to Create Spreadsheet Titles|
|Working with Numeric Data in Excel|
|Creating Drop-Down Menus with Data Validation|
|Entering Date Value in Excel|
|Working with Cell Reference|
|Creating Basic Formulas in Excel|
|Relative vs Absolute Cell References in Formulas|
|Understanding the Order of Operations|
|Writing Efficient formula with Fixed or Relative References|
|Entering Data and Editing Formulas (Nine Quiz)|
|Section C -Modifying an Excel Worksheet|
|Moving and Copying Data in an Excel Worksheet|
|Inserting and Deleting Rows and Columns|
|Changing the Width and Height of Cells|
|Hiding and Unhiding Excel Rows and Columns|
|Renaming and Deleting an Excel Worksheet|
|Moving and Copying an Excel Worksheet|
|Modifying an Excel Worksheet Quiz|
After successful purchase, this item would be added to your courses.
You can access your courses in the following ways :