Office software Excel/Word/PPT zero-based intensive course

Learn to master: Acquire a complete office knowledge system through learning, solve common clerical problems in daily work, and be competent for daily clerical secretarial and other administrative work.

Suitable for: Students aged 18-45 who have no basic knowledge and want to improve their office Excel skills, fresh graduates who are interested in Excel and other office software and are engaged in daily office clerks, secretarial work, administration, etc.; Students who are not efficient in daily Excel work and need to frequently use Baidu to solve Excel problems;

Chapter 1: Computer Basics
1.1:1.1 Basic Computer Knowledge (Part 1) 08 minutes 16 seconds [Free]
1.2: 1.2 Basic Computer Knowledge (Part 2) 05 minutes 58 seconds [Free]
Chapter 2: Computer Operation Skills
2.1: 2. Computer operation skills: 1. Typing keys 2. C drive precautions 03 minutes 18 seconds [free]
2.2: 2. Computer operation skills: 3 shortcuts to recognize 4 files and folders 02 minutes 37 seconds [free]
2.3: 2. Computer operation skills: 5 Renaming file extensions 6 Sending files 02 minutes 49 seconds [free]
2.4: 2. Computer operation skills: 7 File transfer from mobile phone to computer 8 Software installation and uninstallation 03 minutes 00 seconds [free]
2.5: 2. Computer operation skills: 9 compression and decompression 10 email sending 02 minutes and 31 seconds [free]
2.6: 2. Computer operation skills: 11 Use of favorites 12 Antivirus and cleanup 01 minutes 47 seconds [free]
Chapter 3: Word Course
3.1: 3.1 Word interface understanding 05 minutes 43 seconds [trial learning]
3.2: 3.2 Common input skills, special symbols, selection skills 05 minutes 03 seconds [trial learning]
3.3: 3.3.1-3 font installation, bold, italic, underline, text highlight color, superscript and subscript 04 minutes and 16 seconds [trial learning]
3.4: 3.3.4-6 Use of the format brush, paragraph alignment, bullet numbering, display and hide marks 04 minutes and 03 seconds [paid]
3.5: 3.3.7-9 Line spacing and paragraph spacing, how to indent the first line by two characters, correct pagination 04 minutes 40 seconds [paid]
3.6:3.4 Application of Word tables (1) 06 minutes and 08 seconds [paid]
3.7:3.4 Application of Word tables: Case operation (2) 06 minutes and 05 seconds [paid]
3.8:3.5 Application of Insert Shape (1) 07 minutes 01 seconds [paid]
3.9:3.5 Application of Insert Shape: Case Operation (2) 07 minutes 13 seconds [paid]
3.10：3.6 Insert amartart application (1) 04 minutes 08 seconds [paid]
3.11：3.6 Inserting the application of amartart: Case operation (2) 02 minutes and 31 seconds [paid]
3.12: 3.7 Application of text boxes, how to insert headers, footers and page numbers, modify page margins, printing precautions 05 minutes 00 seconds [paid]
3.13:3.8 Long document typesetting 11 minutes and 54 seconds [paid]
3.14: 3.9-3.14 9 Bookmarks 10 Annotations Footnotes Endnotes 11 View documents side by side 12 How to add watermarks to documents 13 How to set image backgrounds 14 Set document borders 07 minutes 20 seconds [paid]
Chapter 4: Excel Intensive Course
4.1:1 Excel interface understanding and basic operations.mp417 minutes and 26 seconds [paid]
4.2:2 Commonly used and efficient office skills in Excel 13 minutes and 25 seconds [paid]
4.3: 3.1 Definition of formula and function 3.2 Relative and absolute mixed reference 3.3 Application of simple function 3.4 Application of counting function on attendance sheet 11 minutes and 50 seconds [paid]
4.4: 3.5 date and dateif time functions 3.6 string extraction function 3.7 use of columns 3.8 find precise search function 13 minutes and 40 seconds [paid]
4.5: 3.9 if function and mod function 3.10 countifcountifs function 3.11 sumifsumifs function 15 minutes 47 seconds [paid]
4.6: 3.12 Use of wildcards 3.13 vlookup and index and match functions 06 minutes 44 seconds [paid]
4.7:4 Excel Business Chart Creation 12 minutes 12 seconds [paid]
4.8:5.1 Application of Excel Pivot Table 05 minutes 42 seconds [paid]
4.9:5.2 Data Management and Data Analysis (Conditional Formatting, Freeze Split, Filtering, Sorting, Subtotal) 10 minutes and 39 seconds [paid]
4.10:6 Encryption and protection of EXCEL tables 05 minutes 24 seconds [paid]
Chapter 5: ppt course
5.1: ppt: Pre-class knowledge 08 minutes 04 seconds [paid]
5.2:1.1 Introduction to the ppt work window 02 minutes 34 seconds [paid]
5.3:2.1 Steps in making a PPT 02 minutes 00 seconds [paid]
5.4: 3.1 How to create a new slide 3.2 Adjust the size and direction of the PPT 3.3 Use of sections in PPT 02 minutes 57 seconds [paid]
5.5: 3.4 Image beautification 3.5 Use of screenshots 05 minutes 42 seconds [paid]
5.6: 3.6 How to use smartart intelligent graphics 3.7 How to insert a hyperlink 3.8 How to add audio and video 05 minutes 03 seconds [paid]
5.7:3.9 Cover case practice 03 minutes 40 seconds [paid]
5.8: 2. 1. What is the PPT format? What is ppt master 03 minutes 10 seconds [paid]
5.9: 2, 2, Principle of Master Setting 08 minutes 01 seconds [paid]
5.10: 2, 3, layout settings and ppt master 02 minutes 10 seconds [paid]
5.11: 2, 4, PPT template design steps 04 minutes 26 seconds [paid]
5.12: 2. Catalog Page Case Practice 04 minutes 26 seconds [paid]
5.13: III. Animation Setting Tips 05 minutes 31 seconds [paid]
5.14: Part III: Content Page Case Study 08 minutes 45 seconds [paid]
5.15: 4.4.1 Slideshow Settings 4.2 How to Set Up a Custom Show 4.3 Rehearsal Timing and Clearing Rehearsal Timing 03 minutes 23 seconds [paid]
5.16: 4.4 Operation of recording slide show 4.5 How to set up automatic playback of PPT 4.6 Full playback of PPT with background music 03 minutes and 32 seconds [paid]
5.17: Five, 5.1 Printing of ppt 5.2 Encryption of ppt 5.3 Converting ppt into corresponding format 5.4 Free material website of ppt 03 minutes and 59 seconds [paid]
5.18: Five, steps to optimize the internal pages of PPT