Streamline Your Workflow Through Basic Excel Skills

Learning the basics of Microsoft Excel will butter-smooth your Excel workflow; hence you can be hyper-productive.

 

SKILL Matters

Master Excel with Our Comprehensive Guides

Our extensive guides on Microsoft Excel are designed to help you become an expert in no time. From basic concepts to advanced techniques, discover the full potential of Excel with ExcelGraduate.

Excel Functions
Excel Formulas
Charts & Graphs
Power Query
Pivot Table
Excel for Business
Advanced Excel
Excel VBA

Our Recent Posts

Frequently Asked Questions

That’s because your spreadsheet is in Read Only mode. To change the settings,

  1. Right-click on your spreadsheet file name.
  2. From the pop-up menu, choose Properties.
  3. Under the General tab, look for the Attributes option. You will find it at the bottom of the General tab.
  4. Uncheck the Read Only option.

That’s because your cell border is not wide enough to display the contents into the cell. Drag the right border of the cell further away to avail enough space for the cell content. This will solve the problem.

  1. First, press CTRL + H keys to avail the Find and Replace dialog box.
  2. Keep the mouse cursor in the Find What box.
  3. Then press and hold the ALT button and type 0160. This will insert a hard space into the Find What box.
  4. After that leave the Replace With box blank.
  5. Now hit the Replace All button.
  1. Go to the Formulas tab.
  2. From the Formula Auditing group, click on the Show Formulas button.

Or, press CTRL + ~ keys together to display the cell formulas.

  1. Click on the cell where you want to insert the current date.
  2. After that type =NOW() into that cell.
  3. Then hit the ENTER button.

Because your Calculation Options feature is set to Manual. To set it to Automatic.

  1. Go to the Formulas tab.
  2. From the Calculation group, click on the Calculation Options.
  3. From the drop-down list, click on Automatic.