Master Excel - Complete Tutorial Labs Course

Paul Browning via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Duration & workload

11 hours 40 minutes
Sessions

On-Demand
Level

Beginner

Found in

Master Microsoft Excel through comprehensive hands-on tutorial labs covering everything from basic navigation to advanced data analysis techniques. Learn to import data from various sources including text files and online databases, navigate efficiently using named cells and ranges, and manage hyperlinks within workbooks. Develop proficiency in page setup modifications, row and column adjustments, and header/footer customization while mastering worksheet display options and Quick Access Toolbar management. Practice freezing rows and columns, changing window views, and configuring workbook properties for optimal organization. Explore advanced data manipulation techniques including special paste options, Auto Fill functionality, and cell merging while applying professional formatting using Format Painter, number formats, and cell styles. Discover conditional formatting strategies, sparkline creation, and named range implementation for enhanced data visualization. Build expertise in table creation and management, including applying table styles, filtering records, and sorting data using both traditional methods and the SORT function. Master essential Excel functions including IF statements, counting functions, and text manipulation using RIGHT, LEFT, and MID functions while learning to extract unique values from datasets. Develop chart creation skills across multiple chart types, learn to add data series, switch between row and column orientations, and customize chart elements, layouts, and styles for professional presentations. Gain practical experience through 101 structured lab exercises designed to build real-world Excel proficiency suitable for students, professionals, and anyone seeking to excel in data analysis and spreadsheet management.

Syllabus

0:00 1 Getting Access to Microsoft Excel
8:25 2 Import Data From Text Files
17:19 3 Import Data From Online Sources
27:19 4 Search For Data Within A Workbook
34:43 5 Navigate To Named Cells, Ranges, Or Workbook Elements 1
41:42 6 Navigate To Named Cells, Ranges, Or Workbook Elements 2
49:58 7 Insert And Remove Hyperlinks
1:02:23 8 Modify Page Setup 1
1:14:05 9 Modify Page Setup 2
1:22:08 10 Modify Page Setup Part C
1:30:08 11 Adjust Row Height And Column Width
1:40:07 12 Customize Headers And Footers 1
1:50:24 13 Customize Headers And Footers 2
1:57:42 14 Customize Options And Views 1
2:04:49 15 Customize Options And Views 2
2:12:43 16 Manage The Quick Access Toolbar 1
2:17:48 17 Manage The Quick Access Toolbar 2
2:24:24 18 Display And Modify Worksheets 1
2:30:29 19 Display And Modify Worksheets 2
2:37:28 20 Freeze Worksheet Rows And Columns
2:43:58 21 Change Window Views
2:53:27 22 Modify BuiltIn Workbook Properties 1
3:01:57 23 Modify BuiltIn Workbook Properties 2
3:07:28 24 Modify BuiltIn Workbook Properties 3
3:17:01 25 Display Formulas
3:22:55 26 Set A Print Area
3:28:38 27 Save And Export Workbooks In Alternative File Formats
3:33:40 28 Configure Print Settings
3:43:09 29 Inspect Workbooks And Correct Issues
3:52:17 30 Manage Comments And Notes
4:00:56 31 Paste Data by Using Special Paste Options 1
4:06:15 32 Paste Data by Using Special Paste Options 2
4:12:17 33 Paste Data by Using Special Paste Options 3
4:18:43 34 Fill cells by using Auto Fill
4:25:41 35 Insert and delete multiple columns or rows
4:31:06 36 Insert and delete cells
4:35:54 37 Generate Numeric Data by Using RANDBETWEEN and SEQUENCE Part A
4:42:09 38 Generate Numeric Data by Using RANDBETWEEN and SEQUENCE Part B
4:49:43 39 Merge and Unmerge Cells
4:56:10 40 Modify Cell Alignment, Orientation, and Indentation
5:04:58 41 Format Cells by Using Format Painter
5:11:42 42 Wrap Text Within Cells
5:17:15 43 Apply Number Formats 1
5:24:15 44 Apply Number Formats 2
5:31:38 45 Apply Cell Formats From the Format Cells Dialog Box
5:40:52 46 Apply Cell Styles 1
5:48:21 47 Apply Cell Styles 2
5:56:19 48 Clear Cell Formatting
6:03:02 49 Format Multiple Worksheets by Grouping
6:09:15 50 Define a Named Range
6:14:56 51 Reference a Named Range
6:20:16 52 Insert Sparklines Part A
6:26:12 53 Insert Sparklines Part B
6:35:09 54 Conditional Formatting 1
6:48:19 55 Conditional Formatting 2
6:56:15 56 Conditional Formatting 3
7:01:30 57 Conditional Formatting 4
7:08:51 58 Apply Builtin Conditional Formatting 5
7:17:33 59 Remove Conditional Formatting 1
7:22:52 60 Remove Conditional Formatting 2
7:27:43 61 Create Tables From Cell Ranges 1
7:33:31 62 Create Tables From Cell Ranges 2
7:39:48 63 Apply Table Styles 1
7:44:52 64 Apply Table Styles 2
7:50:30 65 Convert Tables
7:54:47 66 Table Rows And Columns
8:01:02 67 Table Style Options
8:06:10 68 Total Rows
8:10:44 69 Filter Records
8:16:51 70 Sort Data
8:21:36 71 Insert References 1
8:28:59 72 Insert References 2
8:35:45 73 Use Structured References In Formulas 1
8:42:13 74 Use Structured References In Formulas 2
8:48:06 75 Perform Calculations By Using Functions 1
8:55:01 76 Perform Calculations By Using Functions 2
9:01:14 77 Count Cells 1
9:07:40 78 Count Cells 2
9:14:28 79 If Function 1
9:23:15 80 If Function 2
9:32:39 81 Sort Data By Using The Sort Function
9:40:06 82 Get Unique Values
9:46:19 83 Format Text By Using Right, Left, And Mid Functions
9:54:09 84 Format Text By Using Functions 1
9:59:00 85 Format Text By Using Functions 2
10:03:58 86 Format Text By Using Functions 3
10:09:11 87 Charts 1
10:15:59 88 Charts 2
10:24:13 89 Chart Sheets
10:29:15 90 Add Data Series To Charts
10:35:33 91 Switch Between Rows And Columns
10:41:06 92 Chart Elements 1
10:47:25 93 Chart Elements 2
10:54:01 94 Chart Elements 3
11:00:37 95 Chart Layouts 1
11:06:05 96 Chart Layouts 2
11:11:29 97 Chart Layouts 3
11:16:52 98 Chart Styles 1
11:22:08 99 Chart Styles 2
11:27:13 100 Chart Styles 3
11:33:02 101 Charts For Accessibility