Data Science 101: Python Plus Excel

Focused View

Sachin Kafle

8:15:12

117 View

1 - Introduction

1 - Introduction.mp4

03:03

2 - Python vs Excel.mp4

02:48

3 - Limitation of Excel.mp4

03:08

4 - Python.mp4

03:17

5 - who can benefit from learning Python.mp4

01:37

6 - What makes Python a better option than Excel.mp4

07:45

7 - Excel vs Python Who wins.mp4

01:55

2 - Download Resources for Excel IMPORTANT

8 - Download Excel Lecture content.html

8 - content.xlsx

3 - Introduction to Basics of Excel

9 - Structure of Excel sheets.mp4

05:03

9 - content.xlsx

10 - The Ribbon.mp4

07:20

11 - Rows and Columns.mp4

05:45

12 - Enter Edit Delete in Excel.mp4

08:22

13 - Excel basic formatting border font color.mp4

05:16

14 - Align Left Right Center.mp4

02:24

15 - Arithmetic operations.mp4

05:16

16 - Excel formulas introduction.mp4

09:09

17 - Copy and Paste.mp4

04:03

18 - Formatting cell.mp4

09:15

19 - Formatting worksheet.mp4

04:15

20 - Moving and selecting contents in Excel sheets.mp4

04:54

21 - IMPORTANT Fixing cell references.mp4

06:15

22 - ALTENTER.mp4

02:45

23 - Text to Column.mp4

04:44

24 - Wrap Text.mp4

01:29

25 - Select special.mp4

04:56

26 - Dynamic Naming.mp4

02:32

27 - Custom Formatting 1.mp4

12:39

28 - Custom Formatting 2.mp4

12:12

29 - Multiple Formats.mp4

03:36

4 - Excel Tools and Tips

30 - Macros.mp4

07:42

31 - Data Validation.mp4

05:55

32 - Sort and Filter.mp4

03:00

33 - Hyperlinks.mp4

02:53

34 - Freeze Panes.mp4

02:36

35 - Tell me what you want to do.mp4

02:16

36 - Keyboard Shortcuts.mp4

09:32

5 - Excel Functions

37 - Count countif and countifs.mp4

11:41

38 - Sum sumif and sumifs.mp4

07:26

39 - average and averageif.mp4

04:06

40 - Text functions.mp4

08:14

41 - max and min functions.mp4

01:57

42 - round function.mp4

02:37

43 - vlookup function IMPORTANT.mp4

14:05

44 - hlookup function.mp4

04:12

45 - index and match function.mp4

10:17

46 - iferror function.mp4

02:56

47 - pivot tables.mp4

05:27

48 - data tables.mp4

03:27

6 - Excel Visualizations

49 - Excel charts.mp4

02:58

50 - Basic formatting for charts.mp4

05:11

51 - Designing charts.mp4

03:11

52 - Bridge charts.mp4

01:21

53 - Treemap.mp4

01:35

54 - Spark Lines.mp4

04:50

7 - Excel Case Study

55 - Introduction to data.mp4

03:15

55 - case-study.zip

56 - Preprocessing data.mp4

02:15

56 - case-study.zip

57 - Create unique code primary key.mp4

03:20

57 - case-study.zip

58 - Creating database.mp4

05:34

58 - case-study.zip

59 - Populate database 1.mp4

14:13

59 - case-study.zip

60 - Populate database 2.mp4

05:39

60 - case-study.zip

61 - Mapping each row to category.mp4

03:38

61 - case-study.zip

62 - Income statement.mp4

03:40

62 - case-study.zip

63 - Format statement.mp4

07:20

64 - Format statement more.mp4

01:58

65 - Populate Income PL statement.mp4

06:01

65 - case-study.zip

8 - Excel Functions in Python

66 - data.zip

66 - vlookup function in excel.mp4

07:59

67 - Implement vlookup functionality in Python.mp4

16:49

67 - vlookup.zip

68 - Pivot tables in excel.mp4

03:01

68 - sales-data.xlsx

69 - Implement pivot tables functionality in Python.mp4

10:58

69 - pivot-tables.zip

70 - Pivot tables using pandas.mp4

03:11

70 - povot-tables2.zip

71 - IF function in Excel.mp4

05:52

72 - IF functionalities in python.mp4

06:47

72 - if-condition.zip

73 - Text manipulation in Excel.mp4

14:42

74 - Text manipulation in Python.mp4

12:09

74 - string-manipulation.zip

75 - count countif countifs sum sumif sumifs.mp4

09:00

76 - count countif countifs sum sumif sumifs in Python.mp4

11:10

76 - sumif-and-countif.zip

9 - Python Visualizations

77 - pivot charts in Excel.mp4

05:45

77 - sales-data.xlsx

78 - Python pandas visualization.mp4

08:46

78 - plots-pandas.zip

79 - Matplotlib.mp4

15:10

79 - matplotlib1.zip

80 - Formatting charts.mp4

06:19

80 - matplotlib2.zip

81 - More on matplotlib.mp4

13:05

81 - matplotlib3.zip

82 - matplotlib and pandas together.mp4

12:28

82 - pandas-and-matplotlib.zip

Description

Learn excel and python with real world case study.

What You'll Learn?

Write excel advanced conditional, text, and lookup functions
Excel automation using python
Learn Microsoft Excel 2016 and many of its advanced features
Learn data science skills using Python and Excel
Excel features using numpy and pandas
Visualization using Excel and Python

Who is this for?

Excel users curious about automating their work using python

Python Developer wanting career switch in Data Science

What You Need to Know?

Python basics (data types, loops, functions etc.)

Install Microsoft 2016, 2013 or 2010

More details

Description
For many years, and for good reason, Excel has been a staple for working professionals. It is essential in all facets of business, education, finance, and research due to its extensive capabilities and simplicity of use.
Over the past few years, pythonÂ programming language has become more popular. According to one study, the demand for Python expertise has grown by 27.6 % over the past year and shows no indications of slowing down. Python has been a pioneer in web development, data analysis, and infrastructure management since it was first developed as a tool to construct scripts that "automate the boring stuff."
Why python is important for automation?
Consider being required to create accounts on a website for 10,000 employees. What do you think? Performing this operation manually and frequently will eventually drive you crazy. It will also take too long, which is not a good idea.
Try to consider what it's like for data entry workers. They take the data from tables (like those in Excel or Google Sheets) and insert it elsewhere.
They read various magazines and websites, get the data there, and then enter it into the database. Additionally, they must perform the calculations for the entries.
In general, this job's performance determines how much money is made. Greater entry volume, more pay (of course, everyone wants a higher salary in their job).
However, don't you find doing the same thing over and over boring?
The question is now, "How can I accomplish it quickly?"
How to automate my work?
Spend an hour coding and automating these kinds of chores to make your life simpler rather than performing these kinds of things by hand. By just writing fewer lines of Python code, you can automate your strenuous activity.
The course covers following topics:
1. Excel basics
2. Excel Functions
3. Excel Visualizations
4. Excel Case study (Financial Statements)
5. Python numpy and pandas
6. Python Implementations of Excel functions
7. Python matplotlib and pandas visualizations
The evidence suggests that both Excel and Python have their place with certain applications. Excel is a great entry-level tool and is a quick-and-easy way to analyze a dataset.
But for the modern era, with large datasets and more complex analytics and automation, Python provides the tools, techniques and processing power that Excel, in many instances, lacks. After all, Python is more powerful, faster, capable of better data analysis and it benefits from a more inclusive, collaborative support system.
Python is a must-have skill for aspiring data analysts, data scientist and anyone in the field of science, and now is the time to learn.
Who this course is for:
Excel users curious about automating their work using python
Python Developer wanting career switch in Data Science

User Reviews

Rating

average 0

Total votes0

Focused display

Sachin Kafle is a Python and Java developer, ethical hacker and social activist. His interest's lies in software development and integration practices in the areas of computation, quantitative fields of trade. His technological interests include Python, C, Java, C# programming. He has been involved in teaching since 2013.Sachin is a engineer of Computer Science (B.E. Computer Science). He is also an instructor on his previously made some geek Youtube channel. He has been giving free classes mostly for students who have not been able to pay for expensive classes in his country.

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.