Introduction2018-12-22T01:06:54+00:00

Excel Basics

1. Introduction: Excel is the world's most popular spreadsheet and is part of the Microsoft Office suite. In this chapter, we will go over basic Excel elements such as cells, columns, rows, and how to open, resize and close an Excel workbook, check more…

2. Data Format: An Excel cell can hold different type of data such as a numeric value, text and formula.

Numeric data can be a number, currency, date or time;

Text data is the names, labels, explanations etc, some numeric data can also be formatted to Text; and

Formula is the functions or expressions that we calculate a result.

In this chapter, we will introduce how to enter data and format them to the way we want, check more…


3. Font and Cell Styles: The data in a cell can be formatted into different styles by changing font color, size, background of the cell, even the border of cells. In this chapter, we will introduce all these different tricks to make your work in a professional way, check more…

4. Columns/Rows: Columns and Rows are basic elements of the Excel spreadsheet. Columns are named by letters A to Z, then AA, AB…till XFD in Excel 2016 and 2019, and Rows are named by numbers from 1 to 1,048,576 in Excel 2016 and 2019. In this Chapter, we will introduce how to insert, hide, unhide and delete columns or rows to make your work with Excel much easier, check more…

5. Worksheet: A worksheet is the spreadsheet that hods your data that you are working on, and a workbook can have multiple worksheets. In this chapter, we will introduce how to insert, rename, hide, move and copy a worksheet, we will also introduce how to change tab color, sort tabs alphanumerically, and even clear the contents in a worksheet, check more…

6. HyperLinks and Print: Hyperlinks are convenient and very useful, and they will quickly direct you to the data portion you want. In this Chapter, we will introduce how to add, change or clear a hyperlink in different scenarios. We will also explain how to print your work, which is one of the key parts working with Excel, check more…

7. Workbook Protect and Share: Once you finish your work, you might need to share your work with others, and sometimes we need to protect our work so only the proper persons can see or modify our work. In this chapter, we will discuss how to share with email or OneDrive, and learn how to protect our work, check more…




Recent Posts


Excellent Notes!

Excellent notes & great ideas directly deliver to your mailbox, FOR FREE!
JOIN NOW
close-link