Click the "Book an Appointment" button to make an appointment for free live learning
Keywords: basics; excel tutorial; skills
The full text is 780 words and is expected to be read in 2 minutes
★
edit
★
1
Open commonly used Excel files
Put the commonly used Excel file on top (File - Open - click the small arrow to the right of the file name), open it directly when you use it, OK. This will make you more efficient in opening files, so you won't have to rummage on the computer every time.
2
Delete multiple useless excel worksheets
Delete one first, select another worksheet and press F4 to delete it directly. Note: The F4 key can repeat the previous operation. For those who use laptops, please use FN+F4. Watch the animation below.
3
Quick date entry
The date of this year only needs to enter the month and day, and the year will be automatically generated. For example, if you enter 2-4, Excel will automatically display it as: 2018/2/4; if you enter the date of the day, press ctrl+; directly to enter.
4
Use custom formatting
Operation of entering a three-digit job number: the front of the job number is a unified text, such as: tribe nest education, we can use a custom format to simplify the input.
Set the cell format - custom - "tribal nest education" ###
Writing rules: #: Number placeholder, a symbol represents a number placeholder; @: Text placeholder; "": Specific content (content is determined).
There are many application scenarios of the custom format, such as simplifying the input of email, mobile phone number, ID number and other information.
5
Pivot tables make summaries easy
On the left is the daily ledger. In order to analyze and check, we need to summarize the highest sales of the day. Some partners will say to use functions. In fact, pivot tables should be the best solution. Make a pivot table, and finally sort the sales, and it is very intuitive to see the daily sales ranking.
Simply drag and drop, and the desired data results are in front of you.
Online Consulting Excel Course
Recommended reading
Follow us to discover more Excel quality tutorials
10 times better than VLOOKUP! This is the easiest way to calculate quarters
Course recommendation
Complain about being in the dark, it's better to walk forward with a lantern
Your " Like ", " Watching " and " Share " are the driving force for our continuous output.