Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Excel Basics|
Intro to Excel TutorialPreview
How to Configure ExcelPreview
How to Design and Format an Excel SpreadsheetPreview
Sorting and Filtering Data in Excel
Connecting Text Columns in Excel
How to Pull Data from Tabs in Excel
How to Use the Format Painter
How to Freeze the Top Row in Excel
How to Add a Header and Footer
How to Print an Excel Spreadsheet on One Page
|Section 2: Intermediate Excel Techniques|
Excel Tips, Tricks and Shortcuts
How to Use Math Formulas
How to Use Formulas - Creating Sums
How to Create Tables Automatically in Excel
How to Round in Excel
How to Calculate Averages
How to Calculate Ages
How to Use Themes
Splitting Text Fields in Excel Automatically
|Section 3: Advanced Excel Techniques|
How to Add and Manage Sparklines
How to Use Conditional Formatting
How to Use the Count Formula
How to Use If Then Statements
How to Add and Design Charts
How to Create Financial Scenarios
How to Add SmartArt
How to Pull in Data from a Website into an Excel Spreadsheet
How to Create and Customize Pivot Tables
Jordan Hudgens is the CTO and Founder of DevCamp where he leads instruction and curriculum development for all of the DevCamp and Bottega code schools around the US.
As a developer for over the past decade, Jordan has traveled the world building applications and training individuals on a wide variety of topics, including: Ruby development, big data analysis, and software engineering.
Jordan focuses on project driven education, as opposed to theory based development. This style of teaching is conducive to learning how to build real world products that adhere to industry best practices.
Additionally Jordan has published multiple books on programming and computer science, along with developing training curriculum for Learn.co, devCamp, and AppDev on the topics of Ruby on Rails, Java, AngularJS, NoSQL, API development, and algorithms.