Course Background:
The word, excel and powerpoint tools in office software have become important tools and software essential for elites in today's business office. However, time in the workplace is precious, so you must be efficient and have combat effectiveness!When you are facing:
Asking for immediate delivery, but the document layout always goes wrong?
In the face of massive data, it is a mess to sort it out
Excellent work ability, when you encounter a report, you will be in a mess
It is particularly important to use these 3 software well, and you can easily face most of the work scenarios by operating office software fully and proficiently, thereby greatly improving work efficiency. "Playing with Office: Building Efficient Office Combat Effectiveness in the Workplace".The course will provide a comprehensive introduction to the use of the Office Three Musketeers tools, so that newcomers in the workplace who have a basic foundation in Office software but are often trapped by application skillsProfessionals who work overtime and are eager to be more productive;College graduates who need to master one core skill;Personnel in administrative secretarial, human resources, sales, accounting, treasury management and other positions who need to use office to enhance their core competitiveness can apply what they have learned through the operation and drill of actual cases, master the operation and application of the three major components, and easily promote from office novice to office master.
Course Benefits::
Comprehensively improve the use of office software, thereby improving overall work performance;
Change the office concept, improve the enthusiasm and initiative of work;
Master the practical editing and processing skills of word documents;
Make PPT with a new concept and standardized process;
Closely combined with workplace cases, it comprehensively covers the essence of all aspects of Excel's efficient management.
Course Highlights:
The avenue is simple, comprehensive and rich.
Case-based, practical.
Emphasis on hands-on, extended exercises.
Course Duration:2 days, 6 hours a day.
Course Target:General managers of various enterprises and managers of sales, administration, marketing, human resources, technology and other positions, as well as all professionals and related personnel who want to master word+excel+powerpoint.
Course Method:Theoretical explanation + case teaching + teacher interaction + in-class guidance + hands-on training.
Teaching Software:Participants should bring their own laptops and install Office2016 and above versions in advance (if not, the teacher can provide a broken version of Office2019 installation package).
Course outline
excelTools: Use ** tools to build data analysis power
Lecture 1: Design principles and necessary skills for Excel Workplace Efficient Management
Import:Rethink Excel** and how to use it.
1. ** and the standardization paradigm of data
1.* Standardization and design principles.
2.Distinguish and identify application scenarios between 1D tables and 2D tables.
3.Standardization and entry specifications of data (date, time, text, numbers).
Second, the rapid sorting of data practical skills
1.Quickly modify illegal dates in reports and return dates to their original appearance.
2.Quickly modify illegal numbers in a report so that it can be calculated.
3.Quickly populate data to ensure data integrity.
4.Quickly separate data to make the structure more reasonable.
3. Use data to verify and standardize the collection of data
1.Only the specified data (integers, decimals, texts, dates, and times) can be entered
2.Only the specified sequence data is allowed to be entered.
3.Invalid data in the Quick Circle**.
Applications:Use custom sorting to make data reports clear at a glance.
Applications:Use advanced filtering to quickly find and extract analytical data.
Applications:Classification and summary and combined calculation make your financial exchange with one click.
Applications:Intelligent** enables dynamic management of analytical data.
Lecture 2: Necessary common function formulas in the workplace (logical judgment, data statistical summary, data search).
1.Basic knowledge of formulas and functions.
2.The application of three reference methods of cell address in different statistical scenarios.
3.Use names in formula functions to make formulas more concise and easy to understand.
There are two types of issues that should be paid attention to when using formulas in foreign exchange
1) Handling of errors generated during the calculation of formula functions.
2) Handling of errors generated during statistical summary of formula functions.
5.Ideas and methods for applying formula functions when solving complex problems.
6.* Calculation of date data: efficient application of date and advance functions (today edate datedif and other functions).
7.Quick extraction of summaries or notes in **: Efficient use of text functions (left midight and other functions).
8.*Logical judgment of data: efficient application of logical functions (if ifs and other functions).
9.*Data statistics summary application: efficient application of classification and summary functions under single and multiple conditions.
countif countifs sumif sumifs).
10.*Data search application: methods and techniques of precise search, fuzzy search and location search.
vlookup match index).
Lecture 3: Efficient Application of Pivot Table in Data Analysis
1.Application scenarios and functions of pivot tables.
2.Basic methods and considerations for creating pivot tables.
3.Use pivot tables to quickly compile and analyze various statistical analysis reports.
Use the five functions of pivot tables to quickly summarize and analyze reports
1) Set the field calculation method to analyze the report from multiple angles.
2) Set the font segment display mode to perform multi-level analysis of the report.
3) Use custom calculation fields to quantify the report.
4) Use pivot tables to create the detailed reports you want.
5) Quickly produce monthly, quarterly and annual reports through the combination function.
5.Use pivot tables to quickly complete year-on-year and month-on-month analysis.
Lecture 4: Use charts and graphs to visualize your analysis reports
1.Types of charts, their selection principles, and applicable scenarios.
2.The structure of the chart and the setting techniques of each major element.
3.Methods and techniques for creating data analysis charts.
4.Commonly used analysis chart grooming and beautification techniques.
5.Draw combo charts to put data questions on a single page.
wordTools: Learn to use Word to typeset documents
Lecture 1: Word tools are used quickly
First, if you want to do a good job, you must first sharpen your tools
1.Added settings for a quick access toolbar.
2.Word option must know the settings.
3.Five view modes for Word documents.
4.How to apply the ruler.
2. Quick operation of document text browsing
1.Easily compare content in context.
2.Quick page turning when browsing documents.
3.Use the Selection pane tool to work with multiple cascading objects.
4.Quickly zoom in or out of the display scale of a document.
5.Use the navigation pane to quickly navigate the overall structure of the document.
6.Quickly convert Word to PDF for reading.
Lecture 2: You must know how to typeset text paragraphs
1. The operation skills of the text module
1.Text input (date, time, special characters, circled text).
2.Editing operations for documents.
3.Different ways to select text.
4.Cut and copy, delete and modify.
5.Find-Replace for documents is applied in depth.
6.Quick error checking of text.
7.Check for spelling and grammar errors.
8.Use annotations.
9.Revise the document.
2. Operational skills of the paragraph module
1.Paragraph layout quickly - indentation, spacing, etc.
2.Bullet & document numbering settings.
3.Document multi-level list settings.
4.Document alignment to the operation of the applied tab stops.
5.Application of Chinese typography.
3. Application skills of document style
1.Use the default quick style for text content.
2.Create personalized styles in your documents.
3.Modify and update document styles.
4.Apply multi-level numbering to the style setup.
5.Generate document navigation directories through styles.
Fourth, the layout and beautification of documents
1.Set the page layout (paper size, orientation, margins).
2.Format fonts (text effects, character spacing, shading borders).
3.Column layout.
4.Set up a special typography.
5.Add a header and footer to your document.
6.Use separators to divide file content (page breaks, section break apps).
7.Automatically generate a table of contents for documents.
Lecture 3: Fair Use in Documentation**
1. Create**
1.Insert with templates.
2.Draw manually.
3.Use the dialog box to insert **.
4.Draw a slash header.
2. Editor**
1.Insert rows and columns in **.
2.Merge and split cells.
3.Automatically adjust row height and column width.
4.Adjust the alignment of **.
3. Beautification**
1.Set the border and shading.
2.Apply the ** style.
Fourth, the processing of the data in **
1.Repeat the header line of **.
2.Cleverly remove ** unlined extra blank pages.
3.Apply a simple formula function in **.
Lecture 4: Document automation makes your typesetting more efficient
1. Create a multi-level number
1.What is multi-level numbering.
2.Apply multi-level numbering to Word presets.
3.Create a new multi-level number.
4.Associates multi-level numbering with styles.
2. Set the header and footer
1.Make the content in the header and footer of the homepage different from the other pages.
2.Have different header and footer content for odd and even pages.
3.Displays the header and footer content from the specified page.
4.Make the header and footer content different for each page.
3. Generate directories and indexes
1.The mechanism for creating a table of contents in Word.
2.Insert the preset directory provided by Word.
3.Automatically create a table of contents with header styles.
4.Create an index by manually tagging index entries.
4. Use the mail merge function to create multiple documents of the same type in batches
1.How mail merge works and the general process.
2.The type of master document and data source in the mail merge.
3.Batch production of meeting invitations and**.
pptTools: Use PPT tools to build persuasiveness
Lecture 1: Standardize the process and improve efficiency
1.Evolution of PPT and new features in the version.
2.Interface interaction: quickly get started with the software.
Basic settings: Do more with less
1) Increase the number of undoable operations.
2) Customize the Quick Access Toolbar.
3) Install personalized fonts.
4.Plug-in selection, installation, and resource acquisition.
5.Standardized process of PPT production.
6.Two ways to generate PPT with one click.
Lecture 2: Distinguish between templates and masters, and quickly create your own theme templates
1.Apply the template: bypass the pit selected by the template.
2.Use themes: Pages change instantly.
3.Understanding Masters: The difference between a layout and a master.
Master typography: Design the typography you need
1) Use of placeholders.
2) Batch adjustment and replacement of fonts.
3) Customize the color settings.
5.The page style is inconsistent with the master and is reset.
6.Use the chapter function to manage page content.
7.Reuse slides: The lazy trick of referencing other PPT pages.
Lecture 3: Design and production of text elements
Think:What font should I use?Commercial use should pay attention to the copyright of fonts.
1.Settings for text effects.
2.Basic beautification requirements for text boxes.
Quickly optimize large text PPT pages
1) The principle of five deletions and one retention.
2) Refine the key points and weaken the auxiliary.
3) Use shapes to guide the key points.
4) Take advantage of the presenter view.
4.Boolean operations and filling effects for advanced text processing.
Lecture 4: Multiple Ways to Play with Shape Elements
1.Demonstration and introduction to the use of shapes.
2.Use shapes to improve PPT force.
3.Merge Shapes: A deep understanding of Boolean operations.
4.Edit vertices: The shape changes dramatically.
5.Draw shapes with shapes.
Lecture 5: How elements are handled
1.*The role and principles of use.
2.*Effect added, **expressive.
3.* Cutout techniques.
4.*Split into nine squares.
5.* Tips for using masks.
Lecture 6: Consistent Handling Rules
First, the design and beautification of data
1.The ** data in PPT is synchronized with the excel sheet.
2.* Design layout of the tool.
3.* Landscaping design.
Second, the production and beautification of data charts
1.Column chart and bar chart beautification.
2.Beautification of line charts.
3.Beautification of pie charts.
3. How to use the SmartArt tool
Lecture 7: Color matching rules and application skills
1.Excellent PPT color matching routine.
2.There are 3 common color matching methods for PPT.
3.Use the color wheel to approximate and contrast colors.
4.One-click color change of PPT color picker and theme.
5.Learn to use Set Gradient Colors.