- Introduction
- File Menu
- Home Menu
- Insert Menu
- Page Layout Menu
- Data Menu
- Review Menu
- View Menu
- Help Menu, Add ins & where to from here
What you'll learn
- A complete overview of how to use Microsoft Excel. I will take you through the software and explain all the menu options and what they do.
Description
I will take you through all the menu items in Excel and show you what they do and how to use them. This course is aimed at getting you familiar with the functionality of Excel in the shortest possible time. You need no prior knowledge of Excel, this is aimed at absolute beginners that would like to learn how to use Excel from scratch.
Course Overview:
•1. Introduction
•Introduction PPT
•Overview of Microsoft Excel
•Overview of the sample data
•2. File Menu
•How to open and save a workbook
•How to print a workbook
•3. Home Menu
•Cut, Copy and Paste
•Formatting font, colours and alignment
•Change formats to number, text, date etc
•What is conditional formatting?
•Insert and delete rows and columns
•Intro to formulas •Sorting and filtering data
•4. Insert Menu
•Tables and Pivot tables
•Images and illustrations
•Charts and sparklines
•Other insert ribbon options
•5. Page Layout Menu
•Themes
•Page setup
•Change formats to number, text, date etc
•Other page layout ribbon options
•6. Data Menu
•Data sources
•Sorting and filtering
•Data tools
•Other data ribbon options
•7. Review Menu
•Proofing
•Comments and notes
•Other review ribbon options
•8. View Menu
•Workbook views
•Freeze and split panes
•Other view ribbon options
•9. Help Menu, Add ins & where to from here
•Help
•Add ins
•Course review
•Where to from here
Other Courses
Crafting Connections Series: Nonviolent Communication (NVC)
Transform Conflict into Connection with the Power of NVC
Arabic, Urdu, Japanese, Bengali, Sinhala, wood learning game
Hindi, Malayalam, Korean, Gujarati, Gurmukhi, Hebrew, Tamil letters to print & play with Glow Forge laser cutter machine
Zero to Hero Stargazing: Basic Astronomy - The Planets
An awesome planets course for astronomy beginners of all ages. No telescope required.
The Fundamentals of 3D Rendering with SimLab Composer
Bringing Designs to Life: Mastering 3D Rendering
About the instructors
- 4.53 Calificación
- 4083 Estudiantes
- 4 Cursos
Warren Thomas
Owner / Consultant at Featherbrooke Consulting Services
5 Years’ experience running my own IT consultancy. Consulting to all industries. Over 20 years experience working in systems development and business intelligence. Have worked for market leaders in South Africa and abroad.
Key fields of expertise are:
Project Management
System development
Business Intelligence Dashboard development
MIS and reporting automation
Data analysis
Process mapping and SOP Development
Business and systems analysis
Student feedback
Course Rating
Reviews
Starts off super basic, then as the lessons unroll eg explanation of the tool bar, skipped over a couple of icons - also leaving all of the changes up as you go through the various icon functions was a little confusing ie made it harder to focus on the actual icon you were discussing.
yes it was thank you