Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Comprehensive Microsoft Excel

Discover how to use Microsoft Excel with an easy to follow tutorial series that focuses on project based learning.
Rating: 4.4 out of 54.4 (2,003 ratings)
6,515 students
Created by Jordan Hudgens
Last updated 10/2013
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • By the end of this course you will be able to quickly and masterfully utilize Microsoft Excel, including how to: design and template worksheets, manipulate text, build complex financial models, apply conditional formatting, and be able to utilize shorts that will make using Excel an efficient process.
Curated for the Udemy for Business collection

Requirements

  • Basic understanding of how to use a computer.

Description

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!

Who this course is for:

  • This course can be utilized by beginner through advanced Excel students alike.

Course content

3 sections • 31 lectures • 2h 33m total length

  • Preview02:21
  • Preview03:53
  • Preview04:07
  • Sorting and Filtering Data in Excel
    04:58
  • Text Formatting
    06:31
  • Connecting Text Columns in Excel
    04:44
  • Managing Tabs
    05:34
  • How to Pull Data from Tabs in Excel
    04:30
  • How to Use the Format Painter
    02:58
  • How to Freeze the Top Row in Excel
    04:09
  • How to Add a Header and Footer
    03:34
  • How to Print an Excel Spreadsheet on One Page
    02:47

  • Excel Tips, Tricks and Shortcuts
    11:49
  • How to Use Math Formulas
    03:58
  • How to Use Formulas - Creating Sums
    03:28
  • How to Create Tables Automatically in Excel
    03:42
  • How to Round in Excel
    01:57
  • How to Calculate Averages
    01:53
  • How to Calculate Ages
    03:29
  • How to Use Themes
    02:03
  • Splitting Text Fields in Excel Automatically
    04:29

  • How to Add and Manage Sparklines
    05:09
  • How to Use Conditional Formatting
    05:35
  • How to Use the Count Formula
    01:17
  • How to Use If Then Statements
    04:02
  • How to Add and Design Charts
    11:49
  • Adding Comments
    03:49
  • How to Create Financial Scenarios
    15:38
  • How to Add SmartArt
    05:32
  • How to Pull in Data from a Website into an Excel Spreadsheet
    04:05
  • How to Create and Customize Pivot Tables
    09:49

Instructor

Jordan Hudgens
CTO at Bottega Code School
Jordan Hudgens
  • 4.4 Instructor Rating
  • 12,915 Reviews
  • 66,184 Students
  • 16 Courses

Jordan Hudgens is the CTO and Founder of Bottega where he leads instruction and curriculum development for all of the DevCamp and Bottega code schools around the US.

As a full stack developer for over the past decade, Jordan has traveled the world building applications and training individuals on a variety of technology stacks, including: Ruby on Rails, Python, React JS, React Native, JavaScript, and TypeScript, with a speciality in API and machine learning development.

Jordan has developed applications for Quip, Eventbrite, and DevCamp. As a teacher, he focuses on project driven education, with a focus on jobcentric techniques. This means that he focuses specifically on teaching the skills needed in the development industry. 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 for Packt Publishing, along with developing training curriculum for Bottega, Learn Co, DevCamp, and AppDev on the topics of Ruby on Rails, Java, AngularJS, NoSQL, API development, TypeScript and algorithms.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.