MindMap Gallery Learn Excel Mind Map
This is a mind map about learning Excel with Qiuye. The introduction is detailed and the description is comprehensive. I hope it will be helpful to those who are interested!
Edited at 2023-12-04 17:00:49One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
Project management is the process of applying specialized knowledge, skills, tools, and methods to project activities so that the project can achieve or exceed the set needs and expectations within the constraints of limited resources. This diagram provides a comprehensive overview of the 8 components of the project management process and can be used as a generic template for direct application.
One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
One Hundred Years of Solitude is the masterpiece of Gabriel Garcia Marquez. Reading this book begins with making sense of the characters' relationships, which are centered on the Buendía family and tells the story of the family's prosperity and decline, internal relationships and political struggles, self-mixing and rebirth over the course of a hundred years.
Project management is the process of applying specialized knowledge, skills, tools, and methods to project activities so that the project can achieve or exceed the set needs and expectations within the constraints of limited resources. This diagram provides a comprehensive overview of the 8 components of the project management process and can be used as a generic template for direct application.
一、 Getting started
1. WHAT
1||| super calculator
2||| Lazy artifact
3||| Data analysis and management tools
2. HOW
1||| Storage record table
2||| Calculation analysis table
3||| Output rendering table
3. interface
二、 Data Entry
1. Efficient data entry
1||| Current time and date
date
Ctrl;
time
Ctrl Shift:
2||| Enter the same content in batches
Ctrl Enter
3||| Select data areas in batches
continuous
Shift
Discontinuous
Ctrl
position
Find and select
4||| Cursor movement
right
Tab
Down
Enter
2. numeric serial number
3. Special data input method
1||| Numbers with 0
2||| standard date
3||| special symbols
4. Number types and formats
text
number
Date and time (special numbers)
5. Custom number format
example
1||| yyyy/mm/dd
2||| unit
0.00"ton"
3||| Fill in
0000
4||| Automatic segmentation of mobile phone numbers
000-0000-0000
5||| [Blue]0.00;[Red]-0.00
6||| 10,000 times switching
0!.0000
principle
Positive value; Negative value; Zero value; Text
Placeholder
0
occupy a position by force
#
Text type plus ""
Additional conditions[]
rainbow colors
conditional rules
@
!
_
G
use
Transformation
search
6. data verification
7. Images and PDF data
1||| Microsoft AI image recognition
2||| ABBYYFineReader
8. Web page data
1||| from website
2||| Paste URL
3||| Sure
4||| load
9. Data collection
Questionnaire website
questionnaire star
golden data
Tencent Questionnaire
三、 basic skills
1. Big data browsing
1||| Ctrl
superior
Down
Left
right
2||| freeze window
3||| Teleport
Double click on edge
Group collapse
data-grouping
Worksheet jump
Right click on the left navigation area
2. Beautify the form
Fill in alternate rows
Ctrl T
unified font
Ctrl A
row height column width
newline
Alt Enter
Alignment
3. Duplicate title
Page Layout-Print Title
4. Print one page
5. Prevent tampering
encryption
Protect workbook
Can not look
protect sheet
It can be seen but cannot be changed
Allow partial editing
Unlock
Allow editing
protect sheet
Hide worksheet
Temporarily lock screen
6. Print letters in batches
四、 Statistical Analysis
1. smart form
1||| Table conversion
Insert table
Ctrl T
2||| Summary results
Table Tools-Summary Rows
3||| Conditional filtering
4||| slicer
2. pivot table
五、 Data sorting
1. categorize
1||| delimiter
2||| fixed width
3||| Convert number format
2. Quick filling
1||| Extract string
2||| One can be divided into many
3||| Merge text
4||| Add characters
5||| Change letter case
3. Find and replace
1||| Skip to results
2||| work log
3||| Change characters
4||| Fuzzy replacement
5||| delete symbol
6||| Add characters
7||| Select limited area
area
Format
4. position
1||| blank filling
2||| Cancel merge fill
Position white space
=upward
3||| name positioning
4||| conditional targeting
constant
formula
null value
object
rectangle
text
picture
chart
Visible cells
Conditional Formatting
data verification
difference
OK
List
5. Remove duplicates
single column
Multiple conditions
6. paste special
Transpose
Operation
add
reduce
take
remove
7. filter
text
number
date
*?
double
Multiple
8. sort
number
text
local
Multiple conditions
customize
fast
Shift
六、 function formula
1. operator
*
/
^
second power
>=
<=
<>
not equal to
2. Operation method
count
Compare
text
3. Quote
relatively
absolute
4. function
Function
F1
category
finance
logic
text
date
Find citations
Mathematics and Trigonometric Functions
logic operation
IF
AND OR
Find
Match subject
VLOOKUP
Accurate
Vague
Automatically match those that do not match
HLOOKUP
LOOKUP
MATCH
location information
Mix
INDEX
intersection value
auxiliary reference
OK
row
Line number
rows
Rows
List
column
Column number
columns
Number of columns
INDIRECT
OFFSET
5. other
ROUND
rounding
ROUNDUP
All in
ROUNDDOWN
whole house
INT
Rounding
decimal
text
merge
&
one
CONCAT
many
TEXTJOIN
Many separators
extract
LEFT
RIGHT
MID
LEN
Clean
TRIM
space
CLEAN
invisible characters
Mix
Convert
text-numeric
TEXT
*1
--
date calculation
DATEDIF
Find month and year
TODAY
NOW
ROW
COLUMN
RAND
random
NETWORKDAYS
interval date
YEAR
MONTH
DAY
DATE
Specify date
EOMONTH
last day of month
math
MAX
COUNTA
count
Mask errors
IFERROR
6. Error handling
Citation tracking
formula switch
Step by step calculation
七、 Visualization
1. Highlight numbers
Exceed the standard
negative value
Distinguish between increases and decreases
2. Format highlighted cells
Numeric range
text contains
date range
Custom number format
Ranking range
Scale range
deviation from average
First and last
3. Graphically highlight cells
Longitudinal comparison
ranking
data strip
range interval
Hierarchical identification
color scale
Alarm reminder
Classification identification
Icon set
4. Formatting to highlight entire lines
single condition rule
Multiple condition rules
Select switch
dynamic reference
5. Sparklines
Polyline
columnar
Profit and loss
八、 Business charts
1. element
title
data
Illustration
grid
Label
coordinate
2. type
Column chart
Bar chart
line chart
area chart
pie chart
donut chart
Scatter plot
quadrant chart
Smooth Curve Scatter Plot
bubble chart
three dimensional
radar chart
Wire
noodle
3. New
Tree
Small data comparison
Similar to a bar chart
Product Categories
sunburst
Multilayer donut chart
Multi-dimensional display
waterfall chart
The evolution of data
flow of funds
funnel chart
The effect of layer-by-layer transformation
Histogram
Statistics
Distribution
box plot
K-line chart
4. complex
Thermometer diagram
1||| Primary and secondary axes
2||| The maximum values of the coordinate axes are consistent
bullet chart
target polyline
Complete the column
thick edge area chart
line chart
area chart
Highlight specific data
Blurred picture
control line diagram
average value
Online and offline
Creative illustration
icon fill
dash board
5. Express
Compare
Classification
Column chart
radar chart
Bar chart
sheet
map
time
Column chart
radar chart
line chart
distributed
Scatter plot
Histogram
Pareto chart
Normal distribution plot
boxplot
surface plot
constitute
static classification
pie chart
stacking percentage
Tree
sunburst
Time evolution
stacked column chart
stacked area chart
waterfall chart
association
Scatter plot
bubble chart
funnel chart
6. Effect
Cancel
3D
picture
Meaningless color changes
Unnecessary background padding
optional grid lines
Extra borders and shadows
weaken
Axis ticks and lines
Gridlines
number of colors
Non-core data tags
Non-core data series
super value
Maximum value modification
truncated
7. Paste
Paste as linked image
Paste icon format
九、 High efficiency secrets
Plug-in tools
excel easy-to-use treasure
E-ling (Excel treasure box)
square grid
Smart Office
Official app store
List of shortcut keys