Microsoft Excel - Sweet And Short

Excel Mastery Made Simple: Unleashing Efficiency in Every Cell

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

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!

Overview

Section 1: Excel Essentials

Lecture 1 Opening a Workbook

Lecture 2 Saving a workbook

Lecture 3 Managing the Backstage View

Lecture 4 Familiarity with file formats

Lecture 5 Comprehensive knowledge of the ribbon tabs

Lecture 6 Customize the Quick Access Tool Bar

Lecture 7 Excel Interface Overview

Lecture 8 Data entry and editing techniques

Lecture 9 Data Autofill

Lecture 10 Working with Dates & Times

Lecture 11 Adding notes and comments

Lecture 12 Simple Formulas (Totals & Averages)

Lecture 13 Formatting Rows & Columns

Lecture 14 Inserting pictures and shapes into Excel

Lecture 15 Working with Themes

Lecture 16 Freeze Panes

Lecture 17 Getting your sheet ready for printing

Lecture 18 Page break preview

Lecture 19 Spell checker

Lecture 20 Clear all Button

Lecture 21 Find and Replace

Lecture 22 Merge Cells

Lecture 23 Microsoft Templates

Section 2: Working with tables

Lecture 24 Why use a table

Lecture 25 The components of a table

Lecture 26 Formatting of a Table

Lecture 27 Using autofilter

Lecture 28 Slicers with tables

Lecture 29 Advanced Sorting

Lecture 30 Calculating totals on a table

Lecture 31 Referencing within a table

Section 3: Formatting

Lecture 32 What data really looks like

Lecture 33 Applying formatting to a cell

Lecture 34 Text vs Numerical Data

Lecture 35 Formatting Dates

Lecture 36 Working with Currencies

Lecture 37 Formatting Percentages

Lecture 38 Format Painter

Lecture 39 Conditional Formatting with a formula

Lecture 40 Insert a screenshot

Lecture 41 Insert a shape of any type

Lecture 42 Advanced Manipulation of SmartArt

Lecture 43 Insert symbols and equations

Lecture 44 Formatting a graphic object

Lecture 45 Change the shape of a graphic object

Lecture 46 Selection pane

Lecture 47 Object Arrangement

Lecture 48 Perform multi-criteria sorts and customized sorts

Lecture 49 Inputting in multiple cells

Lecture 50 Advanced knowledge of custom lists

Lecture 51 Advanced knowledge of Hypertext links

Lecture 52 Create and edit a form - Part 1

Lecture 53 Create and edit a form - Part 2

Section 4: Core Functions

Lecture 54 Equals and Targeting cells

Lecture 55 Functions vs Formulas

Lecture 56 Adding, subtracting, multiplication and division

Lecture 57 Components of a Function

Lecture 58 Sum and Average Function

Lecture 59 More than one function in a cell

Lecture 60 Absolute References ($ signs)

Lecture 61 Look for - Help with Functions

Lecture 62 COUNT Function

Lecture 63 ROUND, ROUNDUP and ROUNDDOWN Functions

Lecture 64 LEFT and RIGHT functions

Lecture 65 MID function

Lecture 66 Errors in Functions

Lecture 67 CONCATENATE Function

Lecture 68 UPPER, LOWER and PROPER Functions

Section 5: VLOOKUPS

Lecture 69 What you can do with a VLOOKUP

Lecture 70 The correct dataset structure

Lecture 71 Doing a VLOOKUP

Lecture 72 Common problems with VLOOKUP

Lecture 73 Exact or Approximate match

Lecture 74 Comparing two sheets with a VLOOKUP

Lecture 75 Matching on more than one criteria

Lecture 76 HLOOKUP function

Lecture 77 Error Handling - IFERROR function

Beginners to advanced wanting to touch up on their excel skills