Excel Beginner Tutorial - From Basics to Advanced Features
Offered By: Learnit Training via YouTube
Course Description
Overview
Master the fundamentals of Microsoft Excel in this comprehensive beginner tutorial. Dive into the essential features of this powerful spreadsheet application, starting with an overview of the interface and navigation techniques. Learn to efficiently enter, manipulate, and format data, while exploring basic formulas and functions for calculations. Progress through intermediate skills such as sorting, filtering, and creating charts to effectively analyze and present information. Discover time-saving tools like AutoFill, custom views, and worksheet management. Gain insights into advanced topics including XLOOKUP, database functions, and an introduction to macros for automating tasks. Whether you're new to Excel or looking to enhance your existing skills, this tutorial provides a solid foundation for organizing, analyzing, and presenting data effectively in various professional and personal contexts.
Syllabus
Start
Introduction
What is Excel?
Excel Interface Overview
Search and Help
Navigating and Selecting Cells
Entering, Replacing, and Deleting Data
Adjusting Cells
Calculations, Formulas, and Functions
Basic Functions
AutoFill
Relative and Absolute Cell Reference
Saving and Sharing Workbooks
Comments
Inserting Rows and Columns
Cut, Copy, and Paste
Formatting Data with Cell Styles
Managing Worksheets
Hiding Row and Columns
Creating Custom Views
Reviewing Worksheets
Printing Worksheets
Conclusion
Taught by
Learnit Training
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard