Free Excel Tutorial – A beginners guide to Excel
Learn how to use Excel from scratch with this comprehensive course. From opening and saving workbooks to formatting, sorting, and filtering data, you’ll gain a solid understanding of Excel’s functionality. Whether you’re an absolute beginner or have no prior knowledge of Excel, this course is designed to get you comfortable with the software in the shortest possible time. With topics ranging from file management to data analysis, this course is perfect for anyone new to Excel. Start your Excel journey today and unlock the full potential of this powerful tool.
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
Who this course is for:
- Anyone new to Excel who wants to understand how to use the software. This is to get you comfortable using Excel in the shortest possible time
User Reviews
Be the first to review “Free Excel Tutorial – A beginners guide to Excel”
You must be logged in to post a review.
There are no reviews yet.