归档: Cordelia

  • How to Converted Decimals into Fractions in Microsoft Excel

    时间:2019-8-26 作者:Cordelia

    When you are processing data in Microsoft Excel, the results of calculations or the numbers you need to enter won’t always be integers. So, if you’ve got a batch of decimals in the worksheet, how can you convert them into fractions or vice versa? There’s 2 commonly used methods: 1. Percent Style First, select all […]

  • How to Insert Alternate Blank Rows in Excel Spreadsheet

    时间:2019-8-26 作者:Cordelia

    It’s not rare to insert a blank row between 2 existing rows as a new header while making specific spreadsheets like salary sheets. Instead of right-clicking one cell and choose to insert a new row manually, you can actually batch create new rows alternatively using AutoFill and Go To feature of Excel. Open the worksheet […]

  • What is the Best Time to Drink Coffee at Work

    时间:2019-8-26 作者:Cordelia

    Coffee is the stimulation for many office workers who wake up early to get to the company and come home till late. Drinking coffee becomes a irresistible and indispensable living habit due to the long time hard working. What’s the Best Time to Drink Coffee Early before going to work, during the lunch break, and […]

  • How to Add a Number to All Cells in Excel

    时间:2019-8-26 作者:Cordelia

    While editing a spreadsheet in Microsoft Excel, you may encounter a situation which requires you to add a number to all cells in a column or a table. Doing the calculation manually and filling the cells one by one is apparently not the best idea. In fact, you can use Paste Special to achieve this […]

  • How to Use Conditional Formatting to Shade the Specified Data in Excel

    时间:2019-8-23 作者:Cordelia

    The so-called Conditional Formatting, is a practical feature with which Excel can set the format of the corresponding data. One example is that when you want to highlight some specified data in a spreadsheet, you can use Conditional Formatting to shade them automatically avoiding a lot of manual operations. First, select the range of cells […]

  • 5 Factors About Listening Music While Reading and Working

    时间:2019-8-23 作者:Cordelia

    Music is pleasurable, whether philosophers or ordinary people alike agree it. But the answer to questions like “Is listening music good for reading and working” and “What kind of songs works better in improving efficiency” seems to depend on personality all along and won’t come to a uniform conclusion. Nowadays, however, you might get a […]

  • How to Print a Part of a Spreadsheet in Microsoft Excel

    时间:2019-8-23 作者:Cordelia

    Printing out a spreadsheet in Excel may not be a hard thing for you, but there’re also some tips can make you do the job better. For example, if you just want to print a part of the table in the worksheet, and it can hardly fill the width of a A4 paper, you’d better […]

  • How to Add Frames to Pictures in Microsoft Office

    时间:2019-8-22 作者:Cordelia

    To make some basic adjustments to pictures that you want to insert into Office programs, you don’t need to find any third party picture editing tools, MS Office can help you do most of the things. And the steps are all the same in Microsoft Word, Excel, and PowerPoint. For example, if you want to […]

  • How to Insert a Text Box to Excel Worksheets

    时间:2019-8-22 作者:Cordelia

    Different from the text in cells, a text box can be placed at anywhere in Microsoft Excel as the label or comment of the spreadsheet in a separate window. To insert a text box, you should switch to Insert tab at first, then find the button of Text Box in Text section. Click it to […]

  • 10 Useful Tips to Lose Weight and Keep Fit in Office Hours

    时间:2019-8-22 作者:Cordelia

    Recently I saw a news that an office worker had gained more than 10 kg in a year. It’s kind of surprising but not exaggerated actually, because nowadays a lot of people work at office, which requires them to stay in a sitting posture all day long. It can easily lead to fat accumulation. Think […]