Microsoft Excel Basics Crash Course
Microsoft Excel Basics Crash Course, available at $19.99, has an average rating of 4.58, with 6 lectures, based on 158 reviews, and has 5127 subscribers.
You will learn about Excel Interface, Formatting, and File creation Formulas and Functions Visual Presentations (Charts and Graphs) Pivot Tables This course is ideal for individuals who are Learners who need an introduction to excel It is particularly useful for Learners who need an introduction to excel.
Enroll now: Microsoft Excel Basics Crash Course
Summary
Title: Microsoft Excel Basics Crash Course
Price: $19.99
Average Rating: 4.58
Number of Lectures: 6
Number of Published Lectures: 6
Number of Curriculum Items: 6
Number of Published Curriculum Objects: 6
Original Price: $39.99
Quality Status: approved
Status: Live
What You Will Learn
- Excel Interface, Formatting, and File creation
- Formulas and Functions
- Visual Presentations (Charts and Graphs)
- Pivot Tables
Who Should Attend
- Learners who need an introduction to excel
Target Audiences
- Learners who need an introduction to excel
This is a great course for someone who is just starting in Excel. It will boost learner’s confidence and ability in excel skills. The course will focus on:
– How to open, name, and save an excel file.
– Excel Interface: sheet layout and organization.
– Borders and Sheet Format.
– Merging Cells: how to merge multiple cells
– Sort & Filter: how to sort texts from A to Z or Z to A; and how to sort numbers from largest to smallest or smallest to largest.
– Find & Select: how to search a sheet to find a specific text or number
– Replace: how to find a target and replace it with another input.
– Sum, Average, and Count: calculate the sum, average, and count for a set of numbers
– Minimum and Maximum: find the minimum and maximum within a set of numbers
– IF Statements: how to use the IF Statements function to make conditional arguments.
– Dropdown Lists: how to create a dropdown list
– VLOOKUP: how to use the VLOOKUP to extract some data from a data range/table.
– Bar Chart: how to create a bar chart
– Pie Chart: how to create a pie chart
– Chart Formatting: how to format a chart
– Pivot Tables: how to use Pivot Tables to summarize and analyse large data.
– Pivot Tables Formatting: how to format a Pivot Table.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction
Chapter 2: Home Ribbon
Lecture 1: Merge, Format, Sort & Filter, and Find and Replace
Chapter 3: Functions and Formulas
Lecture 1: Functions and Formulas
Chapter 4: VLOOKUPS
Lecture 1: Dropdown Lists and VLOOKUPS
Chapter 5: Visual Presentations
Lecture 1: Charts and Charts Formatting
Chapter 6: Pivot Tables
Lecture 1: Pivot Tables
Instructors
-
Finance and Accounting Academy
Finance and Accounting Lecturer
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 11 votes
- 4 stars: 34 votes
- 5 stars: 113 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Mobile App Development Courses to Learn in December 2024
- Top 10 Graphic Design Courses to Learn in December 2024
- Top 10 Videography Courses to Learn in December 2024
- Top 10 Photography Courses to Learn in December 2024
- Top 10 Language Learning Courses to Learn in December 2024
- Top 10 Product Management Courses to Learn in December 2024
- Top 10 Investing Courses to Learn in December 2024
- Top 10 Personal Finance Courses to Learn in December 2024
- Top 10 Health And Wellness Courses to Learn in December 2024
- Top 10 Chatgpt And Ai Tools Courses to Learn in December 2024
- Top 10 Virtual Reality Courses to Learn in December 2024
- Top 10 Augmented Reality Courses to Learn in December 2024
- Top 10 Blockchain Development Courses to Learn in December 2024
- Top 10 Unity Game Development Courses to Learn in December 2024
- Top 10 Artificial Intelligence Courses to Learn in December 2024
- Top 10 Flutter Development Courses to Learn in December 2024
- Top 10 Docker Kubernetes Courses to Learn in December 2024
- Top 10 Business Analytics Courses to Learn in December 2024
- Top 10 Excel Vba Courses to Learn in December 2024
- Top 10 Devops Courses to Learn in December 2024