Microsoft Excel - Sweet and Short

Name: Microsoft Excel - Sweet and Short
Rating: 4.7 (12 reviews)

Excel Mastery Made Simple: Unleashing Efficiency in Every Cell

Created byAndre Louw, Ane Lemmer

Last updated 12/2023

English

What you'll learn

Learn basic fundamentals of Excel
Work with Tables and Graphs
Learn about VLOOKUPS, Pivot Tables and many more
Learn core functions

Course content

6 sections • 87 lectures • 2h 31m total length

Opening a Workbook1:14
Open a workbook in Excel by double-clicking the file or via the Excel app and backstage view open option; browse to locate and open files, with multiple workbooks open.
Saving a workbook1:22
Save your workbook using the quick access save icon or ctrl+s. Saving overwrites the current version; use save as to name a new file and preserve the original.
Managing the Backstage View1:29
Familiarity with file formats1:59
Comprehensive knowledge of the ribbon tabs2:13
Customize the Quick Access Tool Bar1:55
Customize the quick access toolbar to add frequently used commands like save, undo, redo, and print for one-click access across tabs; tailor it via the backstage view.
Excel Interface Overview2:03
Explore the Excel interface, from the ribbon and tabs like insert, layout, formulas, to the file tab, formula bar, worksheet area, and status bar, and navigate between cells and sheets.
Data entry and editing techniques1:25
Data Autofill1:39
Working with Dates & Times2:17
Adding notes and comments1:34
Add a note to a cell by right-clicking and selecting new note, then edit or delete and toggle show note; red triangle marks notes, while purple tag comments enable collaboration.
Simple Formulas (Totals & Averages)1:36
Formatting Rows & Columns1:20
Inserting pictures and shapes into Excel1:52
Insert pictures and shapes into Excel to personalize or emphasize content without changing cell data. Move, resize, and format images using the picture tool, add online pictures, shapes, and screenshots.
Working with Themes1:49
Apply themes in Excel to format data, text, and charts with consistent colors and fonts. Preview and customize theme colors and fonts from the layout ribbon, ensuring automatic color updates.
Freeze Panes1:37
Getting your sheet ready for printing1:39
Prepare your sheet for printing by using the print preview, adjusting scaling to fit one page, setting margins, switching to landscape, and choosing the print area or entire workbook.
Page break preview1:24
Spell checker1:52
Clear all Button1:43
Find and Replace2:05
Merge Cells1:23
Microsoft Templates1:20
Excel Essential Quiz

Why use a table1:35
Uncover the power of Excel tables that automate features, enable banded rows, total rows, slicers, and dynamic pivot data ranges.
The components of a table1:43
Formatting of a Table1:38
Using autofilter2:14
Slicers with tables1:20
Filter data visually with slicers for tables, enabling dashboard-style drill-down by clicking values and combining slicers; add and format slicers via table tools.
Advanced Sorting2:16
Calculating totals on a table1:48
Referencing within a table1:58
Working with Tables - Quiz

What data really looks like1:37
Learn that Excel stores data as text or numbers, while formats are cosmetic; use the formula bar to see true contents and avoid misinterpreting values like 0.75 or currency.
Applying formatting to a cell1:50
Text vs Numerical Data2:09
Formatting Dates2:11
Working with Currencies2:02
Formatting Percentages1:19
Understand that percentages are decimals in Excel (1% = 0.01, 120% = 1.2). Enter as % or decimal, format with the percentage option, and adjust decimals.
Format Painter1:45
Conditional Formatting with a formula2:16
Insert a screenshot1:33
Insert a shape of any type1:25
Advanced Manipulation of SmartArt1:26
Insert symbols and equations1:17
Formatting a graphic object1:41
Change the shape of a graphic object1:31
Change the shape of a graphic object by editing points with the edit shape tool, add or delete points, and adjust handles for sharp or rounded corners.
Selection pane1:30
Object Arrangement1:32
Perform multi-criteria sorts and customized sorts1:55
Learn to perform multi-criteria and customized sorts in Excel, grouping raw data by region, month, and product, and using a custom list to order months correctly.
Inputting in multiple cells1:39
Advanced knowledge of custom lists1:13
Advanced knowledge of Hypertext links1:38
Create and edit a form - Part 11:44
Create and edit a data form in Excel using dropdowns, checkboxes, radio buttons, and spinners, with two-way data links to output cells, and learn how to enable the developer ribbon.
Create and edit a form - Part 21:30
Formatting Quiz

Equals and Targeting cells1:56
Functions vs Formulas2:08
Adding, subtracting, multiplication and division1:49
Learn to build basic Excel formulas with addition, subtraction, multiplication, and division using cell references and the equals sign, and apply operator precedence with parentheses.
Components of a Function1:50
Sum and Average Function2:00
More than one function in a cell1:12
Absolute References ($ signs)2:04
Look for - Help with Functions1:30
COUNT Function1:30
ROUND, ROUNDUP and ROUNDDOWN Functions2:27
LEFT and RIGHT functions1:37
MID function1:43
Errors in Functions2:01
CONCATENATE Function2:03
UPPER, LOWER and PROPER Functions1:12
Core Functions - Quiz

What you can do with a VLOOKUP2:30
Explore how vlookup links two data sets, retrieves descriptions, categories, and prices, and keeps data dynamic through single value updates. Learn exact and approximate matching to improve accuracy.
The correct dataset structure1:50
Learn how to structure a data set for vlookup by using the first left column as the search field, selecting a source range, and returning values for a product code.
Doing a VLOOKUP1:51
Common problems with VLOOKUP2:04
Exact or Approximate match2:46
Comparing two sheets with a VLOOKUP1:30
Matching on more than one criteria2:28
HLOOKUP function1:29
Error Handling - IFERROR function2:01
Learn to handle errors in Excel by wrapping Vlookup in the iferror function to return zero when no match, and propagate the fix across cells by dragging.
VLOOKUP - Quiz

Getting your data ready for a graph1:41
Elements of a Graph1:38
What graph to use2:04
Formatting Chart elements1:22
Managing Axes1:22
Bar and Column graphs1:44
Donut and Pie graphs1:43
Use donut and pie graphs to show the size and share of data values; avoid time-based data. Insert from the ribbon, add percentage data labels, and limit entries to eight.
Scatter Graphs1:10
Combo Graphs1:25
Create combo graphs in Excel to plot sales in currency with the number of orders as a line, using a secondary axis for clear interaction.
Using Sparklines1:34
Learn to create sparklines in cells, add and delete sparklines, customize line and win-loss sparklines, and adjust axis values in Excel to highlight trends and high or low data points.
Charts, Graphs & Data

Requirements

No experience needed. You will learn everything from Beginner to advanced. You will need Microsoft Excel for this course.

Description

Introducing the Sweet and Short All-in-one Excel Course, a comprehensive learning experience designed to make you an Excel expert in no time. This course is perfect for anyone looking to master the essential features and functions of Microsoft Excel. Whether you are a beginner seeking to acquire foundational skills or a seasoned Excel user aiming to enhance your proficiency, this course is the perfect solution.

In just a short span of time, this course covers all the essential aspects of Microsoft Excel, providing you with a solid foundation and equipping you with advanced techniques. This curriculum is designed to be accessible and engaging, allowing you to grasp complex concepts effortlessly.

The course takes a hands-on approach to learning. Each lesson is thoughtfully structures, with step-by-step instructions and practical exercises that reinforce your understanding. You'll learn how to navigate spreadsheets efficiently format data professionally, and create powerful formulas and functions to automate calculations.

Additionally, our course stays up-to-date with the latest Excel advancements, ensuring that you are equipped with the most relevant skills and techniques. We understand that time is of the essence, so we have carefully curated the content to provide maximum value in the shortest amount of time possible.

You'll discover time-saving shortcuts, tips and tricks that will help you work faster in excel.

Buy now! This course is yours for a lifetime!

Who this course is for:

Beginners to advanced wanting to touch up on their excel skills

Microsoft Excel - Sweet and Short

What you'll learn

Explore related topics

Course content

Excel Essentials23 lectures • 39min

Working with tables8 lectures • 15min

Formatting22 lectures • 37min

Core Functions15 lectures • 27min

VLOOKUPS9 lectures • 18min

Charts, Graphs and Data10 lectures • 16min

Requirements

Description

Who this course is for: