There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
Microsoft Excel Business Online Course - English
Complete Microsoft Excel Beginners to advanced online training with a course completion certificate.
Instructor: Letstute
Language: English
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?
- How to use Shortcuts and Important tools in Excel
- Difficult formulas with easy explanations
- How to deal with a large amount of data
- Text, Numbers, Math, Lookup functions, Statistical functions
- Charts, Pivot tables
Who Can Apply?
- Individuals seeking jobs
- College Students
- Working Professionals
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 Shortcuts | |||
| Customising the Quick Access Toolbar | |||
| More Information of the Excel Interface | |||
| Understanding the Structure of Excel | |||
| Saving an Excel Document | |||
| Opening an Existing Excel File | |||
| Common Ctrl Shortcut Keys | |||
| Navigating Excel worksheet with Ctrl Shortcuts | |||
| Import File - How to Save Time with Function Shortcuts | |||
| Section B - Entering Data and Editing Formulas | |||
| Accessing Tools with Alt Keys | |||
| Understanding Important Data Types | |||
| Working with Numeric Data in Excel | |||
| Creating Drop-Down Menus with Data Validation | |||
| Entering Date Value in Excel | |||
| Creating Basic Formulas in Excel | |||
| Working with Cell Reference | |||
| Relative vs Absolute Cell References in Formulas | |||
| Understanding the Order of Operations | |||
| Writing Efficient Formula with Fixed or Relative References | |||
| 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 | |||
| Section D - Printing an Excel Worksheet | |||
| Verifying your Document in Print Preview | |||
| Changing the Margins, Scaling and Orientation | |||
| Working with Page Layout View | |||
| Adding Header and Footer Content | |||
| Printing a Specific Range of Cells | |||
| Section E - Formula and References in Excel | |||
| How to Enter Text and Edit Formulas | |||
| Common Types of Errors in Excel formulas | |||
| Absolute Reference | |||
| Relative Reference | |||
| Mixed Reference | |||
| Use of Functions | |||
| Section F - How to Insert Shapes and Images into Excel Worksheet | |||
| Inserting Images | |||
| Inserting Excel Shapes | |||
| Formatting Excel Shapes | |||
| Working with Excel Smart Art | |||
| Section G - Creating Charts & Graphs in Excel | |||
| Visually Representing Data | |||
| Creating Excel Column Chart | |||
| Working with Excel Chart Ribbon | |||
| Formatting Charts | |||
| Scatter Charts | |||
| Combo Charts | |||
| Pivot Charts | |||
| Pie Charts - How to Use and Application | |||
| Adding and Modifying a Data on Excel Chart | |||
| Section H - Working with Basic Excel Functions | |||
| Structure of Excel Function | |||
| Working with SUM() | |||
| Working with MIN() MAX() Functions | |||
| Working with AVG() | |||
| Working with COUNT() | |||
| Cell Errors in Excel Calculations | |||
| How to use Autosum Command & Shortcut key | |||
| Using Autofill Command to copy Formulas | |||
After successful purchase, this item would be added to your courses.
You can access your courses in the following ways :
Reviews
Other Courses
Launch your Graphy