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

Excel: Top 10 Tips for Beginners



Microsoft Excel is an incredibly powerful and complex spreadsheet program. If you only have wet feet, these tips will help you to create a table and write a formula. Once you've learned the vocabulary, the rest will be easier.

Open Excel and select a blank workbook

  01 Open a new blank Excel worksheet JD Sartain / IDG Worldwide

Open a new blank Excel workbook [1

9659006] To use with Excel Start, click on the Excel icon on your desktop or in the Start menu. Excel opens with the cursor on option Blank Workbook .

A workbook is the Excel file. Just click once on Blank Workbook or press Enter. An empty workbook opens with an empty table. You can add spreadsheets to the workbook by clicking the plus sign tab at the bottom of the workbook viewer. You can also change the order of the worksheets in the workbook by moving their tabs left or right along the tab row. Finally, you can name the tabs and the entire workbook.

Setting Up an Excel Spreadsheet: Columns and Fields

The classic spreadsheet format is similar to that of an accountant or accountant. Column letters are at the top (these are the fields) and row numbers at the left (these are records). Remember the traditional calendar format: The days of the week are at the top, and the days of the week that correspond to each day of the week are in the rows below the days of the week.

The fields (or columns) are unique data and can not be repeated, for example: For example, there must not be two Thursdays. The records (or rows) are placed under the columns. In this example, you could have five different days on a Thursday in a month. In a more complicated system, you could have 50 fields with 150 to 5,000 (or more) records in each field.

Excel Spreadsheets

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

Each cell is essentially defined by its column letter and line number, e.g. For example, & # 39; cell A1 & # 39; for the cell at the top left. In this earlier story, you'll learn how to navigate the cells of an Excel spreadsheet.

How Excel Ribbons Work

The Excel menus (called Ribbons) are at the top of the screen. The tabs above are the main menus. Click on one of these tabs. The submenus for this tab are shown below. The tabs are highlighted in dark green, and the selected / active tab turns white.


Source link