قالب وردپرس درنا توس
Home / Tips and Tricks / Excel: Top 10 tips for beginners

Excel: Top 10 tips for beginners



Microsoft Excel is an incredibly capable and complex spreadsheet program. If you wet your feet, these tips will help you create a spreadsheet and write a formula. Once you learn the vocabulary, the rest becomes easier.

Open Excel and choose an empty workbook

  01 open a new empty Excel worksheet JD Sartain / IDG Worldwide

Open a new empty Excel workbook

] To start in Excel, click on the Excel icon on your desktop or on the Start menu. Excel is opened with the cursor on the option Empty workbook .

A workbook is the Excel file. All you have to do is click once on Empty workbook or press the Enter key and an empty workbook opens to an empty spreadsheet. You can add spreadsheets to the workbook by clicking on the tab with a "+" sign at the bottom of the workbook screen. You can also change the order of spreadsheets in the workbook by sliding their tabs to the left or right along the tab row. Finally, you can name the tabs and give the entire workbook a name.

Setting up an Excel spreadsheet: Columns and fields

The classic spreadsheet format is similar to the ledger of an accountant or accountant. Column letters go at the top (these are the fields) and row numbers on the left (these are records). Consider the traditional calendar format: the days of the week are at the top and the days of the month that correspond to each day of the week are on the rows below the days of the week. The fields (or columns) are unique data and cannot be repeated ̵

1; for example, there cannot be two Thursdays. The records (or rows) are placed under the columns. In this example you can have five different days on Thursday in a single month. In a more complicated system you can have 50 fields with 150 to 5,000 (or more) records in each field.

Excel spreadsheet cells

Each small box in a spreadsheet grid is a cell that can contain numbers, letters, colors, and formulas. Every field, every row and every record is in its own cell in the Excel worksheet.

Each cell is fundamentally defined by the column letter and row number, such as & # 39; Cell A1 & # 39; for the cell at the top left. View this earlier story about navigating through the cells in an Excel spreadsheet.

How Excel ribbon menu & # 39; s work

The Excel menus & # 39; s (called ribbon menu & # 39; s) are at the very top of the screen. The tabs at the top are the main menu & # 39; s. Click on one of these tabs and the & # 39; s submenus for that tab appear below. The tabs have a dark green background and the selected / active tab turns white.


Source link