
This lecture give you a quick Introduction to Microsoft Excel.
In this lecture you'll learn how to save in Excel.
In this lecture we'll go through the process of adding in Excel.
In this lecture you'll learn about filling in Excel, how it works and how Microsoft Excel automatically fills data for you.
In this lecture you'll learn about Splitting in Microsoft Excel, how it works and how Excel can help you to split data so it's more organized, easier to read and easier to work with.
In this lecture you'll learn about Transposing data in Excel, how to do it, how it works, why you might need to do it and what the end result looks like.
In this lecture you'll learn about one of the most important and widely used aspects of Microsoft Excel: how to sort data, how to filter data, why you might want to do this and what filtered data looks like.
In this lecture you'll learn about Tables in Microsoft Excel, how to create them, how to edit a table and how you can customize a table to suit your needs.
In this lecture you'll learn about Slicers in Microsoft Excel: what they are, how to use them and how they can help you when working with different data sets.
In this lecture you'll learn about drop-downs in Excel, how to use them and the advantages of drop-downs in Microsoft Excel.
In this lecture you'll learn about Charts in Microsoft Excel, what they look like, how you can create them, customize them and edit them.
In this lecture you'll learn about Pivot Tables in Microsoft Excel, how to use them, what they're for and why they're so powerful when working with data sets in Microsoft Excel.
This lecture covers:
How to change font in Excel
How to change the background color of a cell in Excel
How to change the text size in Excel
How to change text color in Excel
How to convert a number to currency in Excel
How to add the dollar symbol in Excel
How to copy format from one cell to another in Excel
How to build a profit and loss template in Excel from scratch
How to leverage on Excel's smart functionality to automatically add months of the year in a spreadsheet
This lecture covers:
How to freeze panes in Excel
How to unfreeze panes in Excel
How to free rows in Excel
How to unfreeze rows in Excel
How to freeze columns in Excel
How to unfreeze columns in Excel
Why it's helpful to freeze panes in Excel and why so many people use it
This lecture covers how to create Microsoft Excel Templates with ChatGPT by using a very simple and powerful ChatGPT app you can use to create and download Microsoft Excel Templates in seconds.
In this lecture we'll cover how to protect your Microsoft Excel sheets and Microsoft Excel workbooks with and without a password to ensure there are no unwanted changes to your precious files and data.
How to Manually Mark These Lectures Complete
This is the template used throughout this course.
Personal Budget Template.
12-Month Calendar Template.
Annual Financial Report Template.
Channel Marketing Budget Template
College Comparison Tracker Template
Daily Schedule Template
Family Budget Template
Gift Planner Template
Household Organizer Template
Invoice Template
Make a List Template
Manage My Money Template
Mortgage Loan Calculator Template
Online Sales Tracker Template
Personal Budget Template
Personal Inventory Template
Profit and Loss Template
Small Business Income and Expenses Template
Track My Tasks Template
Travel Expense Tracker Template
Trip Planner Template
Video Game Tracker Template
Weekly Assignment Schedule Template
Workout Log Template
In this lecture we'll walk you through Microsoft's Support material and documentation for Microsoft Excel and where you can find it.
Bonus Lecture (Final Lecture)
[EXCLUSIVE] Double Degree and Badge. Upon completing this course you will receive 2 Certificates of Completion and an Excel Certified Digital Badge you can add to your Resume, LinkedIn Profile or any other online profile.
Think of this course as Excel for anyone or Excel for everyone. This Microsoft Excel Crash Course will help you to get up an running with Excel in no time.
This Excel course is a simple, easy to use, easy to understand, step-by-step online training for professionals who need to use Excel at the workplace.
We will cover the basics, fundamentals and essentials of Microsoft Excel and will hand hold you through the entire process.
This Microsoft Excel Course has been designed for beginners but anyone can join. Regardless of your role in the organization, whether you have people reporting to you or not and whether you will use Microsoft Excel occasionally or regularly you will find value in this course.
__________
What will you learn?
How to create charts in Microsoft Excel
How to create tables in Microsoft Excel
How to create pivot tables in Microsoft Excel
How to sort, filter and organize data in Microsoft Excel
How to create drop-down lists in Microsoft Excel
Data Validation in Excel
That there's more than one way of doing things in Excel and we'll show you a few examples
Excel Essentials
Principles of Microsoft Excel
Excel Basics
Excel Fundamentals
__________
What you will receive with your enrollment?
High-quality video lectures that explain the different terms and concepts with real world examples and applications.
1-on-1 expert Instructor support to answer your questions or clear up any confusion you might have.
Lifetime access with no expiration so you can complete the course at your own pace, anywhere, on any device and come back for a refresher at any time.
Free course updates so you can continue to benefit from enhancements made to this course.
__________
Pledge to All Students (both current & future students)
Students First. We will never compromise your experience to make money. Never, ever. Yes, this is also a business but to us teaching goes way beyond making money. You will always remain at the forefront of our courses and we want to ensure you have a unique, valuable and memorable experience. We promise.
24x7x365 Support. You can contact us 24 hours a day, 7 days a week, year round, even on holidays, Christmas and New Years Eve; we will get back to you quickly (in a few hours tops) and deliver outstanding quality of service in our support. We promise.
Humbleness, kindness and social responsibility. We believe in giving back to you and the world. So if you need advice or support just ask. And if we can do something to help you in your journey, we will. We promise.
Australian Made. Recognized in the Industry as a symbol of quality and excellence. All our courses are Made in Australia with high tech and are also professionally edited. They include our secret sauce: a lot of passion & love! We also apply in our courses everything our Instructors have learnt from years of experience working with technology, projects, entrepreneurs and people all over the world. We promise.
Quality and Excellence. We will provide you with the best possible educational experience that includes high quality content and incorporates blended learning techniques that include videos, articles, templates, examples, tools and practical applications. We promise.