The Premium Microsoft Office & Data Apps Certification Bundle

638 Enrolled

18 Courses & 74 Hours

$39.99$486.00

You save 91%

What's Included

$27.00 Value

Microsoft Excel (365): Crash Course

Earn and Excel

84 Lessons (6h)

Lifetime

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
Preview

1 Starting Excel
Course Materials
1.1 Starting Excel1:29
1.2 Understanding Excel Interface4:29
1.3 Getting Familiar with The Excel Workbook and Worksheets1:33
1.4 Explaining the Ribbon5:45
1.5 Saving an Excel File2:54
2 What you can enter
2.1 Combined What you can enter in a cell7:42
2.2 Relative and Absolute Cell Referencing3:12
2.3 Entering Formula1:56
2.4 Order of Operations2:59
2.5 Date Serial Numbers4:24
3 Sheets, rows and columns
3.1 Copy and Drag1:41
3.2 Working with rows and columns10:18
3.3 Working with sheets5:27
4 Functions, ranges and shortcuts
4.1 Functions3:49
4.2 SUM Function3:23
4.3 Copy and Drag Formula4:56
4.4 More basic functions2:48
4.5 Named Ranges8:42
4.6 Names Constants and Formula3:52
4.7 Shortcuts3:43
4.8 More Shortcuts6:49
5 Formatting and conditional formatting
Course Materials
5.1 Formatting Font4:57
5.2 Formatting Alignment2:59
5.3 Formatting Borders2:42
5.4 Formatting Numbers3:17
5.5 Conditional Formatting PreConfigured4:45
5.6 Conditional Formatting with Formula11:04
5.7 Conditional Formatting Dialogue Box Formula Trick3:15
6 Printing
6.1 Icons Shapes and Formatting8:52
6.2 Printing Page Layout8:43
6.3 Printing Headers Footers2:31
7 Managing data
7.1 Data Sort5:55
7.2 Filtering5:35
7.3 Tables6:43
7.4 Text to Columns5:20
7.5 Flash Fill2:53
7.6 Data Validation5:22
7.7 Group and Outline4:05
7.8 Freeze Panes1:47
8 Managing text and working with formulas and functions
8.1 Relative and Absolute Referencing5:47
8.2 VLOOKUP6:51
8.3 Index Match6:35
8.4 IF2:10
8.5 Nested If3:18
8.6 Countif Countifs6:56
8.7 SUMIF SUMIFS5:25
8.8 LEN1:59
8.9 RIGHT LEFT MID5:07
8.11 Common Error Types2:18
8.10 SEARCH1:50
8.12 IFERROR3:08
9 Charts
9.1 Chart Basics5:09
9.2 Chart Series and Column Charts5:27
9.3 Bar Charts5:16
9.4 Pie Charts4:28
9.5 Composite Charts3:17
10 Pivot tables, Power Query and Dashboards
10.1 Power Query Intro4:46
10.2 Power Query Consolidation2:47
10.3 Pivot Tables2:12
10.4 Setting up a Pivot Table4:22
10.5 Pivot Table Field Settings4:06
10.6 Pivot Table Calculated Fields1:55
10.7 Pivot Table Groupings2:10
10.8 Pivot Table Slicers and Timelines4:52
10.9.1 Dashboards Part 16:26
10.9.2 Dashboards Part 27:45
11 Macros
11.1 What is a macro1:58
11.2 Recording a Macro1:44
11.3 Relative and Absolute Macros6:00
12 Intro to VBE and VBA
12.1 Introduction to VBE8:19
12.2 Object Model9:11
12.3 Module Worksheets Classes7:50
12.4 Variables and Constants10:23
12.5 Vba Formatting10:38
12.6a If Statement7:08
12.6b Select Case6:25
12.7a For Loop10:13
12.7b DoWhile DoUntil Loop2:47
12.7c ForEach Loop4:54
12.8a Errors6:00
12.8b Errors4:24
12.9 Consolidate6:33

Microsoft Excel (365): Crash Course

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

$27.00 Value

Microsoft Publisher 365

Earn and Excel

46 Lessons (5h)

Lifetime

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...