1Chapter 1: Microsoft Excel Basics
605.8 Changing Chart Layout
21.1 What is Microsoft Excel?
615.9 Switching Rows & Columns in Chart
31.2 Why Should you Learn Microsoft Excel?
625.10 Resizing a Chart
41.3 Opening Microsoft Excel
63Chapter 6: Excel Mathematical Functions
51.4 Closing Microsoft Excel
646.1 Mathematical Function
61.5 Saving the document
656.2 Sum Function
71.6 Microsoft Excel uses
666.3 SUMIF Function
81.7 Terminologies of Excel
676.4 The Role of SUMIFs
91.8 Microsoft Excel components
686.5 MOD Function
10Chapter 2: Designing Workbooks using Excel
696.6 The RANDBETWEEN Function
112.1 Rename Worksheet
706.7 Round Function
122.2 Insert A New Worksheet
716.8 ROUNDDOWN Function
132.3 Delete Worksheet
72Chapter 7: Excel Financial Functions
142.4 Copy Worksheet
737.1 PV Function
152.5 Move Worksheet
747.2 FV Function
162.6 Change Worksheet Tab Color
757.3 NPV Function
172.7 Switching Between Worksheets
767.4 SYD Function
182.8 Grouping and Ungrouping Worksheets
77Chapter 8: Excel Logical Functions
192.9 Page Layout View
788.1 IF Function
20Chapter 3: Data Management in Excel
798.2 IFERROR Function
213.1 Editing Data
808.3 AND Function
223.2 Remove Data
818.4 OR Function
233.3 Cell Content Copy Pasting
82Chapter 9: Excel Statistical Functions
243.4 Cell Drop and Drag
839.1 COUNT Function
253.5 Use of Fill Handle
849.2 COUNTIF Function
263.6 Adjusting Columns and Rows
859.3 Average Function
273.7 Cell Formatting
86Chapter 10: Excel Text Functions & Lookup Reference
283.8 Conditional Formatting
8710.1 VLOOKUP Function
293.9 Cell Merging and Text Wrapping
8810.2 HLOOKUP Function
303.10 Hiding Columns and Rows
8910.3 XLOOKUP Function
313.11 Adding new rows and column
9010.4 TRANSPOSE Function
323.12 Removing Columns and Rows
9110.5 TRIM Function
333.13 Transpose (rotate) data from rows to columns or vice versa
9210.6 TEXTJOIN Function
343.14 Data validation of cells
9310.7 PROPER Function
353.15 Flash Fill in Excel
9410.8 LOWER Function
363.16 Quick Analysis Tool in Microsoft Excel
95Chapter 11: Some Additional Features of Excel
37Chapter 4: Date Sorting (Data Organizing)
9611.1 Excel Power View
384.1 How to Sort in Excel
9711.2 Excel Shortcuts
394.2 Highlight the Rows and Columns You Want to Be Sorted
98Chapter 12: What Are the Most Desired Excel Abilities for a Job?
404.3 Navigate Toward 'Data' Along the Top & Select 'Sort'
9912.1 Knowledge of Advanced Excel Functions
414.4 If You Are Sorting by The Column, Select That Column You Wish to Order the Sheet
10012.2 Placement of Various Functions
424.5 If You Are Sorting by The Row, Click The ''Options'' Icon & Select The ''Sort Left to Right'' Icon
10112.3 Separation of Data and Corresponding Entries
434.6 Choose What You'd Like Sorted
10212.4 Making Use of Appropriate Data Validation Methods
444.7 Choose How You'd Like to Order Your Sheet
10312.5 Data Breakdown Provided
454.8 To Sort by Number
10412.6 Mastery of the Command Line
464.9 Click ''Ok''
10512.7 Completeness of Information Formatting
474.10 How to Alphabetize in Excel?
10612.8 Informative Data about Excel's Primitive Formulas and Calculations
484.11 Sorting Multiple Columns
10712.9 Display Formatting Options That Do Their Job
494.12 Sorting in Custom Order
10812.10 Acquaintance with Related Roles
504.13 Sorting A Row
109Chapter 13: High Salary Jobs with Excel Skills
514.14 Sort Your Conditional Formatting
11013.1 MIS Executive
52Chapter 5: Tables and Charts in Excel
11113.2 Project Coordinator or manager
535.1 What is an Excel Table?
11213.3 Market Research Analysis
545.2 Making Pivot Table and Charts
11313.4 Retail Store manager
555.3 Working with Charts
11413.5 Business Analysts
565.4 Types of Excel Charts
11513.6 Data Journalists
575.5 How to Insert Chart in Excel?
11613.7 Financial Analysts
585.6 Changing Chart Type in Excel
117Conclusion
595.7 Change Style of Chart in Excel
118Bonus Materials
