Excel Quick Tips: Learn the Magic of Excel in Minutes

Focused View

Few Steps

2:31:02

42 View

1. Data Entry in Excel

1.1 series.xlsx

1. Generate a data series.mp4

01:56

2.1 Fill Multiple Cells with the Same Data.xlsx

2. Fill Multiple Cells with the Same Data.mp4

02:05

3.1 Quickly insert multiple rows and columns.xlsx

3. Quickly insert multiple rows and columns.mp4

03:16

4.1 weblinks.xlsx

4. Insert links, website address or emails.mp4

04:19

5.1 dropdow end.xlsx

5.2 dropdown start.xlsx

5. Create and manage dropdown lists.mp4

03:19

6.1 summing rows.xlsx

6. Summing rows of data.mp4

02:59

7.1 flash fill 2.xlsx

7. Fill in contents with Flash Fill.mp4

03:21

8.1 flash fill 2.xlsx

8. Fill in contents with Flash Fill (Advanced).mp4

05:27

9.1 Create and format tables.xlsx

9. Create and format tables.mp4

02:48

10.1 Quickly insert a total.xlsx

10. Calculate a total quickly.mov.mp4

02:45

11.1 extract data.xlsx

11. Extract a portion of a cells value.mp4

07:20

2. Working with data in Excel

1.1 Select specific rows or columns.xlsx

1. Select specific rows or columns.mp4

03:05

2.1 Format selected data set end.xlsx

2.2 Format selected data set start.xlsx

2. Format selected data set (rowscolumns).mp4

02:17

3.1 Find named ranges.xlsx

3. Find named ranges.mp4

01:09

4.1 sorting.xlsx

4. Change sort order for rows and columns.mp4

02:51

5.1 filterData.xlsx

5. Filter data.mp4

03:04

6.1 removeFilter.xlsx

6. Remove filter.mp4

02:06

7.1 text filter.xlsx

7. Filter data based on text and remove filter.mp4

06:50

8.1 duplicates.xlsx

8. Remove duplicate entries.mp4

05:37

9.1 Convert formula values to plain numbers.xlsx

9. Convert formula values to plain numbers.mp4

04:02

10.1 Transpose data from vertical to horizontal.xlsx

10. Transpose data from vertical to horizontal.mp4

02:34

11.1 Transpose data from horizontal to vertical.xlsx

11. Transpose data from horizontal to vertical.mp4

02:33

3. Formatting in Excel

1.1 wratp Text.xlsx

1. Wrap text.mp4

01:58

2.1 auto fit column data.xlsx

2. AutoFit Text in Columns in Excel.mp4

02:37

3.1 rotate cell data.xlsx

3. Rotate text data.mp4

01:32

4.1 allign cell data.xlsx

4. allign cell data.mp4

02:30

5.1 international currency formats.xlsx

5. international currency formats.mp4

02:21

6.1 cell styles.xlsx

6. Cell styles.mp4

02:13

7.1 Page options.xlsx

7. Page options.mp4

02:25

8.1 Adjust single row height and column width.xlsx

8. Adjust single row height and single column width.mp4

01:28

9.1 Adjust multiple row height and column width.xlsx

9. Adjust multiple rows height and multiple columns width.mp4

02:28

10.1 header.xlsx

10. Add headers.mp4

04:10

11.1 footer.xlsx

11. Add footers.mp4

05:16

12.1 Add a watermark.xlsx

12. Add watermark.mp4

04:08

13.1 conditional formattting.xlsx

13. Conditional formatting by cell contents and highlight them.mp4

04:08

14.1 Copy and paste cell formatting.xlsx

14. Copy and paste cell formatting.mp4

04:16

15.1 merge.xlsx

15. Merge cells.mp4

03:04

4. Viewing options on Excel

1.1 zoom.xlsx

1. Zoom Change magnification.mp4

02:35

2.1 freeze.xlsx

2. Freeze panesrowscolumnsheader.mp4

05:24

3.1 hide unhide.xlsx

3. Hide and unhide columns.mp4

02:25

4.1 groups.xlsx

4. Show and hide grouped data.mp4

02:57

5. Collaborate and Share on an Excel file

1.1 comment.xlsx

1. Insert and respond to comments.mp4

03:25

2.1 highlight custom.xlsx

2. Highlight portions of a spreadsheet.mp4

02:52

3.1 Enable Draw inside the ribbon.xlsx

3. Enable Draw inside the ribbon.mp4

01:56

4.1 draw.xlsx

4. Draw and mark up.mp4

03:16

6. Control Access on Excel Files

1.1 password.xlsx

1. Encrypt a workbook with a password.mov.mp4

04:30

2.1 password.xlsx

2. Remove passsword form a Encrypted workbook.mp4

01:25

Description

Learn the most common Excel tasks in minutes with our easy-to-follow video tutorials.

What You'll Learn?

Office workers who use Excel on a daily basis but need help with specific tasks, such as running calculations, setting up new workbooks, applying conditional fo
Students who are taking a class that requires them to use Excel but need extra help with the material.
Anyone who wants to learn more about Excel and improve their skills.
You'll discover how easy Excel is to learn and use.

Who is this for?

The course is also suitable for people who are new to Excel or who have limited experience with the software. The videos are short and to the point, and they cover a wide range of topics, so students can learn the skills they need at their own pace.

A sales representative who needs to learn how to create and use pivot tables to analyze their sales data.

A student who needs to learn how to use Excel to create a budget for their school year.

A freelancer who needs to learn how to use Excel to create and send invoices to their clients.

What You Need to Know?

No prior Excel experience is required. All you need is Excel installed on your computer and the ability to open the app.

More details

Description
This course is designed and taught by FewSteps, a YouTube channel that provides short, to-the-point video tutorials.

This magic Excel course provides short, to-the-point video tutorials on the most common Excel questions. Whether you're looking for help running calculations, setting up a new workbook, applying conditional formatting, fixing a sheet, collaborating with your team, removing sensitive information from a file, or getting tables ready for a presentation, Few Steps has you covered.
Each video is typically 1-3 minutes long, so you can quickly find the answer you need and get back to work. And because each video has an accompanying exercise sheet, you can practice what you've learned and solidify your understanding of the material.
Here are some of the benefits of using the Few Steps Excel video course:

Learn at your own pace: You can watch the videos in any order and at any time that's convenient for you.
Get quick answers: The videos are short and to the point, so you can quickly find the answer to your question and get back to work.
Practice what you learn: Each video has an accompanying exercise sheet, so you can practice what you've learned and solidify your understanding of the material.
Learn from an experienced instructor: Few Steps is created by an experienced Excel instructor, so you can be sure that the information you're learning is accurate and up-to-date.
If you're looking for a convenient and effective way to learn Excel, I highly recommend the Few Steps Excel video course.
Who this course is for:
The course is also suitable for people who are new to Excel or who have limited experience with the software. The videos are short and to the point, and they cover a wide range of topics, so students can learn the skills they need at their own pace.
A sales representative who needs to learn how to create and use pivot tables to analyze their sales data.
A student who needs to learn how to use Excel to create a budget for their school year.
A freelancer who needs to learn how to use Excel to create and send invoices to their clients.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Few Steps

Instructor's Courses

I am a certified Microsoft Excel Expert with over 10 years of experience in using Excel to solve complex business problems. I have a passion for teaching others how to use Excel effectively and efficiently, and I have helped thousands of students learn Excel through my online courses and tutorials.In my professional career, I have used Excel to analyze data, create dashboards, and automate tasks for a variety of companies. I have also used Excel to develop custom solutions for my clients, such as financial models and sales forecasting tools.I am a highly skilled Excel user, and I am proficient in all aspects of the software, including formulas, functions, data analysis, and visualization. I am also an expert in VBA, Excel's programming language.I am passionate about helping others learn Excel, and I believe that Excel is a powerful tool that can be used to solve a wide range of problems. I am committed to providing my students with the knowledge and skills they need to become Excel experts.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.