Microsoft Excel - Beginner To Pro - Excellence Course

Achieve professional level Microsoft Excel Skills

What you'll learn

Get up and running using Microsoft Excel

Learn all of the most commonly used Excel Formulas and Function

Format your data for clean, concise analysis

Master data analytic tools like Excel's PIVOT table, Slicers and timelines

Learn how to over 75 functions, such the popular VLOOKUP, SUMIFS, XLOOKUP and many more

Automate repetitive task using Excel Macros

Requirements

No Prior Excel Knowledge Required

This course is thought using Excel 2021 however any desktop version of Excel will work

Description

How can this course help me?We'll start from the Start!No matter if you have been using Microsft Excel for some time or you have never opened a spreadsheet, we will guide you all the way!Excel is now an expected skill amongst almost all employers. With over 2 BILLION worldwide Microsoft Excel users, mastering Excel will help you advance your professional career. Save time and let the computer do the work!Organise and store records logically, which are easy to filter, search and retrieve in futureTransform complicated data into clean readable informationAnalysis of large data sets and extract key insightsReport & Invoice printingAutomate daily, weekly, and monthly repetitive tasksPractical ExamplesThere are 100's of practical examples.Each course module comes with a workbook for you to follow along and sharpen your skills.Most Importantly!After the course, you'll be able to apply your new skill set to almost any Excel problem!  –––––––––––––––––––––––––––––––––––––––––––––––––-STUDENT REVIEWS"I took Louise's Microsoft Excel course and it was the best decision I made for my career. Louise was amazing and made complex topics easy to understand. I was able to apply what I learned immediately at work and impress my boss. Highly recommend!""I've taken a few Excel courses before, but this course was by far the most informative and valuable. Louise went above and beyond to answer all of our questions and provided real-world examples. I now feel confident in my Excel skills and can't wait to take my newfound knowledge to the next level.""This Microsoft Excel course was exactly what I needed to enhance my spreadsheet skills. Louise was engaging and made the material easy to digest. I appreciated the practical exercises and the immediate feedback I received. I highly recommend this course, especially with Louise as the instructor, to anyone looking to improve their Excel skills.""I took Louise's Microsoft Excel course and it was one of the best investments I made in myself. Louise explained everything in a way that was easy to understand. The course content was comprehensive and the assignments were challenging yet manageable. I feel confident in my Excel skills and am excited to apply what I learned in my job."

Overview

Section 1: Introduction

Lecture 1 Course Introduction and Resources

Section 2: Module 2 - Fundamentals

Lecture 2 Module 2 Intro - Fundamentals

Lecture 3 2.1 - Workbook Components

Lecture 4 2.2 - The Excel Ribbon

Lecture 5 2.3 - Worksheet

Lecture 6 2.4 - Cells & Ranges

Lecture 7 2.5 - Rows and Columns

Lecture 8 2.6 - The Formula Bar

Lecture 9 2.7 - The Range Bar

Lecture 10 2.8 - The Status Bar

Lecture 11 2.9 - Quick Access Toolbar

Lecture 12 2.10 - Saving your workbook

Lecture 13 2.11 - Excel File types and PDFs

Section 3: Module 3 - Formatting

Lecture 14 Module 3 Intro - Formatting

Lecture 15 3.1 - Text formatting

Lecture 16 3.2 - Number formatting

Lecture 17 3.3 - Date and time formatting

Lecture 18 3.4 - Borders, Grid-lines, Alignments & Colors

Lecture 19 3.5 - Merge Cells and Wrap Text

Lecture 20 3.6 - Styles

Lecture 21 3.7 - Paste Special and the format painter tool

Lecture 22 3.8 - Visible Cells only

Lecture 23 3.9 - Custom Formatting

Lecture 24 3.10 - Data Validation

Lecture 25 3.11 - Shape Alignment

Section 4: Module 4 - Conditional Formatting

Lecture 26 Module 4 Intro - Conditional Formatting

Lecture 27 4.1 - Highlight Cell Rules

Lecture 28 4.2 - Top and Bottom Rules

Lecture 29 4.3 - More Rules

Lecture 30 4.4 - Data Bars

Lecture 31 4.5 - Color Scales and Heat maps

Lecture 32 4.6 - Icon Sets

Lecture 33 4.7 - Custom Formula rules

Lecture 34 4.8 - Entire data row rule

Lecture 35 4.9 - Manage, Edit & Remove Rules

Section 5: Module 5 - Commands

Lecture 36 Module 5 Intro - Commands

Lecture 37 5.1 - Searching (Worksheet-Workbook)

Lecture 38 5.2 - Find and Replace

Lecture 39 5.3 - The Autofill Handle

Lecture 40 5.4 - Flash Fill

Lecture 41 5.5 - Fill Series

Lecture 42 5.6 - Go To Special

Lecture 43 5.7 - Removing Duplicates

Lecture 44 5.8 - Text to Columns

Lecture 45 5.9 - Custom Lists

Lecture 46 5.10 - Goal Seek

Lecture 47 5.11 - Viewing - Freeze Panes

Lecture 48 5.12 - Viewing Multiple Windows

Lecture 49 5.13 - Viewing – Grouping and ungrouping

Section 6: Module 6 - Formulas and Functions

Lecture 50 Module 6 Intro - Formulas and Functions

Lecture 51 6.1 - The difference between a functions & formulas

Lecture 52 6.2|1 - Formula operators (Mathematical)

Lecture 53 6.2|2 - Formula operators (String)

Lecture 54 6.2|3 - Formula operators (Comparison)

Lecture 55 6.2|4 - Formula operators (Logical)

Lecture 56 6.2|5 - Absolute & Relative references

Lecture 57 6.3|1 - Categories of Functions and Availability

Lecture 58 6.3|2 - Date & Time functions

Lecture 59 6.3|3 - Text functions

Lecture 60 6.3|4 - Logical functions

Lecture 61 6.3|5 - Lookup & Reference functions

Lecture 62 6.3|6 - Math functions

Lecture 63 6.3|7 - Statistical functions

Lecture 64 6.4 - Wild Cards**

Lecture 65 6.5 Office 365 Functions

Section 7: Module 7 - Data Analysis

Lecture 66 Module 7 Intro - Data Analysis

Lecture 67 7.1 - Filtering

Lecture 68 7.2 - Sorting

Lecture 69 7.3 - Tables

Lecture 70 7.4 - Pivot Tables

Lecture 71 7.5 - Slicers

Lecture 72 7.6 - Timelines

Lecture 73 7.7 - Chart building

Lecture 74 7.8 - Drop down menus

Section 8: Module 8 - Macros and VBA Introduction

Lecture 75 Module 8 Intro - Macros and VBA

Lecture 76 8.1 - What are Macros & VBA

Lecture 77 8.2 - The Developer Tab

Lecture 78 8.3 - Recording and running a Macro

Lecture 79 8.4 - Relative References

Lecture 80 8.5 - Macro Buttons

Lecture 81 8.6 - Creating simple Macros

Lecture 82 8.7 - The VBA interface

Lecture 83 8.8 - A look at the code

Lecture 84 8.9 - Editing the code

Lecture 85 8.10 - Debugging the code

Lecture 86 8.11 - VBA Language grammar

Section 9: Module 9 - Protection

Lecture 87 Module 9 Intro - Protection

Lecture 88 9.1 - Worksheet Protection

Lecture 89 9.2 - Macro Protection

Lecture 90 9.3 - Workbook Protection

Section 10: Module 10 - Printing and PDFs

Lecture 91 Module 10 Intro - Printing and PDFs

Lecture 92 10.1 - Orientation

Lecture 93 10.2 - Scaling

Lecture 94 10.3 - Margins

Lecture 95 10.4 - Page Brakes & Print Area

Lecture 96 10.5 - Repeated Row & Column Headers

Lecture 97 10.6 - Header, Footer, page numbers & logos

Lecture 98 10.7 - Save as PDF & multiple tabs

New users of Excel, who require the basics to get up and running,Existing Excel users seeking to enhance their technical skills,Entry - Level Professionals, who would like to acquire a clear understanding of how to us Microsoft Excel,Mid - Career Professionals, working within Excel and looking to unlock and deep understanding of Excel's capabilities