Teacher Chen Ze introduced.
---officeSoftware and DataAnalyticsActual combatConsultants
Biography
Mr. Chen Ze has 10 years of senior work experience and 7 years of consulting and training experience; Mr. Chen has worked in large group companies such as South Korea and Japan, and has received international advanced office software system learning. He has a deep knowledge of PPT, Excel and its application in enterprise management, and is proficient in Excel and VBA in management and advanced application training, especially PPT intermediate and advanced design, PPT animation design, Excel and VBA in corporate finance, accounting, sales, human resources, finance and other management applications.
Mr. Chen has served as a full-time lecturer in more than 200 institutions such as BOE, CITIC Technologysoft, Yidex, Weipeng, Baishirui, and Dare Chao Training, and has rich experience in PPT design and production and strong Excel application development capabilities.
In 2013, Mr. Chen's first professional book was publishedPublished by Tsinghua University Press"Absolute! Excel can be used like this: The Essence of Business Chart Classic Cases, on major e-commerce platforms, sales are hot.
Over the years, Mr. Chen has presided over and completed the personnel and financial systems of many enterprises, and the business analysis and automatic reporting system of many enterprises in the communication industry.
Branded courses
Business analysis, data analysis
project2010 project management training.
SPSS training.
Tableau Data Visualization Design.
Excel statistics and analysis customization in the era of big data.
Telecom business analysis - EXCEL, PPT, SPSS skills training.
Enterprise operations management and data analysis models.
Data Analytics & Business**.
The application of data analytics in the retail industry.
Advanced applications of mind mapping in the workplace.
Automation of business analysis reports in the communications industry.
A picture is worth 10,000 words.
Marketing data analysis and SPSS mining.
Professional-level Excel VBA training: Use VBA for Excel secondary development.
Excel PPT Word three-piece training.
Office training (excel ppt word) 8 days.
PPT course design and development.
PPT business training (partial design).
PPT business application (basic operation).
Advanced typesetting and processing of Word.
Excel and PPT skills in the analysis and presentation of financial statements.
Kumon writing training.
Business PPT and structural logic design.
Email etiquette outlook application tips.
Summary and report PPT production.
Email etiquette + outlook practical application skills outline
Mail etiquette section
1. Format of the email.
1.Content Composition.
2.Formatting requirements.
Call. Greetings.
Body. Greetings.
Signature. Date.
2. Norms of business email etiquette.
1.A few important pieces of email etiquette.
2.Other etiquette: Be concise and to the point.
Answer all questions and give relevant information.
Correct spelling, grammar, and punctuation.
Personalized answers.
Use a template. Respond quickly.
Attachments. Layout.
Avoid misuse of symbols, capitalization.
Quote the original content reply.
Legal Disclaimer.
Read it yourself before you send it.
Use BCC to pay attention to hyperlinks and web page formatting.
Wait a minute. Outlook section
Chapter 1 Get to know Microsoft Outlook 2007
1.1 Introduction to Microsoft Outlook.
1.1.1 The history of Microsoft Office.
1.1.2 Who is Microsoft Outlook for.
1.1.3 Application areas of Microsoft Outlook.
1.2 Why should you use Microsoft Outlook
1.2.1 The basic functions of Microsoft Outlook are to quickly find the information you need.
1.2.2 The basic functions of Microsoft Outlook can easily complete schedule management.
1.2.3 The basic functions of Microsoft Outlook are connected across boundaries.
1.3 What's new in Microsoft Outlook 2007.
1.3.1 Advantages of Microsoft Outlook 2007.
1.3.2 What's new in Microsoft Outlook 2007.
Chapter 2 Efficient Transaction Management Methods for Microsoft Outlook.
2.1 Efficient transaction management with Microsoft Outlook support.
2.1.1 How can we be better busy?
2.1.2 Microsoft Outlook helps us to deal with external factors quickly and efficiently.
2.1.3 Microsoft Outlook helps us deal with internal factors quickly and efficiently.
2.2 Efficient transaction management methods.
2.2.1 GTD – A widely accepted and applied solution for efficient transaction management.
2.2.2 An effective method of time management - ABC scale method.
2.2.3 Four-quadrant element method.
2.3 The combination of Microsoft Outlook and GTD, a classic method of time management abroad.
Chapter 2 Basic functions of Microsoft Outlook.
Chapter 3 Mail.
3.1 Mail Usage.
3.1.1 Basic Email Operations.
3.1.2 Use email quickly and efficiently.
3.2 Personalized email creation.
3.2.1 Create and set up e-mails using stationery.
3.2.2 Set up signed emails.
3.2.3 Create a poll email.
Chapter 4 Contacts.
4.1 Contact Overview.
4.1.1 Contact.
4.1.2 Basic Contacts Settings.
4.2 Contact folder - a good helper for email management.
4.2.1 Create a new message with your contact.
4.2.2 Create a new task with a contact.
4.2.3 Create a new journal entry.
4.2.4 Establish a new meeting request for a contact.
4.2.5 Contact sorting.
4.3 Have your own "Contacts" (Manage Contacts).
4.3.1 Contact view.
4.3.2 Customize the current view.
4.3.3 Add a follow-up flag for the contact.
4.4 Other settings for contacts.
4.4.1 Call Contact.
4.4.2 Contact grouping (i.e., the creation of a "distribution group").
4.4.3 Contact Screening.
4.4.4 Add custom fields for contacts.
Chapter 5 Calendar.
5.1 Calendar Overview.
5.2 One's Stage: Dating.
5.2.1 Create an appointment.
5.2.2 Make a date a regular appointment.
5.2.3 Change an appointment.
5.2.4 Set or clear reminders.
5.3 Activities throughout the day: Events.
5.3.1 About Events.
5.3.2 Create an event.
5.3.3 Editing Events.
5.3.4 Manage activities that occur on specific dates of the year by setting up events.
5.Event for 4 people: Meeting.
5.4.1 Schedule a meeting.
5.4.2 Schedule regular meetings.
5.4.3 Meeting Requirements.
5.4.4 Respond to meetings.
5.5 Browse the calendar.
5.5.1 Check your calendar.
5.5.2 Switch calendars.
Chapter 6 Tasks.
6.1 Task management tools.
6.1.1 Basic task settings.
6.1.2 Task options and to-dos.
6.1.3 Fast-moving missions.
6.2 Manage tasks.
6.2.1 Assign tasks.
6.2.2 Task view.
6.2.3 Task arrangement.
6.3 Find and search tasks.
6.3.1 Find your tasks at any time (Find Tools).
6.3.2 Make good use of advanced lookup.
Chapter 7: Notes.
7.1 Sticky note introduction.
7.1.1 Overview of the note.
7.1.2 Basic operation of sticky notes.
7.2 Manage your own notes.
7.2.1 Sticky note view.
7.2.2 Sort notes.
7.2.3 Customize the Sticky Notes view.
7.3 Organize the sticky notes.
Chapter 8: Diary.
8.1 Diary.
8.1.1 Diary Overview.
8.1.2 Basic Operations.
8.1.3 Create a journal entry.
8.1.4 Open the journal entry.
8.1.5 Delete journal entries.
8.2 Journal view.
8.2.1 Toggle the journal view display mode.
8.2.2 Journal view display type.
8.3 Journal management apps and settings.
8.3.1 Journaling activity related to a contact.
8.3.2 Manage settings journals.
Chapter 9 Outlook 2007 Customization and Management.
9.1 Customize the toolbar.
9.1.1 Show and hide toolbars.
9.1.2 Create and delete toolbars.
9.1.3 Add & Remove buttons.
9.1.4 Change the appearance of the buttons.
9.2 Customize Outlook 2007 panels.
9.2.1 Show and hide the navigation pane.
9.2.2 Show and close the Reading Pane.
9.2.3 Show and hide the to-do bar.
9.3 Customize the current view.
9.3.1 Customize the display fields.
9.3.2 Customize the grouping by.
9.3.3. Custom sorting and filtering.
9.3.4 Customize other settings.
9.3.5 Customize automatic formatting and column formatting.
9.4 Customize the view.
9.4.1 Copy and modify the standard view.
9.4.2 Create a new view.
9.5 Edit the Settings Options view.
9.5.1 Set the Preferences tab.
9.5.2 Set up the Mail Settings tab.
9.5.3 Set the Message Format tab.
9.5.4 Set the Other tab.