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

Data Analysis

  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Use Data Form to input, edit and delete records in Excel
  • How to Create Area Chart in Excel
  • Get column index in Excel Table
  • How To Create Frequency Distribution in Excel

References

  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel INDIRECT Function
  • How to get first column number in range in Excel
  • Count rows that contain specific values in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Data Validations

  • Excel Data validation must contain specific text
  • Excel Data validation with conditional list
  • Excel Data validation whole percentage only
  • Excel Data validation date in next 30 days
  • Excel Data validation exists in 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

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

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

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

  • Return blank if in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • Invoice status with nested if in Excel
  • How to return blank in place of #DIV/0! error in Excel

Date Time

  • How to get Weekdays, Working days between Two Dates in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Generate series of dates by weekends in Excel
  • Get first day of previous month in Excel
  • Dynamic date list in Excel

Grouping

  • Map text to numbers in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel
  • How to randomly assign people to groups in Excel
  • Running count group by n size in Excel

General

  • How to get amount with percentage in Excel
  • Excel Operators
  • Freeze and Unfreeze Panes in Excel
  • Flash Fill in Excel
  • Sum by group in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning