Excel Essentials - Boost your efficiency and save time

Focused View

Nico @softcademy

4:02:12

87 View

1 - Introduction

1 - Introduction.mp4

04:58

2 - Info.html

2 - Starting

3 - Adding highlighting.mp4

06:32

4 - Mass insertion.mp4

06:10

5 - Adding cols rows freezing.mp4

09:58

6 - Basic formatting.mp4

02:48

7 - Basic functions.mp4

09:59

8 - Own formulas with relative addressing.mp4

07:27

9 - Absolute Addressing.mp4

08:35

10 - Text orientation.mp4

01:34

11 - Simple graph.mp4

04:47

12 - Page formatting.mp4

05:48

13 - Repeat header when printing.mp4

03:02

14 - Conditional formatting.mp4

06:20

15 - Split hide.mp4

04:14

3 - Functions

16 - Dates.mp4

04:17

17 - Math Rounding.mp4

05:22

18 - Statistic count if blank.mp4

07:48

19 - Ranking.mp4

06:06

20 - Text.mp4

09:34

21 - Finance.mp4

11:30

22 - Finance 2.mp4

08:50

23 - Finance 3 Monthly payment Interest.mp4

09:38

24 - Lookup.mp4

05:42

25 - Database.mp4

07:28

26 - Logical.mp4

04:32

27 - Logical statement.html

28 - Nested.mp4

05:18

29 - Calculate between sheets.mp4

03:24

4 - Analysis

30 - Graph type formatting.mp4

10:48

31 - Pivot table.mp4

06:40

32 - Pivot chart.mp4

02:38

33 - Data table.mp4

04:36

34 - Advanced sorting.mp4

03:57

35 - Subtotals.mp4

03:40

36 - Scenarios.mp4

07:06

5 - Increase Productivity

37 - Data validation.mp4

06:04

38 - Error checking comment.mp4

04:07

39 - Naming cells.mp4

03:10

40 - Paste special.mp4

02:53

41 - Import.mp4

03:03

42 - Macro CreateRecord Use.mp4

06:02

43 - Sharing adding password.mp4

02:43

44 - Password required to edit.mp4

03:04

6 - Files tricks

45 - Book1.xlsx

45 - First Excel Workbook.html

46 - Excel Workbook to calculate between more sheets.html

46 - SecondSample.xlsx

47 - MySample.xlsx

47 - Third MySample.html

48 - Text file To convert.html

48 - mySampleData.txt

Description

Learn Advanced Excel Techniques - Data Analysis and Reporting Made Easy

What You'll Learn?

Cell formatting
Working with sheets
Functions - structure & most used
Graphs
Analysis
Pivot table & pivot graph
Ordering, Filtering, Advanced filter
Subtotals
Scenario, Data table, Sum of the scenario
Verification & Control
Import
Macro - record and use

Who is this for?

Manager

Business Analysts

Financial Analysts

Accountants

Human Resources Professionals

Anyone who wants to boost their skills in Excel

What You Need to Know?

No programming experience needed

More details

Description
Welcome to our course, Excel Essentials! Whether you're a beginner or an experienced user, this comprehensive course is designed to take your Excel skills to the next level. Boost your efficiency and save time. Learn Advanced Excel Techniques: Analyze, Visualize, and Automate.
With a large amount of short video lectures, the course covers everything you need to know to become an Excel expert. You'll learn how to create and format spreadsheets, analyze data using powerful functions and formulas, visualize data with charts and graphs, and much more.
Videos are short on purpose so that you can easily skip the part that you already mastered in other to save your time during your learning journey with us.
Throughout the course, you'll have access to practical examples and real-world scenarios to help you apply what you've learned. You'll also receive step-by-step guidance and detailed explanations, making even the most complex Excel tasks easy to understand.
By the end of the course, you'll be equipped with the tools and knowledge you need to streamline your work, save time, and achieve your goals. Whether you're using Excel for work or personal projects, this course will give you the skills and confidence to succeed.
So what are you waiting for? Enroll in today and start your journey towards Excel mastery!
Who this course is for:
Manager
Business Analysts
Financial Analysts
Accountants
Human Resources Professionals
Anyone who wants to boost their skills in Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Experienced Web Development Specialist with a demonstrated history of working in the information technology and services industry. Skilled in PHP, Python, Java, MySQL, Android studio, JavaScript, jQuery, and full-stack web development. Strong arts and design professional with a Master of Information Technology focused in Information Technology.From own experiences, we found out that learning from video tutorials is a very effective way of learning. Someone helped us with their video tutorials during our studies, now our video tutorials are made to help - The main reason you will find them at very low price.

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.