
This is Course Introduction, Instructor Bio, and Course Agenda
In this lecture, you will learn what Excel really is, and why it is used.
In this lecture, you will learn various terms related to Microsoft Excel and commonly used Excel terminology
In this lecture, you will learn all about the Excel Interface or environment and various areas on the screen
In this lecture, you will learn the key difference between Excel Workbook and Excel Worksheet
In this lecture you will learn how to create workbooks and worksheet in Excel
In this lecture, you will learn how to work with importing existing templates using Microsoft Online library and working with data
In this lecture, you will learn how to copy Excel Worksheet and how to move Excel Worksheets
In this lecture, you will learn how to work with Excel ranges
In this lecture you will learn how to format various cells and ranges in Excel
In this lecture, you will learn conditional formatting and also how to order cells
Working with print command along with save command are important. In this lecture you will learn how to work with print/save along with Views
Understanding the math in order of operations is very important and key concept. In this lecture you will learn and understand order of operations in Excel
Auto fil and other functions are covered in this lecture.
Working with dates and formatting of date function is covered in this lecture.
In this lecture you will learn an important concept of absolute cell referencing
In this lecture you will learn conditional logic in Excel
In this lecture, you will learn how to work with Modifying text in Excel cells
In this lecture you will learn how to edit ranges in Excel
Several additional tools are explained and demonstrated in this lecture
Find & Replace tool is explained and demonstrated in this lecture.
In this lecture you will learn how to work with columns and rows in Excel along with shortcuts
In this lecture you will learn how to work with numeric formatting in Excel
In this lecture you will learn to work with Text formatting styles and border tool
In this lecture you will learn how the format painter tool works
Themes and cell styles are important tools. In this lecture you will learn how to use cell styles
In this lecture you will learn how to work with the Split screen and Zoom functionality
In this lecture you will learn how freezing panes works in Excel
In this lecture you will learn how to work and place comments in Excel worksheet
In this lecture you will learn how page breaks are configured and utilized. Also print preview is highlighted, explained, and demonstrated
In this lecture you will learn how to work with margin headers
In this lecture you will learn all about worksheet options in Excel
In this lecture you will learn how to work with charts and graphs in excel
In this lecture you will learn how to insert and format objects
This is a lecture that covers important tools covered in the course
This is a lecture that covers important tools covered in the course
In this lecture you can download an Excel resource.
In this area you can download Excel Practice sheets
Welcome to my Excel Course for Beginners, all hands-on, Microsoft Excel course ever
Microsoft Excel is a software program included in the Microsoft Office suite. It is used to create spreadsheets, which are documents in which data is laid out in rows and columns, like a big table.
Due to its extreme versatility and power, Excel has become one of the most-used software programs in the business world.
Excel is one of the most important skills in today's job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.
If you need to learn Microsoft Excel and boost productivity, learn shortcuts, you're in the right place.
This course walks you through hand-on Excel from the very basics of opening Excel all the way to becoming comfortable working within Excel environment.
You will gain solid understanding with this Excel course definitely help you get that promotion
This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn't cover Mac-specific keyboard shortcuts and interface.
We'll keep going until you learn all of the fundamentals of Excel. When you finish this course, you'll know more than most people who use Excel at their job every day.
Here's some of what you'll learn.
Creating spreadsheets in Excel
Saving your work where you can find it
Working with multiple workbooks in Excel
Formatting and printing
Understanding Ribbon and Excel terminology
Cell formatting and working with ranges
Sorting and filtering your data
Conditional formatting and using comments
Working with find and replace tool and others
Fun New features for Excel 2016
Keyboard shortcuts to make your work go faster
Charts, graphs, freeze panes, page breaks, margins, headers
Much more
The course comes with a certificate of completion, a full 30-day money back guarantee, and I'm always available to answer questions or share additional resources if you get stuck.
Thanks for checking out my Biggest Excel Course to date. Over 7 hours of hands-on instruction!
I'll see you in class
Who is the target audience?
Anyone who wants or needs to learn Microsoft Excel for their work.
Anyone who wishes to improve their job or career prospects in an office environment.
Design for beginners who are brand new to Excel (also suitable for intermediate Excel users who want to improve).
Boost productivity
Syed
Team ClayDesk