
This Lecture is about the Course description and objectives
Meet your Instructor
In this lecture you will learn about:
New WorkBook
New Worksheet
Copy a worksheet
Rename a worksheet
Move a worksheet
Save a workbook
Save As a workbook
Close a workbook
Open a workbook
In this Lecture you will learn about:
Cell Names
Column widths
Type text
Format text in cells
Font size
Font color
Fill Cells
Cell shadows
Alignments
Borders
Insert Rows and columns
In this Lecture you will learn about:
inserting a formula
addition, subtraction, multiplication, division
Total
Sorting and filtering
In this Lecture you will learn about:
Minimum
Maximum
Average
Count
In this Lecture you will learn about formatting a worksheet in order to print it
In this Lecture you will learn about:
Line chart
Pie Chart
Bar chart
In this Lecture you will learn about:
Concatenate
Vlookup
In this Lecture you will learn about:
Find and Replace
Trim
Left
Right
Unlock the full potential of Microsoft Excel with our comprehensive course, "Learning Microsoft Excel easy with Practical Examples" This online course is designed for beginners to familiarize themselves with the fundamental features and functionalities of Microsoft Excel. Whether you're a student, professional, or someone looking to boost their spreadsheet skills, this course is your entry point into the world of Excel. This course does not cover all Excel functions and capabilities, but it provides students with a quick and effective method to learn Excel and start using it from day 1.
Course Highlights:
Introduction
Course Overview
Course Objectives
Meet your Instructor
Microsoft Excel Environment
Introduction to Excel
Understand the Excel interface, including the Ribbon, cells, rows, and columns.
Learn essential navigation techniques to efficiently move around your spreadsheet.
Formatting
Master the art of entering data into Excel cells accurately.
Explore formatting options for text, numbers, and dates to present information clearly.
Basic Formulas and Functions
Gain proficiency in basic Excel formulas
Understand how to use functions to perform calculations and manipulate data.
Create simple charts and graphs to visually represent data.
Who Should Enroll:
Anyone interested in practical, hands-on learning of MS Excel
Students and Academics
Professionals seeking to enhance their Excel skills for career advancement.
Students and educators looking to integrate Excel into their academic and research activities.
Small business owners or entrepreneurs aiming to manage and analyze data more effectively
Project and Product Managers
Managers and Directors
Computer Users
Course Benefits:
By the end of this course, you will be equipped with the skills and confidence to navigate Excel fluently, making you a proficient user capable of handling diverse data analysis and management tasks. Join us on this transformative journey into Excel mastery!