Learn Best Excel Skills in One Hour
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 Details
- Language: #English
- Students: 4158
- Rating: 4.72 / 5.0
- Reviews: 124
- Category: #IT_and_Software
- Published: 2021-08-09 01:58:38 UTC
- Price: €19.99
- Instructor: | | Finance and Accounting Academy | |
- Content: 1 total hour
- Articles: 0
- Downloadable Resources: 5
Coupon Details
- Coupon Code: EID_GIFT
- Expire Time: 2024-04-11 10:16:00 UTC