Masterclass Microsoft Excel. 9 hours of video lessons to learn everything about Excel

We have gathered all the Excel syllabus in a Masterclass that will meet your needs. *If you do not have enough experience* in using Excel, we recommend that you watch the course from the beginning. *Lessons progress gradually* and introduce you to increasingly complex functionality. If you are an *experienced* user looking for something extra, then we suggest you navigate to the video *by directly selecting the chapter you are interested in* from the description. PayPal Donate LEARN IT by TEST4U https://paypal.me/test4ueu?country.x=GR&locale.x=en_US 00:00:00 Introduction 00:02:28 What is Microsoft Excel 00:09:48 Creating and Saving an Excel Workbook 00:13:12 Opening, Closing and Navigating an Excel Workbook 00:16:14 The ribbon 00:27:13 Selecting Microsoft Excel Cells 00:32:42 Insert, Edit, Cut, Copy, Paste, Move and Delete Microsoft Excel Cells 00:40:00 Managing Microsoft Excel's Columns and Rows 00:43:11 Insert, Delete, Move and Copy Excel Worksheets 00:50:29 Splitting Microsoft Excel's Worksheets 00:53:45 Freezing Microsoft Excel's Columns and Rows 00:57:32 Changing Width and Height of Microsoft Excel's Rows and Columns 01:00:43 Import Data into Microsoft Excel's Workbooks 01:07:35 Find and Replace data within an Excel Workbook 01:09:59 Worksheet Views 01:16:05 Page Setup 01:23:40 Headers and Footers 01:29:38 Printing Microsoft Excel Sheets 01:34:51 Print Options 01:37:56 Inspect a Microsoft Excel Workbook for Issues 01:41:17 Insert and Remove Hyperlinks 01:46:04 Insert Comments, Symbols and Images 01:50:48 Workbook Properties, Help System and Spelling Cell Formatting 01:57:07 Fonts, Borders and Shading 02:02:34 Cell Merging, Alignment, Rotation and Wrapping 02:11:04 Copy Formatting 02:14:37 Number Formatting 02:19:22 Simple Conditional Formatting 02:34:35 Sorting Data 02:37:17 Fill Handle 02:45:56 Formulas and Cell References 02:51:43 The Order of Operations 02:54:46 Excel's Error Messages 03:00:46 Quick Analysis Tool and Sparklines 03:06:14 Cell Area Names 03:14:13 Create, Modify, and Format Microsoft Excel Tables 03:26:37 Sort and Filter Table Data 03:38:27 Cell References Charts 03:49:51 Introduction to Microsoft Excel's Charts 03:57:32 Chart Formatting 04:04:40 Chart Designs Common Functions 04:09:39 SUM Function 04:15:18 AVERAGE, MAX and MIN Functions 04:20:06 COUNT COUNTA and COUNTBLANK Functions 04:23:58 IF function 04:30:40 LEN Function 04:32:25 Mathematical Functions - RAND and RANDBETWEEN Functions 04:37:10 SEQUENCE Function 04:42:23 SUMIFS function Statistical Functions 04:47:52 MEDIAN - AVERAGE - MODE 04:54:24 AVERAGEIFS 04:59:44 COUNTIFS 05:05:00 LARGE SMALL 05:09:29 QUARTILE.INC, QUARTILE.EXC, PERCENTILE.EXC, PERCENTILE.INC 05:23:28 STDEV, STDEVP, STDEV.P, STDEV.S 05:32:43 VAR, VAR.S, VAR.P, VARP 05:39:35 COVAR, COVARIANCE.S, COVARIANCE.P, CORREL Lookup Functions 05:47:43 SORT 05:52:25 UNIQUE 05:54:53 TRANSPOSE 05:59:49 CHOOSE 06:04:58 INDEX 06:10:53 MATCH 06:16:28 OFFSET 06:21:07 VLOOKUP 06:26:53 HLOOKUP 06:32:18 LOOKUP Combinations 06:41:07 VLOOKUP-MATCH, VLOOKUP-HLOOKUP 06:49:54 OFFSET-MATCH-MATCH 06:54:31 INDEX-MATCH, INDEX-MATCH-MATCH Financial Functions 07:00:31 SLN, SYD, DB, DDB, VDB 07:09:51 PMT, IPMT, PPMT 07:21:08 PV, FV, NPER, RATE 07:31:28 NPV, XNPV 07:37:46 IRR, MIRR, XIRR 07:44:59 DOLLARFR, DOLLARDE 07:48:46 YIELD, YIELDDISC, YIELDMAT 07:53:22 DISC, RECEIVED, INTRATE 07:57:21 PRICE, PRICEMAT, PRICEDISC 08:03:15 ACCRINT, ACCRINTM 08:11:00 COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD 08:19:53 DURATION, MDURATION 08:23:03 TBILLEQ, TBILLPRICE, TBILLYIELD Pivot Tables and Charts 08:28:29 Pivot Tables Creation 08:34:17 Calculated Fields and Items 08:41:08 Pivot Charts 08:45:30 Slicers 08:52:23 PowerPivot 08:58:45 Power Pivot Hierarchies 09:04:26 Goal Seek 09:08:18 The Solver Addin