Related recommendations: Software information computer software Mobile phone software

EXCEL video tutorial

Part I: Excel Practical Skills
Lesson 1: Skill Teaching Lesson 2: General Formula Lesson 3: Advanced Skills 01 Lesson 4: Charting Lesson 5: Auto Fill Lesson 6: Function Query Lesson 7: Accounting and financial treatment Lesson 8: Tips Lesson 9: A05 Data Validity Lesson 10: Data security maintenance of electronic forms Lesson 11: A07 PivotTable Lesson 12: Database Query Lesson 13: Advanced Skills Lesson 14: Data Filtering Lesson 15: Advanced Skills 03 Lesson 16: Operating Skills Excel Practical Skills Lesson 17: Table Making Lesson 18: Functions and Formulas Lesson 19: If function automatic filtering Lesson 20: Interaction between MATLAB and Excel Lesson 21: Use of electronic forms Lesson 22: GUI file reading drawing Lesson 22: MM chasing schedule Lesson 23: Love Plan Statistics Lesson 24: Printing Charts Lesson 25: GUI interface realizes file saving Lesson 26: Table Making Lesson 27: Making a VBA Example Clock Lesson 28: Principal Calculation Function Lesson 29: Batch Import Access Lesson 30: Da Qian Connection Lesson 31: Complete set of shortcut keys Lesson 32: Function and Chart Application Lesson 33: Usage of Find Function Lesson 34: Making customer data management table Lesson 35: Filtering Data and Canceling Filtering Lesson 36: Hide lines that do not need to be printed Lesson 37: Calculate the current age according to the date Lesson 38: Print the label content Lesson 39: Tracking Referenced Cells Lesson 40: Horizontal and vertical printing, centered printing

Excel Text Tutorial

Part I: Beginner's Guide
Interface Introduction Function introduction New Blank Table New Document from Template Save File Scheduled Save Cancellation and recovery
Part II: Data input
Numerical format Currency format Date and time settings Score Type Percentage format Fast data entry Import. txt file
Part III: Table Making
Insert Cells, Rows, and Columns Delete Cells, Rows, and Columns Drag Cell Settings Add Comments remove annotations Insert Hyperlink Batch Delete Hyperlink Freeze Window Protect Cells Format brush Clear cell content and formatting Row height and column width Hide Rows and Columns merge cell Gridline Settings Add background picture Table Border Settings Conditional formatting Add Delete Worksheet Move and Copy Switch and Rename shared workbook
Part IV: Data Management
Color Filter Conditional format application Data sorting Find Replace Remove duplicate values Data validity
Part V: Chart Insertion
Column Chart Gantt Chart Line Chart Composite Pie Bidirectional Bar Chart sparkline Insert Picture Insert Clip Art insert draw SmartArt Screenshot tool
Part VI: Formulas and Functions
Formula input method COUNTIFS function IFERROR function SUMIFS function Time function Int function AVERAGEIF function ABS function MOD function Round function
Part 7: Protect Printing
Document encryption Clear Open Document Information Print Area Settings Margins Print Preview

Excel video tutorial ranking

one Lesson 1: Skill Teaching
two Lesson 4: Charting
three Lesson 2: General Formula
four Lesson 26: Table Making
five Lesson 5: Auto Fill
six Lesson 18: Functions and Formulas
seven Lesson 3: Advanced Skills 01
eight Lesson 19: If function automatic filtering
nine Lesson 21: Use of electronic forms
ten Excel Practical Skills Lesson 17: Table Making

Excel text tutorial ranking