Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Offset in Excel
  • Last row number in range
  • How to use Excel VLOOKUP Function
  • How to use Excel LOOKUP Function
  • How to reference named range different sheet in Excel

Data Analysis Examples

  • Move chart to a separate worksheet in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • How to create running total in an Excel Table
  • How to create a Histogram in Excel
  • How to perform a t-Test in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation whole percentage only
  • Excel Data validation allow weekday only
  • Excel Data validation no punctuation
  • Excel Data validation specific characters only

Category: Others

Excel Tutorials for beginners, Intermediates and experts.

How to setup and print Excel worksheets

by

Print a Worksheet What to Print  Multiple Copies  Change Page Orientation Adjust Page Margins Use Scaling to Fit Sheet on One Page Excel obviously allows you to print your worksheets to a printer. Sometimes a worksheet will fit on a single page, but other times it will flow to another page. These steps teaches you how …

Continue Reading

Steps To Password Protect a Workbook in Excel

by

Limit Others From Accessing Excel Workbook by Adding Password To Your File. Encrypt an Excel file with a password so that it requires a password to open it. 1. Open a workbook. 2. On the File tab, click Save As. 3. Click Browse. 4. Click on the Tools button and click General Options. 5. In the Password to open box, …

Continue Reading

How to choose page/paper size in Excel before Printing

by

1. How do you know which paper size when you want to print in Excel? 2. Selecting a Paper Size Working excel files is one thing, knowing what paper size to print completed work is another. In most cases, you’ll use the standard 8.5-x-11-inch letter-sized paper to print your worksheets. However, if you find that …

Continue Reading

How To Change Paper Orientation In Excel

by

— Print a worksheet in landscape or portrait orientation Default paper orientation is mostly  portrait. Excel can fit three more columns of information on the page in landscape mode than it can in portrait mode. 2 Ways to change page orientation in Excel Because many worksheets are wider than they are tall (such as budgets or sales …

Continue Reading

Select, Insert, Rename, Move, Delete Worksheets in Excel

by

How To: Select, Insert, Rename, Move, Delete A Worksheet From A Workbook A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets. Select a Worksheet in Excel When you open an Excel workbook, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its sheet …

Continue Reading

Creating and Opening an existing file in Excel Workbook

by

A workbook is another word for your Excel file as referred by Microsoft.. And, also a workbook comprises of several worksheets depending on the user. When you start Excel, click Blank workbook to create an Excel workbook from scratch. Open an Existing Workbook To open a workbook you’ve created in the past, execute the following steps. 1. On the File …

Continue Reading

Understanding Cell Ranges, Auto fills, Copy/Paste, Insert Row, Column in Excel

by

CELL Ranges People find it difficult to understand Cell Ranges in Excel. To effectively work with formulas it is apparent to have a good knowledge of selections (cell ranges) in Excel. A range in Excel is a collection of two or more cells. Excel Office will take you through an overview of some very important range operations. N/B: Microsoft refers …

Continue Reading

Excel Ribbon: Navigation, Customizing, Collapsing and All You Need To Know

by

How to Navigate through Excel Ribbon? Excel Ribbon are directly below File, Home, Insert, Page layout, Formulas, Data, Review and View tabs. Excel selects the ribbon’s Home tab when you open a workbook. You can checkout our previous post on Working with Excel ribbon. Customize Excel Ribbon The essence of customizing the ribbon is mainly to add more command …

Continue Reading

Working with and Understanding Excel Ribbon

by

What is Excel Ribbon? Excel ribbon is a strip of buttons and icons located above the work area that was first introduced in Excel 2007 version. The ribbon replaces the menus and toolbars found in earlier versions of Excel. Above the ribbon are a number of tabs, such as File, Home, Insert, Page layout, Formulas, Data, Review …

Continue Reading

230 Excel Shortcut Keys

by

Many times, people wonder and call their colleagues wizard following how proficient they are in using Microsoft Office Excel. There’s no magic in excel like using shortcut keys to manipulate records swiftly without breaking your back. The excel shortcut keys make us work 10 times faster than using the normal conventional way to solve office challenges. …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3

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
  • How to Capitalize first letter in a sentence in Excel
  • Find function vs Search function in Excel
  • How to convert numbers to text using TEXT function in Excel
  • How to strip numeric characters from cell in Excel
  • Add line break based on OS in Excel
  • Get days, months, and years between dates in Excel
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Get month from date in Excel
  • Display Days until expiration date in Excel
  • How to join date and text together in Excel
  • DB function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • PV function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles