GHS (GH₵)
GH₵
Ghanaian cedi
Euro Member Countries
Nigeria Naira
$
United States Dollar

1.1 Exploring excel interface

Lesson 1/93 | Study Time: 8 Min
THOMAS FESTUS CUDJOE

THOMAS FESTUS CUDJOE

Product Designer
4.94
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert

Class Sessions

1- 1.1 Exploring excel interface 2- 1.2 Excel backstage view 3- 2.1 Manage workbooks 4- 2.2 Manage worksheets 5- 2.3 Working rows and columns 6- 2.4 working with cells 7- 3.1 Entering data into cell 8- 3.2 Entering time and multiple values 9- 3.3 Formatting values 10- 3.4 Applying custom formatting 11- 3.5 Auto Fill 12- 3.6 Creating custom list 13- 3.6 Undo and redo 14- 4.1 Introduction to Basic Excel formulas 15- 4.2 Introduction to basic functions 16- 4.3 The IF Function 17- 4.4 Date functions 18- 4.5 Cell referencing - Relative cell reference 19- 4.6 Cell referencing - Absolute cell reference 20- 4.7 Cell referencing - Mixed cell reference 21- 4.8 Using defined names in formulas 22- 4.9 VLookUP and XLookUP 23- 4.10 VLookUP Demo 24- 5.1 Introduction to Excel charts 25- 5.9 Working with recommended charts 26- 5.2 Working with column charts 27- 5.4 Stack column chart 28- 5.3 Clustered column chart 29- 5.5 Bar chart 30- 5.6 Line chart 31- 5.7 Working with Pie chart 32- 5.8 Protips for working with pie charts 33- 6.1 Sort data chronologically 34- 6.2 Sort data alphabetically 35- 6.3 Sort data numerically 36- 6.4 Sort data by color 37- 6.6 Filter data by date 38- 6.8 Filter data by text pattern 39- 6.7 Filter numeric data 40- 6.9 Advanced Filter 41- 6.5 Multi-level sorting 42- 6.10 Freeze panes 43- 6.11 Split window 44- Introduction to the course 45- 4.11 Introduction to Text Functions 46- 4.12 UPPER, LOWER and PROPER Functions 47- 4.13 LEFT, RIGHT and MID Functions + FLASHFILL 48- 4.15 CONCAT and TEXTJOIN Functions 49- 4.17 VSTACK and HSTACK 50- 7.1 Benefits of working with Excel Tables 51- 7.2 Creating an excel table 52- 7.3 Changing table name 53- 7.4 Table Styles 54- 7.5 Sorting Table 55- 7.6 Filtering Table 56- 7.7 Calculated Columns 57- 7.8 Adding Total Row 58- 7.9 Structured Reference 1 59- 7.10 Structured Reference 2 60- 7.11 Structured Reference 3 61- 7.12 Using PivotTables with Tables 62- 7.13 Using Chart with Tables 63- 7.14 Resizing table 64- 7.15 Convert table to range 65- 4.14 Extract Text with TEXTBEFORE, TEXTAFTER 66- 4.16 Using the TRIM and REPT Functions 67- 4.18 TOCOL and TOROW Functions 68- 6.12 Remove duplicates from datasets 69- 6.13 Using the UNIQUE function 70- 6.14 The SORT AND SORTBY Functions 71- 6.15 The FILTER Function 72- 8.1 Using COUNTIFS function 73- 8.2 Using SUMIFS function 74- 8.3 Using AVERAGEIFS function 75- 8.4 Using MINIFS and MAXIFS 76- 1 Dataset Demo 77- 8.5 VLOOKUP vs XLOOKUP - EXACT MATCH 78- 2 Introduction to PivotTables 79- 8.6 VLOOKUP vs XLOOKUP - APPROXIMATE MATCH 80- 3 Navigating the areas of a PivotTable 81- What you need for this course 82- 4 Working with multiple PivotTable Fields 83- 5 Guided project 1 84- 6 Changing default PivotTable name 85- 7 Calculations: Summarize values by options 86- 8 Show Values As: % of Grand Total 87- 9 Show Values As: % of Row Total 88- 10 Show Values As: % of Column Total 89- 11 Showing running totals 90- 12 PivotTable Styles 91- 13 Customize position and layout of PivotTable Fields pane 92- Module Conclusion 93- Conclusion

18 Weeks Business Intelligence and Data Analytics

18 Weeks Business Intelligence and Data Analytics

Learn advanced Excel, Power BI, SQL and AI. Become a Business Intelligence Analyst or Data Analyst.