Free Microsoft Excel Complete Course

you will learn about MS Excel for free

00:00 – Introduction to Microsoft Excel 00:58 – Excel Interface Overview 07:10 – Creating and Saving/Opening Sheet 11:46 – Entering text 15:20 – Entering Date Values 21:25 – Basic Formula 26:14 – Relative Vs Absolute Cell Reference 33:03 – More Basic Formula 36:37 – Adding Sum Function 40:30 – AutoSum, Average, Count, Min and Max Functions 45:14 Fixing Cell error in Calculations 48:45 Copy Pasting Data 49:50 Rename Sheets 51:19 Flash Fill / Moving Data 52:43 Inserting Rows and Deleting 53:39 Formatting and adding Borders 58:58 Custom Borders 59:21 Using Cell Styles Command 1:03:28 Merge and Center 1:04:27 Alignment 1:04:48 Format Painter 1:05:56 Conditional Formatting 1:07:16 Format Overview 1:07:53 Wrap text Command 1:08:12 Assignment 1:08:30 Assignment Solution 1:22:07 Pictures 1:26:27 Shapes 1:28:54 Assignment and Solution Hint 1:32:32 Smart Art 1:34:34 Icons 1:36:12 Charts/Column Chart 1:42:43 Charts/Pie Chart 1:43:33 Print Preview 1:44:23 Page Setup/Print 1:47:32 Page Layout 1:48:07 Print Selection 1:49:18 Working with Print Area 1:51:48 Page Layout views 1:52:28 Header and Footer / Page Numbers 1:56:06 Assignment 1:56:10 Convert to PDF 1:56:56 Good Bye