Want to print an entire Excel report and it comes out in pieces?

Faced with a bunch of data, I don't know how to start, and don't know how to match the function?

The chart that took 1 hour to make is so ugly that you can't bear to look directly at it?

The beautiful dynamic charts made by others can only be admired?


Come to Yijia to consult the Excel practical class, start from scratch, and let you change from an Excel novice to a master.


Senior all-round practical instructors teach you to help you master the key skills of excel.



"Excel combat class" you will learn

  1. Basic settings of Excel to improve the efficiency of daily processing of Excel tables;


  2. Application of common functions, learn to summarize and analyze data;


  3. Data query, improve data processing capability;


  4. Chart making, making clear and beautiful reports through pivot tables, slicers, and functions.


Course content

one

●

Rules for using Excel

  1. Excel interface awareness

  2. Cut and Copy in Excel

  3. New and template usage

  4. Excel printing and page layout

  5. Excel Basic Formatting

  6. Excel's check function

  7. Excel color scheme

  8. office autocorrect options

  9. open and save


two

●

data analysis

  1. Date and time data types and function analysis

  2. Textual Data Types and Function Analysis

  3. Textual Data Types and Function Analysis

  4. Logical data types and function analysis

  5. Data Validation - Dropdown and Other Settings

  6. green triangle treatment

  7. Introduction to Financial Functions


three

●

Advanced Query Analysis

  1. Rules for the use of Vlookup and Hlookup     

  2. The concept of data matrix and multi-condition query using vlookup 

  3. Use vlookup to implement reverse lookup 

  4. Detailed explanation of the new query function xlookup added by Off365 

  5. Detailed explanation of all query functions of filter multi-conditions newly added by Off365 

  6. Database unique value: detailed explanation of new unique function in off365 

  7. Indirect function query details 

  8. Match matching query function in detail 

  9. Excel-Advanced Data Cleaning-Power Query Introduction 

  10. PowerQuery data cleaning 13 tricks 

  11. Folder merge of Powerquery multi-file merge 


Four

●

data visualization

  1. Chart knowledge - must learn

  2. chart fill

  3. Create and save diagram template for butterfly diagram

  4. Pareto Chart - Twenty-eight Principle Analysis

  5. Two-tier Pie Chart - Sum and Detail Chart

  6. SWOT - Real Matrix Analysis of Two-Factor Influence

  7. Data High and Low Changes - Waterfall Chart

  8. The Magical Uses of Doughnut Charts 


five

●

Data Analysis and Modeling

  1. Data Modeling Concepts 

  2. Loading and introduction of PowerPivot data analysis plugin 

  3. The concept of master table and slave table 

  4. Dimensions and Granularity 

  5. Establishment of data relationships 

  6. Understanding how text fields are created from tables 

  7. Master the concept of a date table and build a date table 

  8. Establishment of date granularity 

  9. Date from table generation method 

  10. grouping of numeric data 

  11. Year-on-year and month-on-month concepts are established and calculated correctly 

  12. Introduction to Date Smart Functions 

  13. Build Metrics 

  14. Slicer concept 

  15. Create Dashboards Using Slicers with Data Matrix 



The original price of the "Excel Practical Course" course is 499 yuan,

Welfare discount price of 299 yuan, send synchronous practice materials.


Registration Guidelines

Scan the code to enter [PMP Cloud Classroom]-[Yijia Micro Class]-

[Excel practical course], click [Sign up now]


picture

Scan the code to enter the PMP cloud classroom


picture


picture

picture