Excel Essentials
- Offered byUDEMY
Excel Essentials at UDEMY Overview
Duration | 6 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Excel Essentials at UDEMY Course details
- Beginners Well teach you Excel, and make you good!
- This course was designed to make people better in Excel by talking about things that confuse people every day VLOOKUPs, PivotTables, printing things on one page. Not only do we teach you how to do all of theses wonderful features in Excel, well teach you why. With exercise workbooks that let you work EVERY single example we demonstrate so that you can actually learn how features work, we guarantee that you will feel more at ease with Excel when youre done with this course..
Excel Essentials at UDEMY Curriculum
Opening Excel, And Creating A Shortcut
The Anatomy Of A Workbook: Where Everything Is, And What It Does!
The Anatomy Of A Workbook Review
Always Do This First Save Your New Workbook
Entering Data Text
Quiz Number 1
5 questions
Editing Data Text
Ooops. I Made A Mistake Undo and Redo
Formatting Text Fonts
A Quick Word On Formatting
Formatting Alignment
Saving Time with Auto Filling Sequences
NEW! POWER USER Adding Your Own Lists To Autofill
Saving Time with Format Painter
Quiz 2
Quiz Number 2
3 questions
Changing The Column Width
Merge And Centre
Entering Data A Couple Of Shortcuts
Sums The Old Fashioned Way!
Sums Using Autosum
Quiz 3
Quiz Number 3
3 questions
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
Quiz 4
Quiz Number 4
5 questions
ROUNDing Functions
Formatting Numbers
A Primer In Building Complex Formulas
Building A Complex Formula
Sorting
Wrapping Text And Soft Enter
Adding A New Worksheet
Creating A Simple Chart
Quiz 5
Quiz Number 5
5 questions
Adding Borders
Customizing the Quick Access Toolbar
Simple Printing
Freezing For An Easier
Getting Help
Filters
Highlighting Cells
Quiz 6
Quiz Number 6
5 questions
Closing
Section 2: Bonus Section The Keyboard Shortcuts
Bonus 1 Whizzing Around Excel!
Bonus 2 The Keyboard Shortcuts
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?