Master Excel: From Beginner To Pro!

Unlock the full potential of Excel and become a valuable asset in any data-driven environment today!

What you'll learn

Become a pro in Excel, from beginner to Advanced

Excel fundementals

Formattings in Excel

Working with charts in Excel

Excel templates

Data validations in Excel

Pivot tables

Conditional logic and functions

Excel Macros

Excel VBA

Requirements

No prior Excel knowledge required

Microsoft Excel 2010, 2013, 2019 or Microsoft 365 to follow along in the course

Description

Welcome to "Learn Excel from Beginner to Pro," your comprehensive guide to mastering Excel, the industry-standard spreadsheet software. Whether you're a novice or looking to enhance your existing skills, this course is designed to take you from the basics to advanced functionalities.We start with Covering the Basics of Excel, ensuring you understand the interface, navigation, and essential features. You’ll learn about Formulas and Text Editing, giving you the foundation to perform calculations and manipulate text effectively.Next, we delve into Basic Functions in Excel, covering fundamental operations like SUM, AVERAGE, and COUNT. Excel Data Formatting teaches you how to present your data clearly, making it easy to read and professional.You’ll learn how to Tweak a Worksheet in Excel, customizing it to suit your needs. Our section on Working with Charts, Images, and Shapes in Excel helps you visualize data, making it more accessible and engaging.Explore Excel Templates and How to Work with Them to streamline your workflow. We also cover Working with Lists Inside of Excel, teaching you to organize and manage data efficiently, along with List Functions in Excel to sort, filter, and analyze information.In Import/Export Data, you’ll learn to seamlessly move data between Excel and other programs. Our module on Data Validation in Excel ensures your data entries are accurate and consistent.Handling large datasets can be daunting, but our segment on Working with Large Sets of Data equips you with techniques to manage and analyze vast amounts of information. PivotTables are powerful tools for summarizing data, and you’ll master creating and manipulating them.Protecting your work is crucial, so we include lessons on Protecting Your Workbook or Worksheet, ensuring your data stays secure. Conditional Functions in Excel allow you to perform actions based on specific criteria, while Lookup Functions in Excel help you search and retrieve data efficiently.By the end of this course, you’ll have the skills and confidence to use Excel proficiently, making you a valuable asset in any data-driven environment. Join us in "Learn Excel from Beginner to Pro" and unlock the full potential of Excel!

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Covering the basics of Excel

Lecture 2 Excel Home screen

Lecture 3 The interface inside of Excel

Lecture 4 Excel workbook and status bar

Lecture 5 Excel shortcuts and how to use them

Section 3: Formulas and Text editing

Lecture 6 Working with Excel spredsheet titles

Lecture 7 Numberic data and how we can work with it in Excel

Lecture 8 Working with Date values and date formating in Excel

Lecture 9 Cell references and how they work in Excel

Lecture 10 How to work with formulas

Lecture 11 Absolute and relative references in Excel

Section 4: Basic functions in Excel

Lecture 12 The "SUM()" function

Lecture 13 How "MIN()", "MAX()" and "AVARAGE()" functions works

Lecture 14 What is the Adjacent error in Excel?

Lecture 15 Lets learn the "CEILING()", "FLOOR()" and "COUNT()" functions

Lecture 16 Auto sum in Excel

Lecture 17 Excel AutoFill

Section 5: Excel data formatting

Lecture 18 Formatting our fonts

Lecture 19 Working with background colors

Lecture 20 Adding borders and border-styles

Lecture 21 Adding our currency

Lecture 22 Formatting percentage in Excel

Lecture 23 Excels format painter

Lecture 24 Creating custom styles in Excel

Lecture 25 Creating some formatting based on conditions

Lecture 26 Merging cells together

Section 6: Tweak an worksheet in Excel

Lecture 27 Moving data inside an worksheet or between workbooks

Lecture 28 Editing the width and height of cells

Lecture 29 Adding / Removing rows and columns

Lecture 30 Hiding and showing rows or columns

Lecture 31 Copying or moving an Excel worksheet

Lecture 32 Removing a worksheet or changing a name of a worksheet

Section 7: Working with Charts, Images and Shapes in Excel

Lecture 33 Adding Excel shapes to our worksheet

Lecture 34 Adding images into our worksheet

Lecture 35 How we can work with Excel smartArt in our worksheet

Lecture 36 Creating an line chart in excel and playing around with the chart ribbon

Lecture 37 Changing the data in our line-chart and moving the line chart

Lecture 38 Changing the chart type and adding a bit of formating

Section 8: Excel templates and how to work with them

Lecture 39 Excel template into

Lecture 40 Working with and creating templates

Section 9: Great job! You now have a Microsoft Excel Foundation!

Lecture 41 Lets do a recap on what we have done

Section 10: Working with lists inside of Excel

Lecture 42 The structure of an Excel list

Lecture 43 Multi-Level and Single-Level list sorting

Lecture 44 Custom sort and filtering a list in Excel

Lecture 45 Finding and removing duplicates

Lecture 46 Convert a list to a table

Section 11: List functions in Excel

Lecture 47 The "DSUM()" function

Lecture 48 "DSUM()" With AND-statements or OR-statements

Lecture 49 The "DCOUNT()" function

Lecture 50 The "DAVERAGE()" function

Section 12: Import / Export Data

Lecture 51 Export data to a text file in Excel

Lecture 52 Import data from a text file in Excel

Section 13: Data validation in Excel

Lecture 53 Data validation List

Lecture 54 Excel Email validation

Lecture 55 Excel date validation

Lecture 56 Excel Text validation

Section 14: Working with large sets of data

Lecture 57 Grouping column and rows together

Lecture 58 Freeze Panes

Lecture 59 Working with printing options for large sets of data

Section 15: PivotTables

Lecture 60 The power of PivotTables

Lecture 61 Building our first PivotTable

Lecture 62 Grouping and Formatting Data in our PivotTable

Lecture 63 PivotCharts

Lecture 64 Filtering data in our PivotTable

Lecture 65 Styling our slicer

Lecture 66 Modifying sourceData for our PivotTable

Section 16: WOW! You are now a midpro in excel!

Lecture 67 Lets do a small recap on what we have done

Section 17: Protecting out workbook or worksheet

Lecture 68 Protecting cells in our worksheet

Lecture 69 Adding a password to our workbook and protecting the workbook structure

Section 18: Conditional functions in Excel

Lecture 70 Excels name ranges

Lecture 71 The "IF()" function

Lecture 72 Nesting functions inside of Excel

Lecture 73 The "COUNTIFS()" function

Lecture 74 The "SUMIFS()" function

Section 19: Textbased functions in Excel

Lecture 75 The "Left()", "Right()", "Mid()" and "Len()" functions

Lecture 76 Using "IF()", "LEN()" and "RIGHT()" functions together

Lecture 77 Using the "SEARCH()" and "CONCATENATE()" functions

Section 20: Lookup functions in Excel

Lecture 78 The "VLOOKUP()" function

Lecture 79 "IFERROR()" function

Lecture 80 Working with absolute values in our lookup functions

Lecture 81 The "HLOOKUP()" function

Lecture 82 The "MATCH()" and "INDEX()" functions

Lecture 83 Using MATCH() AND INDEX() together

Section 21: Excel Automations with Macros

Lecture 84 Introduction into Excel macros

Lecture 85 Creating our first macro

Lecture 86 Saving our workbook with our macro

Lecture 87 How to edit our macro with VBA

Section 22: Becoming a master in the "What if" tools inside of Excel

Lecture 88 Working with the "PMT()" function and "Goalseek" tool

Lecture 89 The "solver" tool

Lecture 90 Data Tables

Lecture 91 Creating Scenarios

Section 23: Excel Auditing

Lecture 92 Dependents and Precendents tracing in Excel

Lecture 93 Show Formulas and Evaluate Formulas

Lecture 94 Error Checking

Lecture 95 Watch Windows in Excel

Section 24: Wrapping up the course

Lecture 96 Congratulations! You're now a master in Excel!

If you want to learn Excel from beginner to advanced this course is for you.,If you want to take your excel skills to the next level this course is for you