When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
This Course Includes
skillshare
0 (0 reviews )
14 hours 7 minutes 
english
Online - Self Paced
course
SkillShare
About Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
Excel 2016 Introduction - What You'll Learn
How to Get the Most Out of This Course
Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
Using Excel Templates to Save Time and Effort
Saving Your Document Where You Can Find It
Entering Data and Navigating Cells
Creating Simple Formulas to Do Powerful Calculations
Working with Workbooks and Worksheets
Introduction - Creating and Formatting Your Heading
Formatting Subheadings and Columns and Alphabetizings Lists
Entering and Formatting Numbers
Create Formulas to Calculate Total Costs
Final Formatting Grids and Spacing
Intro to Formulas and Functions
What is a Formula
What is a Function
The Anatomy of a Formula
Quickly Select Cells to Use in Your Formula
Absolute vs. Relative Cell References
AVERAGE and AVERAGEA
COUNT COUNTA and COUNTBLANK
IF Function
SUMIF and SUMIFS Functions
COUNIF and COUNTIFS Functions
VLOOKUP Function
LEFT RIGHT MID Functions
Concatenate
LEN
FIND and SEARCH
MIN and MAX
AND and OR
ROUND
Conditional Formatting
Intro to Charts and Graphs
Formatting Charts
Create a Bar Chart
Create a Pie Chart
Create a Line Chart
Introduction to Pivot Tables - Preparing Your Data
How to Create a Pivot Table
Put Your Pivot Table to Work
Pivot Charts
What's New for 2016
6 New Chart Types for 2016
"Tell Me What You Want To Do" - The New Help Feature
1-Click Forecasting
3D Maps
Saving as CSV, Text and PDF
Backing Up Your Excel Files
Using the AutoRecover Feature
Import from Web, Copy/Paste, and Cleaning Up Data
Import from CSV file and Excel Workbook
Importing Data from Access Database
Printing Your Excel Document
Excel Keyboard Shortcuts
ALT Key Shortcuts
TEXT
REPT - Repeat
UPPER, LOWER, and PROPER
TRIM - Remove Extra Spaces
Combining LEFT, MID, FIND and TRIM
HYPERLINK - Create a Table of Contents for Your Worksheets
RAND and RANDBETWEEN - Random Numbers
ROUND
INT - Integer
MOD - Remainder
DATE and DATEVALUE
TIME
TODAY and NOW
YEAR, MONTH, DAY, HOUR, MINUTE and SECOND
WEEKDAY and WEEKNUM
IFERROR
LARGE and SMALL
INDEX and MATCH
Nested INDEX, MATCH, IF and IFERROR
Nested IF, AND and OR Functions
Record Your First Macro
Saving Your Macro and Security
Use a Macro to Create a Kitchen Remodel Costs Template
How to Use Relative Cell References
An Easy Cell-Formatting Macro
Find and Delete Empty Cells from Located Outside Your Data
Flash Fill and Auto Fill for Fast Data Entry
Freezing the Top Row of Your Spreadsheet
Hide and Unhide Rows, Columns and Entire Sheets
Insert Multiple Rows and Columns Easily
Mail Merge with Microsoft Excel and Word
Paste Special
Sort and Filter
Quick Calculatilons with the Status Bar
Intro to the Complete Walk-Through of Excel Tools and Ribbons
File Menu - The Complete Walk-Through
Home Tab (part 1) - The Complete Walk-Through
Home Tab (part 2) - The Complete Walk-Through
Insert Tab (part 1) - The Complete Walk-Through
Insert Tab (part 2) - The Complete Walk-Through
Insert Tab (part 3) - The Complete Walk-Through
Page Layout Tab (part 1) - The Complete Walk-Through
Page Layout Tab (part 2) - The Complete Walk-Through
Formulas Tab (part 1) - The Complete Walk-Through
Formulas Tab (part 2) - The Complete Walk-Through
Data Tab (part 1) - The Complete Walk-Through
Data Tab (part 2) - The Complete Walk-Through
View Tab (part 1) - The Complete Walk-Through
View Tab (part 2) - The Complete Walk-Through
Developer Tab (part 1) - The Complete Walk-Through
Developer Tab (part 2) - The Complete Walk-Through
Conclusion
What You Will Learn?
- Welcome to my BIGGEST, most complete, Microsoft Excel course ever!.
- 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 know Excel, you're in the right place. .
- This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros..
- My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve..
- 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 start at the very beginning, with opening and saving a worksheet in Excel. .
- I'll show you what all the tools do and walk you through each Excel skill that you need to know..
- I'll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I'll teach you amazing keyboard shortcuts to make your work faster and more productive. You'll learn how to record macros so you can do a whole series of actions with the just click of a button..
- We'll keep going until you're a pro at 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..
- 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. .
- I'll see you in there!.