Excel To Dashboard: A Beginner's Guide To Excel

Name: Excel To Dashboard: A Beginner's Guide To Excel
Rating: 4.5 (109 reviews)

From a beginner to impressing your boss!!

Created byRaphael Asghar

Last updated 10/2018

English

What you'll learn

The goal of this course is to take the absolute beginner in Excel and show them the path in becoming a very well versed person in Excel knowledge; the person will be able to get hands on experience in understanding the core of Excel – the spreadsheet – and everything that goes in creating and understanding spreadsheets, formulas, formatting, functions, charts, security, data manipulation, managing user input, printing, working with tables, pictures, arrays, pivot tables, dashboards and much more. At the end of this course you will “probably” have more knowledge than your peers!

Course content

1 section • 103 lectures • 14h 50m total length

WELCOME AN INTRODUCTION TO EXCEL1:53
WHAT IS EXCEL5:03
Explore Excel as an electronic spreadsheet to store, organize, and manipulate data in workbooks and cells, and learn how to obtain it via a 30-day trial or Office 2016 purchase.
EXCEL DOCUMENTS DOWNLOADABLE0:42
INTRODUCTION TO EXCEL WORKBOOK12:05
QUIZZES QUIZZES QUIZZES - WHERE ARE THEY?1:13
Learn Excel by repeating each video to reinforce shortcuts and skills, instead of a quiz after every ten videos, as taught by Raphael across 100 videos.
EXCEL KEYBOARD SHOTKEYS10:55
QUICK ACCESS TOOLBAR8:23
ENTER MODIFY AND DELETE DATA10:03
Learn to enter, modify, and delete data in Excel, using the formula bar and wrap text. Explore how deleting affects data and formatting, and how to use basic formulas.
USING THE CLEAR OPTION8:06
CREATING AND SAVING WORKBOOKS6:16
CREATING AND DELETING WORKSHEETS15:04
COPY MOVE PROTECT WB13:22
Copy and move worksheets within and across workbooks using right-click, copy or move, and drag-and-drop. Protect the workbook with a password and hide or unhide specific sheets to secure data.
HOW TO VIEW MULTIPLE WORKBOOKS8:33
HOW TO VIEW OR COPY OR MOVE IN WINDOWS6:50
UNDERSTANDING RANGES AND CELLS13:42
Explore how a single cell forms a row and column, learn to select contiguous and noncontiguous ranges with mouse, keyboard, F8, and manage quick analysis and format painter options.
UNDERSTANDING COMMENTS AND FIND AND REPLACE12:26
WORKING WITH TABLES17:33
USE FORMATTING TO MAKE YOUR WB CRISP13:16
Learn to format data in Excel using the home ribbon, including font, alignment, currency formatting, merge and center, borders, fill color, and text wrap for clearer end-user worksheets.
USING FORMATTING WITH KEYBOARD14:11
WORKING WITH EXCEL FILES15:39
HOW TO CREATE A TEMPLATE19:59
Create and use Excel templates to standardize future files, including formatting and fields. Save templates as .xltx and reuse them to generate consistent expense reports with automated mileage calculations.
HOW TO NAME RANGES11:07
CREATING DYNAMIC RANGE NAMES6:24
HOW TO BUILD EXCEL FORMS5:58
PRINTING A WORKBOOK OPTIONS10:36
WHAT ARE FORMULAS11:14
WHAT ARE FUNCTIONS10:26
USING CELL REFERENCES10:24
UNDERSTANDING ERRORS5:59
Identify and resolve common Excel errors in a dataset, such as divide by zero, name errors, not available, missing references, and value or number too large errors, with practical fixes.
JOINING TEXT AND NUMBERS9:24
Explore how to join text and numbers in Excel using concatenate, the ampersand, and the percent sign, with quotes for text and awareness of absolute versus relative references.
USING CODE AND CHAR6:40
Learn how Excel uses character codes with code and char functions to convert characters to numbers (1–255) and back, including carriage returns and inserting symbols.
USING THE REPEAT FUNCTION5:37
USING THE TEXTBOX7:07
WHAT IS THE TRIM AND LEN FUNCTIONS6:36
WHAT IS THE LEFT AND MID AND RIGHT FUNCTIONS8:19
Learn how to use left, right, and mid functions in Excel to extract substrings from text, trim spaces, and format names, dates, and identifiers for clean dashboards.
USING THE FIND FUNCTION8:32
USING THE FIND FUNCTION FOR FIRST MIDDLE LAST5:27
UNDERSTANDING TEXT TO COLUMNS4:49
USING THE CONVERT TEXT TO NUMBERS OPTION3:49
USING THE SUBSTITUTE AND REPLACE FUNCTION6:58
USING THE UPPER LOWER PROPER FUNCTIONS8:33
USING THE EXACT AND EQUAL FUNCTIONS3:38
USING THE DOLLAR AND FIXED FUNCTIONS3:50
UNDERSTANDING DATES SERIAL NUMBER SYSTEM4:15
CONVERTING TEXT DATE TO SERIAL NUMBER4:15
INTRODUCTION TO DATE FUNCTIONS10:56
DATE AND TIME FUNCTIONS10:56
DATE TIME FUNCTIONS WITH CALCULATION7:16
Learn to count working days between dates with the network days function, excluding weekends and holidays, using configurable weekend patterns (1-16) and holiday ranges for scheduling.
USING THESE 3 FUNCTIONS WORKDAY WEEKNUM WEEKDAY4:27
USING THE WEEKDAY FUNCTION7:41
Use the weekday function to map dates to day numbers, convert to names with text, apply conditional formatting, and learn weeknum and pivot charts.
USING THE EDATE AND EOMONTH3:31
WHAT IS THE COUNT COUNTA COUNTBLANK FUNCTIONS10:05
USING THE SUM SUMIF SUMIFS FUNCTIONS7:40
USING THE DSUM DMAX DMIN DCOUNT FUNCTIONS12:47
THE IMPORTANT VLOOKUP FUNCTION9:42
USING THE HLOOKUP FUNCTION4:31
Master horizontal lookups with the HLOOKUP function in Excel by learning how to search across rows, calculate bonuses based on years worked, and total salaries using proper arguments.
WHAT IS THE MATCH AND INDEX FUNCTIONS11:55
USING THE AND OR FUNCTIONS4:50
THE LOGIC IF FUNCTION19:53
Master the if function in Excel, which evaluates a logical test and returns a value if true or false. Learn using and/or and nesting to build complex formulas.
IF FUNCTIONS WITHIN IF FUNCTIONS5:16
CREATE RANDOM NUMBER5:39
USING THE AGGREGATE FUNCTION5:16
WHAT IS ARRAYS12:37
Explore arrays in excel, including horizontal and vertical one-dimensional arrays and two-dimensional ranges. Learn to enter array formulas with control shift enter, and use sum, large, and small within arrays.
WHAT IS THE TRANSPOSE FUNCTION3:45
USING THE PMT FUNCTION13:05
WHAT IS SPARKLINE CHART5:05
CONDITIONAL FORMATTING WORKBOOKS17:41
INTRODUCTION TO CHARTS9:33
COLUMN CHART PART 119:00
COLUMN CHART PART 218:49
CREATING THE PIE CHART12:02
CREATING THE DOUGHNUT CHART7:41
CREATING THE LINE CHART7:55
CREATING THE SCATTER CHART5:41
CREATING THE COMBO CHART6:38
BUBBLE - AREA - STOCKN - SURFACE - RADAR CHARTS11:07
CREATING THE HISTOGRAM CHART4:19
Learn how to create a histogram chart in Excel to show data frequency in bins, such as grade distributions, and adjust the default five bins, bin width, and axis formatting.
CREATING THE WATERFALL CHART3:56
Create a waterfall chart in Excel to visualize monthly variance between target and actual registrations, with positives in green and negatives in red, computed as actual minus target.
CREATING THE PARETO CHART5:02
CREATING THE TREEMAP CHART4:57
CREATING THE STARBURST3:04
CREATING THE GANTT CHARTS10:19
HOW TO INSERT PICTURES4:25
SECURING DATA WITH DATA VALIDATION15:24
WHAT ARE OUTLINES7:08
HOW TO USE CONSOLIDATING4:53
Learn to consolidate data from multiple worksheets into a single summary with the consolidate tool, creating grand totals and subtotals across West, East, North, and South regions.
HOW TO USE LINKING11:11
PROTECTING THE WORKSHEET9:46
PROTECT WITH CELL STYLES4:38
HOW TO USE IMPORT DATA5:30
PIVOT TABLE PART 112:00
PIVOT TABLE PART 212:14
PIVOT TABLE CHART5:39
WHAT IF SCENARIO MANAGER15:12
WHAT IF GOAL SEEK8:09
WHAT IF DATA TABLE8:16
WHAT IS A MACRO9:10
DASHBOARDS PART 115:00
DASHBOARDS PART 215:00
DASHBOARDS PART 310:13
WHAT DO YOU WANT TO KNOW4:34
FINAL THOUGHTS ABOUT EXCEL2:15
BONUS VIDEO0:21
Discover continued learning with more Excel courses, and learn how to download a document to claim a $10 coupon.

Requirements

This course is designed for the absolute beginner. No prior knowledge is needed. You will need PC Excel 2016 version software and a desktop or a laptop computer. Most will also work with PC Excel 2013 version.

Description

The course is designed with the absolute beginner in mind; you do not need any experience in Excel. But, what you will learn from the course is how to create tables, navigate with formatting spread sheets, learn about formulas and functions, understand error handling, use common formulas to manipulate data, create charts and pivot tables that will enhance any raw data, and finally end up creating sophisticated dashboards that will sure to impress your boss and much more!

Who this course is for:

This course is designed for the absolute beginner. You do not need any knowledge of Excel as this course will take you step by step in educating you about Excel workbooks and spreadsheets. Professionals such as administrators, accountants, data entry clerks, business clients, teachers, network administrators, and family members all can take advantage of this course. Anybody who wants to learn about Excel spreadsheets will benefit from this course.