Microsoft Excel For Business OfCourse
السعر: 12 USD
25 USD
  • مدة الدورة التدريبية: Flexible

تفاصيل الدورة

118 lectures with 10 hours of video content
  • Nearly 100 downloadable PDF slides and Excel Project files to enhance your learning
  • Free quiz to help you consolidate your learning
  • Develop a mastery of basic and advanced excel skills
  • Learn how to master formula, functions, charts and graphs
  • Master… functions such as SUMPRODUCT, COUNTIFS, VLOOKUP,… CONCATENATE, HYPERLINK and many more!
  • PLUS easy keyboard shortcuts to increase your productivity and speed - both PC and Mac!… 

Microsoft Excel for Business will take your Excel to the next level, and allow you to impress your boss or keep driving your business forward. This course will provide a masterclass in advanced excel skills which will allow you to master powerful analytics tools and present data in new and exciting ways.

Leading you through this course will be Chris Dutton, the founder of Excel Maven whose passion for Excel led to him to become a Certified Microsoft Excel Expert. Chris specialises in using innovative, hands-on online courses to get students up to speed and has taught thousands of students in the past seven years to use Excel like a master.

This course starts with detailed instructions on how to master Excel Formulas and Functions, with sections dedicated to Lookup/Reference functions, Statistical functions, Formula based formatting, Date & Time functions and many more. Chris will then move on to how to use those functions in a creative way through Advanced Charts and Graphs.

If you want to master Excel and banish those spreadsheet fears take this course today!

Introduction to Formulas and Functions
  • Intro
  • Say hi to your fellow students!
  • Share your new course with your friends!
  • Course Structure & Outline
Excel Formulas 101
  • Introduction
  • Handout - Formulas 101
  • Excel Download - Fixed Relative References
  • The Formula Library & Auditing Tools
  • Basic Formula Syntax
  • Fixed, Relative, & Mixed References
  • Common Errors & the IFERROR statement
  • Function, CTRL & ALT Shortcuts
  • Handout - Mac Shortcuts
  • BONUS: Shortcuts for Mac Users
  • Creating Custom Data Validation Rules
  • Fixed vs. Volatile Functions
Logical Operators
  • Introduction
  • Handout - Logical Operators
  • Excel Download - Logical Operators
  • Anatomy of the IF Statement
  • Nested IF Statements
  • AND/OR Operators
  • NOT vs. \\"
  • Fixing Errors with IFERROR
  • Common IS Statements
Statistical Functions
  • Introduction
  • Handout - Statistical Functions
  • Excel Download - Statistical Functions
  • Basic Statistical Functions
  • SMALL/LARGE & RANK/PERCENTRANK
  • RAND() & RANDBETWEEN
  • The SUMPRODUCT Function
  • COUNTIFS/SUMIFS/AVERAGEIFS
  • PROJECT SHOWCASE: Building a Basic Dashboard with COUNTIFS & SUMIFS
Lookup/Reference Functions 1
  • Introduction
  • Handout - Lookup/Reference Functions
  • Excel Download - Lookup/Reference Functions
  • Working with Named Arrays
  • ROW/ROWS & COLUMN/COLUMNS
  • VLOOKUP/HLOOKUP
  • Joining Data with VLOOKUP
  • Fixing Errors with IFERROR & VLOOKUP
  • VLOOKUP Reference Array Options
  • The INDEX Function
  • The MATCH Function
  • Using INDEX & MATCH together
  • Combining MATCH with VLOOKUP
  • The OFFSET Function
  • PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart
Lookup/Reference Functions 2
  • The INDEX Function
  • The MATCH Function
  • Using INDEX & MATCH together
  • Combining MATCH with VLOOKUP
  • The OFFSET Function
  • PROJECT SHOWCASE: Using OFFSET to create a dynamic scrolling chart
Text Functions
  • Introduction
  • Handout - Text Functions
  • Excel Download - Text Functions
  • UPPER/LOWER/PROPER & TRIM
  • The CONCATENATE Function (&)
  • LEFT/MID/RIGHT & LEN
  • TEXT/VALUE
  • SEARCH/FIND
  • Categorizing Data with IF(ISNUMBER(SEARCH))
  • Combining RIGHT
تحديث بتاريخ 23 December, 2018

نبذة عن معهد OfCourse

OfCourse is an E-learning website that offers over 200 online courses that focuses on the self-improvement sector. The courses range from yoga to nutrition, psychology to life coaching and even a Pokemon Go course!

عرض الجميع دورات OfCourse
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

لم تجد ما كنت تبحث عنه؟

أو