search
HomeSoftware TutorialComputer SoftwareGetting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

Confused about creating Excel tables? don’t worry! PHP editor Xiaoxin brings you an introductory tutorial to teach you how to get started easily. This tutorial covers a variety of table creation methods, from basic to advanced, and will be explained to you one by one. Whether you are an Excel novice or an advanced expert, I believe you will be able to find the knowledge you need and improve your spreadsheet-making skills. Come find out and take your Excel experience to the next level!

Preface: In this example of excel table creation, a simple monthly sales forecast table with charts will be created.

1. Start creating a worksheet

Start Excel and make sure an empty workbook is displayed in the software. To create a new blank workbook, press Ctrl+N (this is the shortcut key for File | New | Blank Workbook).

The sales forecast table will contain two columns of information: Column A contains the month name, and column B stores the expected sales numbers. First, enter a descriptive title into the worksheet. The following explains how to get started:

(1) Use the navigation (arrow) keys to move the cell pointer to cell A1 (the upper-left corner cell of the worksheet). The cell's address appears in the Name box.

(2) Type the month in cell A1 and press Enter. Depending on the setting, Excel moves the cell pointer to other cells or keeps the cell pointer in cell A1.

(3) Move the cell pointer to B1, type the project sales volume, and press Enter. The text will exceed the cell width, but don't worry about it just yet.

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

2. Fill in the month name

In this step of making the excel table, enter the month name in column A.

(1) Move the cell pointer to A2 and type Jan (the abbreviation of January’s name). At this point, you can either manually enter the abbreviations of other month names, or you can use the autofill function to let Excel complete the related work.

(2) Make sure cell A2 is selected. Note that the border of the active cell will appear as a thick line. In the lower right corner of the border, a small square appears called a fill handle. Move your mouse pointer over the fill handle, click and drag down until cells A2 through A13 are highlighted.

(3) Release the mouse button and Excel will automatically fill in the month name.

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

3. Enter sales data

In the next excel table creation process, provide sales forecast numbers in column B. Assume that the January sales forecast is $50,000 and that sales will increase by 3.5% each month thereafter.

(1) Move the cell pointer to B2, and then type in the expected sales in January, which is 50,000. You could type a dollar sign and comma to make the number clearer, but this example will format the number later.

(2) To enter the formula to calculate the expected sales in February, you need to move to cell B3 and type the following: =B2*103.5%. When the Enter key is pressed, the cell displays 51750. This formula returns the contents of cell B2, multiplied by 103.5%. In other words, February sales are expected to be 103.5% of January sales, a 3.5% increase.

(3) Use a similar formula for projected sales in subsequent months. However, instead of re-entering the formula for each cell in column B, take advantage of the AutoFill feature. Make sure that cell B3 is selected, then click that cell's fill handle, drag down to cell B13, and release the mouse button.

At this point, the worksheet should look something like the image below. Remember, with the exception of cell B2, the rest of the values ​​in column B are calculated using formulas. For demonstration purposes, try changing the projected sales for the month (in cell B2) and you will notice that Excel recalculates the formula and returns a different value. However, these formulas all rely on the initial value in cell B2.

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

4. Set the format of numbers

Currently, the numbers in the worksheet made by excel are difficult to read because there is no Format them. In the next steps, number formatting will be applied to make the numbers easier to read and consistent in appearance:

(1) Click cell B2 and drag and drop to cell B13 to select the number . Here, don't drag the fill handle because you're selecting cells, not filling an area.

(2) Access the ribbon and select Start. In the Number group, click the Number Format drop-down control (which initially displays General ) and select a currency from the list. The currency symbol will now appear in the cells of column B starting with the number - and will display two decimal places. This looks much better! However, decimal places are not necessary for this type of prediction.

(3) Stellen Sie sicher, dass der Bereich B2:B13 ausgewählt ist, wählen Sie Start | Zahlen und klicken Sie auf die Schaltfläche „Dezimalstellen reduzieren“. Eine der Dezimalstellen verschwindet. Klicken Sie erneut auf die Schaltfläche und der Wert wird ohne Nachkommastellen angezeigt.

Der Endeffekt ist wie folgt:

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

5 Machen Sie das Arbeitsblatt attraktiver

At Zu diesem Zeitpunkt haben Sie bereits ein Arbeitsblatt mit entsprechenden Funktionen, können das Erscheinungsbild aber auch verschönern. Es ist äußerst praktisch, diesen Bereich in eine formale (attraktive) Excel-Tabelle umzuwandeln:

(1) Aktivieren Sie eine beliebige Zelle im Bereich A1:B13.

(2) Wählen Sie Tabelle |. Excel zeigt das Dialogfeld „Tabelle erstellen“ an, um sicherzustellen, dass der Bereich korrekt ermittelt wurde.

(3) Klicken Sie auf OK, um das Dialogfeld „Tabelle erstellen“ zu schließen. Excel wendet sein Standardtabellenformat an und zeigt die Kontextregisterkarte „Tabellentools |“ an.

An diesem Punkt sieht Ihr Arbeitsblatt wie im Bild unten aus:

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

Wenn Ihnen dieser Tabellenstil nicht gefällt, können Sie auch Ihren eigenen wählen über die Designleiste Der Excel-Tabellenstil

6. Summieren Sie die Werte

Das von der Excel-Tabelle erstellte Arbeitsblatt zeigt die erwarteten monatlichen Umsätze, jedoch die erwarteten insgesamt für das ganze Jahr Wie hoch sind die Umsätze?

Da es sich bei diesem Bereich um eine Tabelle handelt, ist es einfach, den Gesamtumsatz für das ganze Jahr zu ermitteln.

(1) Aktivieren Sie eine beliebige Zelle in der Tabelle.

(2) Wählen Sie Tabellen-Design-Optionen |. Excel fügt am Ende der Tabelle automatisch eine Zeile hinzu, die eine Formel enthält, die die Zellen in der Spalte „Geschätzte Verkäufe“ summiert.

(3) Wenn Sie eine andere Zusammenfassungsformel (z. B. Durchschnitt) verwenden möchten, klicken Sie auf Zelle B14 und wählen Sie eine andere Zusammenfassungsformel aus der Dropdown-Liste aus.

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

7. Erstellen Sie ein Diagramm

Der letzte Schritt besteht darin, ein Diagramm zu erstellen, das die geschätzten monatlichen Verkäufe im anzeigen kann Prozess zum Erstellen einer Excel-Tabelle. Was ist das Diagramm?

(1) Aktivieren Sie eine beliebige Zelle in der Tabelle.

(2) Wählen Sie „Diagramm |“ aus. Excel zeigt dann einige empfohlene Diagrammtypoptionen an.

(3) Klicken Sie im Dialogfeld „Diagramm einfügen“ auf das zweite empfohlene Diagramm (Säulendiagramm) und dann auf „OK“. Excel fügt das Diagramm in der Mitte des Fensters ein. Um das Diagramm an eine andere Position zu verschieben, klicken Sie auf den Diagrammrand und ziehen Sie ihn.

(4) Klicken Sie auf das Diagramm und wählen Sie einen Stil aus, indem Sie die Option Diagrammstil | verwenden. Das Bild unten zeigt ein Arbeitsblatt, das ein Säulendiagramm enthält. Je nachdem, welchen Diagrammstil Sie wählen, sieht Ihr Diagramm möglicherweise anders aus.

Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making

The above is the detailed content of Getting Started with Excel Table Making for Beginners_Free Tutorial on Excel Table Making. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
how to unlink rockstar account from steamhow to unlink rockstar account from steamMar 11, 2025 pm 07:39 PM

This article explains how to unlink a Rockstar Games Social Club account from Steam. The process involves using the Rockstar Games Launcher to manage linked accounts, removing the Steam connection without impacting game progress or future Steam purc

[PROVEN] Steam Error e87 Fix: Get Gaming Again in Minutes![PROVEN] Steam Error e87 Fix: Get Gaming Again in Minutes!Mar 18, 2025 pm 05:56 PM

Article discusses causes of Steam Error e87, including network issues, security software, server problems, outdated clients, and corrupted files. Offers prevention and solution strategies.[159 characters]

why is steam downloading so slowwhy is steam downloading so slowMar 11, 2025 pm 07:36 PM

Slow Steam downloads stem from various factors: network congestion (home or ISP), Steam/game server issues, limited bandwidth, high latency, and computer hardware limitations. Troubleshooting involves checking internet speed, optimizing Steam settin

Steam Error e87: What It Is & How to Fix ItSteam Error e87: What It Is & How to Fix ItMar 18, 2025 pm 05:51 PM

Steam Error e87 occurs during Steam client updates or launches due to connection issues. Fix it by restarting devices, checking server status, changing DNS, disabling security software, clearing cache, or reinstalling Steam.

Easy Fix: Steam Error e87 Explained & SolvedEasy Fix: Steam Error e87 Explained & SolvedMar 18, 2025 pm 05:53 PM

Steam Error e87, caused by connectivity issues, can be fixed without reinstalling by restarting, checking internet, and clearing cache. Adjusting Steam settings helps prevent future occurrences.

Steam Error e87: Why It Happens & 5 Ways to Fix ItSteam Error e87: Why It Happens & 5 Ways to Fix ItMar 18, 2025 pm 05:55 PM

Steam Error e87 disrupts gaming on Steam due to connectivity issues. The article discusses causes like unstable internet and server overload, and offers fixes like restarting Steam and checking for updates.

how to add page numbers in google docshow to add page numbers in google docsMar 14, 2025 pm 02:57 PM

The article details how to add, customize, start from a specific page, and remove page numbers in Google Docs using step-by-step instructions.

How to Fix Steam Error Code e87: The ULTIMATE GuideHow to Fix Steam Error Code e87: The ULTIMATE GuideMar 18, 2025 pm 05:51 PM

Article discusses fixing Steam Error Code e87, caused by network issues, corrupt files, or client problems. Provides troubleshooting steps and prevention tips.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version