MindMap Gallery Excel Basics

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:41

Mason·Carter

Recent works View more works>>

Rumi 10 spiritual high-dimensional awakenings
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.
Pathophysiology - Heart failure
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.
Pathophysiology - ischemia - reperfusion injury
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

Mason·Carter

Recent works View more works>>

Recommended to you
Outline

Using MS Office for Planning
- 51
Zoya Abid
The story of developing a top student
- 59
- 2
PlotWizard
Ancient Literature (History of Foreign Literature)
- 41
- 2
- 1
PlotWizard
Breakthroughs and reversals in the second trial and retrial
- 24
PlotWizard
First-class Construction Engineer Examination Summary of Knowledge Points in Chapter 1 of Engineering Economics
- 37
PlotWizard
Common sense of Chinese literature
- 116
PlotWizard
Windows 7 operating system
- 72
PlotWizard
Word word processing
- 43
PlotWizard
Multiple linear regression mind map_copy
- 92
PlotWizard
International Finance Chapter 1 - Balance of Payments
- 188
PlotWizard

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