Description
In this course, you will learn :
- Microsoft Excel can be learned from beginner to advanced levels.
- One can gain a solid understanding of the fundamentals of Microsoft Excel.
- The most common Excel functions used in the office can be learned.
- Keep large amounts of Excel data in a list or table.
Syllabus :
1. Microsoft Excel Fundamentals
- Launching Excel
- Introduction to the Excel interface
- Saving Excel File
- Important File Types
- Opening an existing excel document
- Adding, Modifying and deleting data in cells
- Creating and naming of new worksheet
- Common Excel Short Cut Keys
2. Editing Text and Formulas
- Add / Subtract/ Multiply / Divide
- Use of Cut & Paste using Cells
3. Modify of Excel Worksheet
- Moving and Copying Data in an Excel Worksheet
- Inserting Rows and Columns
- Deleting an Excel Worksheet
4. Introduction to Charts
-
The easy way of creating chart
5. Important charts and Best Practices
- Bar and Column Chart
- Formatting Charts
- Line Charts
- Area Charts
- Pie and Doughnut Charts
- Scatter or Bubble Chart
6. Printing an excel Worksheet
- Viewing your Document in Print Preview
- Working with Page Layout View
- Printing a Specific Range of Cells
7. PIVOT Tables from Basic To Pro
- Lets Jump into this
- Some More on Pivot tables
- About Number Format - All At Once
- Use of FIlters and Column box
- Removing Grand Totals
- Extract of report details in to separate table
- Adding Percentage summary
- Displaying null rows
- Best Top 10 option and Sorting
- Playing with dates - Grouping and Ungrouping