The Premium Microsoft Office & Data Apps Certification Bundle

631 Enrolled
18 Courses & 74 Hours
$39.99$486.00
You save 91%

What's Included

Microsoft Excel (365): Crash Course
  • Experience level required: Beginner
  • Access 84 lectures & 6 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

84 Lessons (6h)

  • Your First Program
  • 1 Starting Excel
  • 2 What you can enter
  • 3 Sheets, rows and columns
  • 4 Functions, ranges and shortcuts
  • 5 Formatting and conditional formatting
  • 6 Printing
  • 7 Managing data
  • 8 Managing text and working with formulas and functions
  • 9 Charts
  • 10 Pivot tables, Power Query and Dashboards
  • 11 Macros
  • 12 Intro to VBE and VBA

Microsoft Excel (365): Crash Course

Ea
Earn and ExcelEarn and Excel
4.4/5 Instructor Rating: ★ ★ ★ ★

Earn and Excel is a collective of highly experienced professionals from the UK and North America who have packed decades of skills and experiences into easily digestible training courses on Excel, Business Intelligence, Data Analysis, Microsoft Office, Accounting, and Marketing Analytics.

They have all had long careers as professionals first and foremost so this allows them to truly empathize with your challenges in the workplace. Their goal is not to just teach you the theory but to impart practical skills you can begin to implement immediately.

Description

It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for or a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills! The course is presented by the highly experienced Andrew Dove an accounting professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. This course will help you get the best out of Excel.

4.3/5 average rating: ★ ★ ★ ★

  • Access 84 lectures & 6 hours of content 24/7
  • Learn introductory topics such as the Excel interface, sheets, rows, columns & data types
  • Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
  • Format the sheet, numbers, rows, cells & more
  • Sort, filter, & validate data
  • Learn advanced functions such as VLOOKUPS, INDEX, MATCH, IF, & more
  • Consolidate data with Power Query
  • Speed up your work by recording and tweaking Macros

Note: Software NOT included.

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...