KEY FEATURES

Fire up Google Sheets, and you’ll see many of the same features Microsoft Excel has, like charts, graphs, pivot tables, functions and formulas. But, it’s also home a trove of features that make it unique, including file sharing, revision history, and web-based scripts. Serving as your Google Sheets primer, this course takes you through the basics of creating a spreadsheet and exposes you to more advanced concepts, like macros and importing HTML and scripts to replicate Excel’s functions.

• Access 7 sections & 7 hours of content 24/7
• Learn how to present & organize data in Google Sheets
• Replicate Microsoft Excel’s functions by using macros, import HTML & scripts
• Quickly write formulas using the point-and-click method
• Explore data tools, like sorting, subtotaling & filtering
• Discover how to automate tasks w/ scripts & add-ons
• Validate your training w/ a certification of completion

Note: Software not included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• Accreditation: CPD UK

Requirements

• Internet required

THE EXPERT

Instructor

Justin Mares formerly ran growth at developer-tools company Exceptional (acquired by Rackspace in March of 2013). At Exceptional, he was responsible for growth and revenue across three separate developers tools products – Exceptional, Airbrake and RedisToGo.

He has also founded two other companies, one of which was acquired.

Justin is also the co-author of Traction Book, a book about how startups can get traction. For the book, he interviewed Jimmy Wales (founder of Wikipedia), Paul English (founder of Kayak), Dharmesh Shah (HubSpot founder) and pulled together an actionable framework for how startups should think about getting traction and distribution.

KEY FEATURES

Capable of manipulating vast amounts of data, automating tasks and presenting complex information, Microsoft Excel can be a powerful tool in the workplace, and this course is your first step to understanding its true potential. Designed with the beginner in mind, each module in this course will walk you through the most business-relevant elements of Excel. You’ll explore how Excel works and learn the essentials for navigating and designing a spreadsheet. Then, you’ll dabble in popular formulas, time-saving macros, and more.

• Access 160 modules & 32 hours of content 24/7
• Explore the basics of navigating & designing a spreadsheet
• Streamline your work w/ popular formulas, like IF, VLOOKUP, COUNT, SUM & SUMIF
• Learn how to use PivotTables, Pivot Charts & basic macros
• Familiarize yourself w/ conditional, cell & number formatting
• Validate your training w/ a certification of completion

Note: Software not included.

PRODUCT SPECS

Important Details

• Length of time users can access this course: lifetime
• Access options: desktop
• Certification of completion included
• Redemption deadline: redeem your code within 30 days of purchase
• Experience level required: all levels
• Accreditation: CPD UK

Requirements

• Internet required

THE EXPERT

Instructor

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).