Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Thermometer Chart in Excel
  • How to Use Solver Tool in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How to create dynamic reference table name in Excel
  • Number and Text Filters Examples in Excel

References

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Two-column Lookup in Excel
  • Find closest match in Excel
  • Left Lookup in Excel
  • How to get first column number in range in Excel

Data Validations

  • Excel Data validation must begin with
  • How To Create Drop-down List in Excel
  • Excel Data validation allow weekday only
  • Excel Data validation whole percentage only
  • Excel Data validation with conditional list

Tag: View Tab

Freeze and Unfreeze Panes in Excel

by

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet. Freeze Top Row To freeze the top row, execute the following steps. 1. On the View tab, in the Window group, click …

Continue Reading

Excel Workbook Views

by

Excel offers three workbooks views, Normal, Page Layout and Page Break Preview. Normal At any time, you can switch back to Normal view. 1. On the View tab, in the Workbook Views group, click Normal. Result: Note: if you switch to another view and return to Normal view, Excel displays page breaks. Close and reopen the Excel file to hide …

Continue Reading

Things you find in Excel Status Bar

by

The quickest way to see the average, count, numerical count, minimum, maximum or sum of selected cells is by taking a look at the status bar. 1. Select a range of cells. 2. Look at the status bar at the bottom of your window to see the sum of these cells. 3. Right click the status …

Continue Reading

Zoom Worksheet in Excel

by

Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection. In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. 1. To quickly zoom the document, use the minus and plus symbols in the status bar. To zoom …

Continue Reading

View Multiple Workbooks at The Same Time in Excel

by

If you want to view multiple Excel workbooks at the same time, execute the following steps. 1. First, open two or more workbooks. 2. On the View tab, in the Window group, click Arrange All. 3. Select the desired arrange setting. For example, click Horizontal. 4. Click OK. 5. On the View tab, in the Window group, …

Continue Reading

Split Worksheet Window in Excel

by

To view multiple distant parts on worksheet at once, you will need to split your worksheet. To split your worksheet (window) into an upper and lower part (pane), execute the following steps. 1. First, select a cell in column A. 2. On the View tab, in the Window group, click Split. 3. Notice the two vertical scroll …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Check multiple cells are equal in Excel
  • Nested IF function example in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Calculate date overlap in days in Excel
  • Add workdays to date custom weekends in Excel
  • Calculate expiration date in Excel
  • Pad week numbers with zeros in Excel
  • How to calculate most recent day of week in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Group numbers at uneven intervals in Excel
  • Group numbers with VLOOKUP in Excel
  • Map text to numbers in Excel

General

  • Find, Select, Replace and Go To Special in Excel
  • How to increase by percentage in Excel
  • Using Existing Templates in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
  • How to calculate percent change in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning