Microsoft Excel Basics Crash Course

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.

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!