Microsoft certification can prove that the holder has mastered the technical ability to deploy, design and optimize cutting-edge IT solutions. The following is the Microsoft excel expert certification exam, for your reference!

Introduction to Microsoft excel Expert Certification Examination 1 Qualification Background

Proficient in the integration and docking of human resources Excel, one of the few Excel application experts in the field of enterprise management consulting, known as "enterprise management booster".

Be good at using office tools to transform the data of various systems into decision-making information of managers; Good at using various import tools to convert data inside and outside the system; Can combine the characteristics of students' professional posts and transform IT product knowledge into concise, efficient and practical skills; Be good at summing up learning rules, and will repeatedly guide the skilled application of learning methods; Make good use of cases and interactive teaching methods, so that students can master all kinds of new skills step by step in a relaxed environment and achieve the purpose of applying what they have learned.

Brand course

Efficient Office and Statistical Analysis of Data —— Application of ——EXCEL

"Human Resource Management -Excel Application"

Production management-the road of ——EXCEL application

Financial management-the application of ——EXCEL

Customer evaluation

Learning Mr. Sun's courses has gained a lot, especially in salary data analysis. It took us three or four days to collect this information and data before. With Mr. Sun's method, we can sum it up in a day or even less. This provides great convenience for our work.

—— Zhang Jing, HR Manager of Jinan Bearing Capacity

What I have gained most is the processing of some forms and the rapid extraction of data. At the end of the year, we will summarize the data for analysis. We spent a lot of time in the past, using traditional methods. After listening to Mr. Sun's class, I found that excel is actually skillful, because I am not familiar with it and waste a lot of time. After learning this skill, I found it was so OK! It's that simple!

—— Pan Aihong, Director of Human Resources of Shandong Yixin Digital Technology Company

I especially hope that Mr. Sun will come to our company and give a lecture to people with more financial and audit data in our company. After using this tool, you can get twice the result with half the effort. What you do in five days can be finished in five minutes. Well done!

—— Feng Chunguang, Director of Human Resources of Qin Heng Building Energy Conservation Engineering Company

The biggest gain of this course is that I have a better understanding of the functions of excel. Let me broaden my working ideas. Compared with the original excel training, the content of this course is more targeted and practical.

—— Yuekong, HR Manager of Lianyou Communication Technology Development Company

Lecture courses:

Efficient Office and Data Statistical Analysis -Excel Application | Human Resource Management -Excel Application | Sales Management -Excel Application | Financial Management -Excel Application

Teaching style:

Humor | Rich cases | Practical drills | Easy to understand |

Customer service:

Shandong Huaxia Liangzi Group, Dongying Xincheng Petroleum Technology Co., Ltd., Beijing Meihualin Petroleum Technology Co., Ltd., FAW-Volkswagen, Jinan Water Group, Shandong Zhonghaigong Safety Equipment Co., Ltd., Luyin Group, Shandong Expressway, Suer Logistics, Sunshine 100, Wang Ling Elevator, Lianyou Communication, Qilu Real Estate, Qiqifa Commercial Real Estate, Linuoruite, Zhenyuan Group, Shandong Electric Power, Hongye.

Introduction to Microsoft excel Expert Certification Examination 2 I. Options and Settings for Managing Workbooks (10%- 15%)

* Manage workbooks

Save a workbook as a template, copy macros between workbooks, reference data in another workbook, use structured reference functions to reference data, enable macros in workbooks, and display hidden ribbon tabs.

Manage workbook checking

Restrict editing, protect worksheets, configure formula calculation options, protect workbook structure, manage workbook versions, and encrypt workbooks with passwords.

Second, the application of custom data format and layout (20%-25%)

Apply custom data formats and validation

Create a custom number format, fill cells with advanced fill sequence options, and configure data validation.

Apply advanced conditional formatting and filtering

Create custom conditional formatting rules, use formulas to create and manage conditional formatting rules.

Create and modify custom workbook elements

Create custom color formats, create and modify cell styles, create and modify custom themes, create and modify simple macros, and insert and configure form controls.

Prepare a workbook for internationalization.

Display data in multiple international formats, apply international currency formats, and manage multiple options for text and title fonts.

Third, create an advanced formula (35%-40%)

Apply a function to a formula.

Use AND, OR and NOT functions to perform logical operations; Use nested functions to perform logical operations; Use SUMIFS, AVERAGEIFS, and COUNTIFS functions to perform statistical operations.

Using functions to query data

Use VLOOKUP function to query data; Use HLOOKUP function to query data; Query data using matching function; Query data using index function

Apply advanced data and time functions

Use NOW and TODAY functions to reference date and time, and use date and time functions to serialize numbers.

Perform data analysis and business intelligence

Use the NOW and TODAY functions to refer to the date and time; Import, transform, merge, display and connect data; Integrate data; Use the target finder and the scene manager for hypothesis analysis; Use cube function to get data from Excel data model; Use financial functions to calculate data

Error in formula checking.

Track priorities and dependencies, monitor cells and formulas with monitoring windows, verify formulas with error checking rules, and evaluate formulas.

Defines the specified areas and objects.

Specify cells, specify data ranges, specify tables, and manage specified ranges and objects.

Fourth, create advanced charts and tables (25%-30%)

Create an advanced chart

Add a trend line to the chart, create a two-axis chart, and save the chart as a template.

Create and manage PivotTable reports

Create PivotTable, modify field selection and options, create slicer, use GETPIVOTDATA function to group PivotTable data and reference data in PivotTable, add calculated fields and set data format.

Create and manage pivotcharts.

Create a PivotChart, manipulate options in an existing PivotChart, apply styles to PivotChart, and learn more about PivotChart.

;