We will cover following in each class:
1. Fundamentals of excel : 30-40 min
2. Self doing assignment : 10 min
3. One Practical Problem Solving : 10-20 min
Following topics we will cover in the course:
| S.No. | Description |
| 1 | About Excel |
| 2 | Excel Environment |
| 3 | Entering Text |
| 4 | Working with Numeric Data in Excel |
| 5 | Entering Date Values in Excel |
| 6 | Renaming an Excel Worksheet |
| 7 | Deleting an Excel Worksheet |
| 8 | Introduction to Data |
| 9 | Working with Cell References |
| 10 | Relative Versus Absolute Cell References in Formulas |
| 11 | Creating Basic Formulas in Excel |
| 12 | Understanding the Order of Operation |
| 13 | Working with the SUM() Function |
| 14 | Working with the MIN() and MAX() Functions |
| 15 | Working with the AVERAGE() Function |
| 16 | Working with the COUNT() Function |
| 17 | Working with the SUMPRODUCT() Function |
| 18 | Using the AutoFill Command to Copy Formulas |
| 19 | Moving and Copying Data in an Excel Worksheet |
| 20 | Inserting and Deleting Rows and Columns |
| 21 | Changing the Width and Height of Cells |
| 22 | Hiding and Unhiding Excel Rows and Columns |
| 23 | Moving and Copying an Excel Worksheet |
| 24 | Paste Special |
| 25 | Working with Font Formatting Commands |
| 26 | Changing the Background Color of a Cell |
| 27 | Adding Borders to Cells |
| 28 | Excel Cell Borders Continued |
| 29 | Formatting Data as Currency Values |
| 30 | Formatting Percentages |
| 31 | Using Excel's Format Painter |
| 32 | Creating Styles to Format Data |
| 33 | Merging and Centering Cells |
| 34 | Using Conditional Formatting |
| 35 | Editing Excel Conditional Formatting |
| 36 | Inserting Images |
| 37 | Inserting Excel Shapes |
| 38 | Formatting Excel Shapes |
| 39 | Working with Excel SmartArt |
| 40 | Creating an Excel Column Chart |
| 41 | Adding and Modifying Data on an Excel Chart |
| 42 | Moving a Chart to another Worksheet |
| 43 | Working with Excel Pie Charts |
| 44 | Viewing your Document in Print Preview |
| 45 | Changing the Margins, Scaling and Orientation |
| 46 | Excel Worksheet Margins |
| 47 | Working with Page Layout View |
| 48 | Adding Header and Footer Content |
| 49 | Printing a Specific Range of Cells |
| 50 | Opening an Existing Template |
| 51 | Creating a Custom Template |
| 52 | Sorting a List Using Single Level Sort |
| 53 | Sorting a List Using Multi-Level Sorts |
| 54 | Using Custom Sorts in an Excel List |
| 55 | Filter & Advanced Filter |
| 56 | Creating Subtotals in a List |
| 57 | Format a List as a Table |
| 58 | Removing Duplicates |
| 59 | Text to Column |
| 60 | Excel Formulas | Logical |
| 61 | Excel Formulas | Date Time |
| 62 | Excel Formulas | Lookup & Reference |
| 63 | Excel Formulas | Financial |
| 64 | Excel Formulas | Others |
| 65 | Creating an Excel Data Validation List |
| 66 | Adding a Custom Excel Data Validation Error |
| 67 | Dynamic Formulas by Using Excel Data Validation Techniques |
| 68 | Importing Data Into Microsoft Excel |
| 69 | Importing Data from Text Files |
| 70 | Exporting Data to a Text File |
| 71 | Creating an Excel PivotTable |
| 72 | Modifying Excel PivotTable Calculations |
| 73 | Formatting PivotTable Data |
| 74 | Modifying PivotTable Calculations |
| 75 | Drilling Down into PivotTable Data |
| 76 | Creating PivotCharts |
| 77 | Filtering PivotTable Data |
| 78 | Filtering with the Slicer Tool |
| 79 | Data Transformation |
| 80 | Using the Freeze Panes Tool |
| 81 | Grouping Data (Columns and/or Rows) |
| 82 | Linking Worksheets (3D Formulas) |
| 83 | Consolidating Data from Multiple Worksheets |
| 84 | Working with Excel Name Ranges |
| 85 | Formulas with a Name Range |
| 86 | Nesting Functions with Excel |
| 87 | Nesting Excels AND() Function within the IF() Function |
| 88 | Microsoft Excel Formulas Combinations |
| 89 | Tracing Precedents in Excel Formulas |
| 90 | Tracing Dependents in Excel Formulas |
| 91 | Working with the Watch Window |
| 92 | Showing Formulas |
| 93 | Protecting Specific Cells in a Worksheet |
| 94 | Protecting the Structure of a Workbook |
| 95 | Adding a Workbook Password |
| 96 | Working with Excel's Goal Seek Tool |
| 97 | Working with Excel's Solver Tool |
| 98 | Understanding Excel Macros |
| 99 | Activating the Developer Tab in Excel |
| 100 | Creating a Macro with the Macro Recorder |
| 101 | Editing a Macro with VBA |
| 102 | Creating Buttons to Run Macros |
| 103 | Running a Microsoft Excel Macro |
| 104 | Adding the Excel Macro to the Quick Access Toolbar |
| 105 | Save a Workbook with a Macro/VBA Code |
| 106 | Excel VBA MSGBOX Function |
| 107 | Expanding the IF Logic with Multiple ElseIf Statements |
| 108 | Working with an Excel VBA Do While Loop |
| 109 | Working with an Excel VBA For Each Loop |
| 110 | Working with an Excel VBA For Next Loop |
| 111 | Continue Excel VBA InputBox |
| 112 | Working with the ScreenUpdating Property |
| 113 | Go to Special |
| 114 | Customizing the Excel Quick Access Toolbar |
| 115 | Common Excel Shortcut Keys |
| 116 | Errors in Excel Calculations |
| 117 | DATEDIF |
| 118 | Excel New Functions: Filter, Unique, Sortby |
| 119 | Custom Views |
| 120 | Excel Tabs | Home |
| 121 | Excel Tabs | Insert |
| 122 | Excel Tabs | Page Layout |
| 123 | Excel Tabs | Formulas |
| 124 | Excel Tabs | Data |
| 125 | Excel Tabs | Review |
| 126 | Excel Tabs | View |
| 127 | Excel Tabs | Others - Table Design / Shape Design / Pivot / Developer |
| 128 | Bonus Files / Query Session & Discussion / Cerfification |
View this Course
Top Tutor
Certified
You have successfully registered
