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
Creating an Analytical DatasetUdacity مهارات برنامج Excel للعمل: المبادئ الأساسية
Macquarie University via Coursera Everyday Excel, Part 1
University of Colorado Boulder via Coursera Financial Forecasting in Python
DataCamp Microsoft Excel Mastery: From Beginner to Pro
Udemy