MindMap Gallery Excel Basics
This is a mind map about the basics of Excel. The main contents include: workbooks and worksheets, printout worksheets (page layout) tabs, page setting groups, organize and modify tables, and enter and edit data.
Edited at 2025-03-03 18:32:41Rumi: 10 dimensions of spiritual awakening. When you stop looking for yourself, you will find the entire universe because what you are looking for is also looking for you. Anything you do persevere every day can open a door to the depths of your spirit. In silence, I slipped into the secret realm, and I enjoyed everything to observe the magic around me, and didn't make any noise. Why do you like to crawl when you are born with wings? The soul has its own ears and can hear things that the mind cannot understand. Seek inward for the answer to everything, everything in the universe is in you. Lovers do not end up meeting somewhere, and there is no parting in this world. A wound is where light enters your heart.
Chronic heart failure is not just a problem of the speed of heart rate! It is caused by the decrease in myocardial contraction and diastolic function, which leads to insufficient cardiac output, which in turn causes congestion in the pulmonary circulation and congestion in the systemic circulation. From causes, inducement to compensation mechanisms, the pathophysiological processes of heart failure are complex and diverse. By controlling edema, reducing the heart's front and afterload, improving cardiac comfort function, and preventing and treating basic causes, we can effectively respond to this challenge. Only by understanding the mechanisms and clinical manifestations of heart failure and mastering prevention and treatment strategies can we better protect heart health.
Ischemia-reperfusion injury is a phenomenon that cellular function and metabolic disorders and structural damage will worsen after organs or tissues restore blood supply. Its main mechanisms include increased free radical generation, calcium overload, and the role of microvascular and leukocytes. The heart and brain are common damaged organs, manifested as changes in myocardial metabolism and ultrastructural changes, decreased cardiac function, etc. Prevention and control measures include removing free radicals, reducing calcium overload, improving metabolism and controlling reperfusion conditions, such as low sodium, low temperature, low pressure, etc. Understanding these mechanisms can help develop effective treatment options and alleviate ischemic injury.
Rumi: 10 dimensions of spiritual awakening. When you stop looking for yourself, you will find the entire universe because what you are looking for is also looking for you. Anything you do persevere every day can open a door to the depths of your spirit. In silence, I slipped into the secret realm, and I enjoyed everything to observe the magic around me, and didn't make any noise. Why do you like to crawl when you are born with wings? The soul has its own ears and can hear things that the mind cannot understand. Seek inward for the answer to everything, everything in the universe is in you. Lovers do not end up meeting somewhere, and there is no parting in this world. A wound is where light enters your heart.
Chronic heart failure is not just a problem of the speed of heart rate! It is caused by the decrease in myocardial contraction and diastolic function, which leads to insufficient cardiac output, which in turn causes congestion in the pulmonary circulation and congestion in the systemic circulation. From causes, inducement to compensation mechanisms, the pathophysiological processes of heart failure are complex and diverse. By controlling edema, reducing the heart's front and afterload, improving cardiac comfort function, and preventing and treating basic causes, we can effectively respond to this challenge. Only by understanding the mechanisms and clinical manifestations of heart failure and mastering prevention and treatment strategies can we better protect heart health.
Ischemia-reperfusion injury is a phenomenon that cellular function and metabolic disorders and structural damage will worsen after organs or tissues restore blood supply. Its main mechanisms include increased free radical generation, calcium overload, and the role of microvascular and leukocytes. The heart and brain are common damaged organs, manifested as changes in myocardial metabolism and ultrastructural changes, decreased cardiac function, etc. Prevention and control measures include removing free radicals, reducing calcium overload, improving metabolism and controlling reperfusion conditions, such as low sodium, low temperature, low pressure, etc. Understanding these mechanisms can help develop effective treatment options and alleviate ischemic injury.
Excel Basics
Enter and edit data
the term
Workbooks and worksheets, worksheet tags
Name box, column label, row number, active cell, editing bar
enter
Enter values and text, text-type numbers, dates
Enter the English half-width state before the number and trigger it immediately
ctrl; it can directly display the date of the same day
filling
Methods to automatically fill sequences (drag the fill handle, use the fill command, right-click to drag)
Number: Dragging the left button directly is to copy, and dragging the left button with ctrl increments in sequence: if there are numbers in the text content, the opposite is true.
Fill sequence (number, date, text, custom), fill formula, quick fill (need two or more examples)
verify
Data verification (enumeration, number of digits, range of numerical values, unique)
(Data) Tab, (Digital Tools) Group
edit
Edit status, edit bar, clear data
The difference between deleting cells and clarifying the content and format of cells
Organize and retouch tables
Select an object
Select cells, whole rows, whole columns, continuous areas, continuous non-adjacent areas
Select the entire table, select the area with data, and quickly locate it
Row Operation
Adjust row height and column width, hide rows and columns, insert rows and columns, delete rows and columns, move rows and columns
Set fonts
Set font, font size, alignment
Border fill
Set borders and fill colors
Prefabricated style
Automatically apply formatting and create tables in worksheets (Tables in tables can be converted into zones in the "Tools" of "Table Design" and can be turned into normal zones)
Use topics
Use built-in themes, custom themes ((page layout) tabs, (theme) groups)
Digital format
Excel provides built-in digital format and basic methods to set digital formats
Customize number formats (number format codes, commonly used placeholders, create new number formats)
Conditional Format
Use prefabricated rules to achieve rapid formatting and custom rules to achieve advanced formatting
difficulty
Printout worksheet (page layout) tab, page setting group
Page Settings
Margins, paper direction, paper size, setting printing area, setting header and footer
Print title
Set print title, print preview
(Page Layout) Tab, (Page Settings) Dialog, (Header\Footer)
Print range
Set the printing range and print
(Page Layout) tab, (Page Settings) group, print range
Workbooks and worksheets
Workbook
Create a new workbook, set password, encrypt file, close the workbook and exit Excel
General options in "Tools" when saving
Create a template, create a workbook with a custom template, modify the template
Open the workbook and publish the workbook to PDF\XPS format
Hide and protect workbooks
(Review) tab, (Protect) group, "Protect Workbook" (mainly a protection structure, which means that the worksheet cannot be created or the worksheet name cannot be modified); "Protect Worksheet" (referring to the table content cannot be modified) or (View) tab, (Window) group, "Hide"
Worksheet
Insert worksheets, delete worksheets, change worksheet names, set worksheet label colors
Move or copy worksheets, show or hide worksheets, insert hyperlinks
Protect the entire worksheet, contact the protection of some worksheet areas, allow specific users to edit, and undo some
Select multiple worksheets, operate multiple worksheets at the same time, and fill in group worksheets
Use Ctrl or Shift to select multiple worksheets at the same time. After changing one of the worksheets, click the (Start) tab, (Edit) group, and "Fill" to the same group worksheets, and the changes will be synchronized to all selected tables.
View control of the work window, using query add-ons for version comparison and management, and adding comments
(View) tab, (Window) group, freeze first row
(Review) tab, (Annotation) group, add comments, there is a purple-red triangle symbol in the upper right corner of the cell with comments.
Meaning of different symbols
0 means placeholder, displayed as 0 when there are insufficient digits. # indicates placeholder, no 0 is displayed when the number of digits is insufficient ? Indicates the alignment of the decimal points,? The numbers before the 0 represent the number of decimal places , indicating the thousandth meter "" can attach characters after a number, such as "meta" Adding a comma to the end can reduce the number by a thousand times What to add after @, what will happen after the number display []Color setting and conditional formatting, up to three groups can be set
Custom fill sequence
Edit custom list in files, options, advanced, general