Video thumbnail for Excel Course For Beginners

Excel Course For Beginners

Jul 10, 2023
arkiana.com Logo

arkiana.com

Here is an Excel Course for Beginners. It covers the most basic concepts and moves all the way to Pivot tables. At the end of the course, you will be able to make a Dynamic Travelling Spreadsheet. Course Files - https://arkiana.com/free-excel-course-for-beginners/ My Weekly Newsletter - https://arkim.substack.com My blog - https://arkiana.com My Website - https://hadlixe.com Let's connect on Twitter - https://twitter.com/arkim_phiri FREE SPREADSHEET TEMPLATES Here are free spreadsheet templates - https://payhip.com/hadlixe SECTIONS 0:00 Introduction to Excel 01:07 Getting Started Excel Interface 03:52 Data Entry and Formatting 09:31 Custom Lists 11:57 Tables, Sorting, and Filtering 15:31 Inserting Rows and Columns 17:00 Conditional Formatting 19:08 Formulas 25:38 Relative and Absolute Reference 30:17 Functions and Data Validation 36:22 VLOOKUP and XLOOKUP 41:33 Charts and Graphs 47:45 Data Cleaning 51:01 Data Analysis with Pivot Tables 01:00:28 Final Project

View Video Transcript
Science Data Sheets & Electronics Reference