Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals
- Offered bySkillshare
Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals at Skillshare Overview
Duration | 4 hours |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals at Skillshare Highlights
- Skills Covered: Spreadsheets, Microsoft Excel, Microsoft Office, Business Analytics
- Includes downloadable source file, and pdfs
- Gain Lifetime Access to Courseware
Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals at Skillshare Course details
- In this course we cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it.
- If you are a complete beginner looking to master Excel, or you just want to brush up on the basics, you've come to the right place. If you want to earn more money by developing a skill set that todays employers demand, this is the course is for you!
- Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities. Many of my students have gone on to get better paying jobs, or even start their own businesses, using the very skills you will soon master.
Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals at Skillshare Curriculum
Introduction - Welcome To The Course
Opening Excel, & Creating A Shortcut
The Anatomy Of A Workbook
A Quick Review Of What's Where
Accessing The "F" Keys (Function Keys) On A Laptop
Always Do This FIRST! - Save Your New Workbook
Let's Enter Some Data - Text
Editing Data - Text
Ooops. I Made A Mistake - Undo and Redo
Changing The Appearance Of Text With Formatting - Fonts
A Quick Word On Formatting
Formatting Text - Alignment
Saving Time with AutoFilling Sequences
POWER USER - Adding Your Own Lists To Autofill
Saving Time with Format Painter
Changing The Column Width
Merge And Centre
Entering Data - A Couple Of Shortcuts
Sums - The Old Fashioned Way!
Sums - Using Autosum
Copying Formulas
SUMming Horizontally
Basic Formulas - Subtraction
Basic Formulas - Multiplication
Basic Formulas - Division
Average Function
The Order Of Mathematical Operation
POWER USER - Evaluate Formula Function
Inserting New Columns And Rows
Moving Existing Columns And Rows
Cutting, Copying, Inserting And Deleting
Hiding Columns And Rows
ROUNDing Functions
Formatting Numbers
A Primer On Building Complex Formulas
Building A Complex Formula
Sorting
Wrapping Text And Soft Enter
Adding A New Worksheet
Creating A Simple Chart
Adding Borders
Customizing the Quick Access Toolbar
Simple Printing
Freezing For An Easier View
Getting Help
Filters
Highlighting Cells
Closing - Thank You!
Bonus 1 Whizzing Around Excel Revision
Bonus 2 Keyboard Shortcuts
A1 Style - Relative Relative
$A1 Style - Absolute Relative
$A$1 Style - Absolute Absolute
A$1 Style - Relative Absolute
Level 1 SQA 01 Reverse Engineering A Sample Spreadsheet
Level 1 SQA 02 Casing And Text Functions
Level 1 SQA 03 Charts From A Filtered List
Other courses offered by Skillshare
Student Forum
Anything you would want to ask experts?
ManagementBusiness ToolsMS OfficeMicrosoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals