Excel data processing and analysis in combat
Course Study Address: http://www.xuetuwuyou.com/course/191
The course out of self-study, worry-free network: http://www.xuetuwuyou.com
Course Introduction
This course details Microsoft Excel's application knowledge, and Excel, also known as spreadsheets, is an important part of Microsoft Office suite software. It can be used for mixed operation of various data, and can be applied to many fields such as financial accounting, statistic analysis, securities management, decision management and marketing. Because it has such a wide range of applications, so it has been a myriad of "fans" of the Pursuit and love.
Aiming at the learning characteristics of beginners, this course adopts the organizational idea of "from shallow to deep, from point to face, from traditional operation to comprehensive application", and adopts the teaching principle of "Combining theory with practice" in teaching, and comprehensively and concretely the basic operation of Excel, the operation of workbooks and worksheets, the input and editing of data content, The application of the formula and function, the sorting and filtering of the data, the classification and consolidation, the construction of the chart, the application of the pivot Table/perspective, the output and printing of the worksheet are introduced. In the course of the schoolboys is also interspersed with a lot of operational skills, so arranged to enable students to learn the basic knowledge of Excel, Excel skills, and proficiency in the use of Excel in data analysis work.
Course Catalogue:
The 1th Chapter: Data Analysis Introduction and basic data processing
1.EXCEL Basic Operation Import External data
2.EXCEL basic Operation Set cell format, conditional format
3.EXCEL Basic Operation Protection Worksheet, Advanced Filter
4. Data validation
5. Simulation of the combined calculation
6. The de-weight of the combined calculation
7. Multiple calculations of the combined calculation
The 2nd chapter: formulas, functions, Pivot tables and chart analysis
8. Introduction to Simple functions
9.countif, SUMIF, Rank function
10. Logic functions
11. Leap Year Judgment
12. Text functions
13.vlookup function
14.hlookup function
15.indirect function
. Index, Match function
17. Chart Introduction
18. Making a simple pivot table
19. slicers, Timeline Additions
20. Create a pivot table from multiple tables
21. Dynamic Pivot Table
22. Associated Pivot Table
The 3rd Chapter: The problem of programming solving for Excel Advanced analysis
23.Excel Advanced Planning solution to complete the pharmaceutical raw material matching optimal scheme
24.Excel Advanced Solver Complete solution of six-yuan equation group
25.Excel Advanced Planning Solution Complete Data envelopment Analysis decision input-output ratio
26.Excel Advanced Solver best solution for book sales point location
27.Excel Advanced Programming solution to complete optimal solution of digital combination
28.Excel Advanced Planning solution to complete the number of staff and scheduling optimal plan
29.Excel High-level Solver FAQs and Solutions
The 4th Chapter: VBA Automatic Processing and web crawl
30. Introduction
31. Requirements
32. Learn to use macros
33. Use VBA to achieve a single step to generate payroll bars
Introduction to 34.VBA Concepts and editors
35. Case Introduction
36. Writing a HelloWorld program with interface
37. Use of variables
38. Use of Operators
39. Use of System functions
40. Branching Statements 1
41. Branching Statements 2
42. Actual User Login Verification
43.Excel Crawl Web Data Building simple Web server and new Simple form page
44. Grab Web Data using Excel's own features
45.VBA Programming Implementation Crawl Web source code
46.VBA programming implementation get Web table write data table
More testimonials:
Learn from the zero-based visualization data analyst Career Course (9 courses, 26 chapters, total 324 hours!) Tableau, Echarts, Power BI, Excel)
Course View Address: http://www.xuetuwuyou.com/course/182
Data analyst's Excel Processing and analysis
