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

Data Analysis

  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to Create One and Two Variable Data Tables in Excel
  • How to sum a total in multiple Excel tables
  • Filter Data Based on Date in Excel
  • Data Series in Excel

References

  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Two-way lookup with VLOOKUP in Excel
  • How to get last row in numeric data in Excel
  • How to get address of first cell in range in Excel
  • How to use Excel MMULT Function

Data Validations

  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation must not contain
  • Excel Data validation with conditional list
  • Data validation must not exist in list

Tag: View Tab

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

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

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

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • How to use Excel OR Function
  • How to use Excel NOT Function
  • IF with wildcards in Excel

Date Time

  • Get last working day in month in Excel
  • Display the current date and time in Excel
  • Get first day of previous month in Excel
  • Calculate total hours that fall between two times in Excel
  • Count dates in current month in Excel

Grouping

  • Group arbitrary text values in Excel
  • How to randomly assign data to groups in Excel
  • Group times into unequal buckets in Excel
  • Running count group by n size in Excel
  • Map text to numbers in Excel

General

  • How to choose page/paper size in Excel before Printing
  • Convert column letter to number in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Split Cell Content Using Text to Columns in Excel
  • Find, Select, Replace and Go To Special in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning