Comprehensive Microsoft Excel – Jordan Hudgens
Salepage link: At HERE. Archive:
Learning Microsoft Excel has never been more important. No matter what industry you may work in, being able to create functional spreadsheets is no longer optional, it’s required.
Upon completing the course you will receive an official certificate of completion.
Some of the benefits to this Edutechional course are:
Project based tutorials – This means that you won’t be wasting time on the theory behind spreadsheet development, you will be able to jump right in and learn how to build practical worksheets.
Comprehensive series – Whether you are a beginning level student or you have been using Excel for years, this course offers a full suite of tutorials that can supply you with tools that will help you in your job immediately.
Experienced instructor – The instructor for this course, Jordan Hudgens, has been teaching users all over the world how to design, manage and improve Excel worksheets for the past decade, and in this course you will get access to a wealth of knowledge!
Course Curriculum
Excel Basics
- Intro to Excel Tutorial (2:22)
- How to Configure Excel (3:54)
- How to Design and Format an Excel Spreadsheet (4:09)
- Sorting and Filtering Data in Excel (5:00)
- Text Formatting (6:33)
- Connecting Text Columns in Excel (4:46)
- Managing Tabs (5:36)
- How to Pull Data from Tabs in Excel (4:32)
- How to Use the Format Painter (2:59)
- How to Freeze the Top Row in Excel (4:11)
- How to Add a Header and Footer (3:35)
- How to Print an Excel Spreadsheet on One Page (2:48)
Intermediate Excel Techniques
- Excel Tips, Tricks and Shortcuts (11:51)
- How to Use Math Formulas (3:59)
- How to Use Formulas – Creating Sums (3:29)
- How to Create Tables Automatically in Excel (3:43)
- How to Round in Excel (1:57)
- How to Calculate Averages (1:54)
- How to Calculate Ages (3:30)
- How to Use Themes (2:04)
- Splitting Text Fields in Excel Automatically (4:31)
Advanced Excel Techniques
- How to Add and Manage Sparklines (5:11)
- How to Use Conditional Formatting (5:37)
- How to Use the Count Formula (1:17)
- How to Use If Then Statements (4:04)
- How to Add and Design Charts (11:51)
- Adding Comments (3:50)
- How to Create Financial Scenarios (15:40)
- How to Add SmartArt (5:34)
- How to Pull in Data from a Website into an Excel Spreadsheet (4:07)
- How to Create and Customize Pivot Tables (9:51)
