MS EXCEL



TABLE OF CONTENT

PART ONE: GET STARTED WITH MICROSOFT EXCEL        

1.1. Introduction To Ms Excel         

1.2 Launching And Exploring Excel

1.3 Start A New Spreadsheet         

1.4 Widen An Excel Column

1.5. Formatting Cells

1.6. How To Enter Text And Numbers In Cell       

1.7 How To Edit Text In A Cell        

1.8 How To Centre Text And Numbers

1.9 Font Formatting 

1.10 How To Change The Colour Of A Cell           

1.11 How To Save Your Work In Excel      

1.12 Currency Symbols In Excel    

1.13 How To Merge Cells    


PART TWO: A MORE COMPLEX SPREADSHEET      

2.1 Introduction        

2.2 How To Use Autofill       

2.3 Entering Simple Addition Formula       

2.4 The Sum Function  


PART THREE: EXCEL CHARTS     

3.1 How To Sort Data          

3.2 Create An Excel Chart  

3.3 Resizing An Excel Chart

3.4 Chart Styles And Chart Layouts          


PART FOUR: FUNCTIONS IN EXCEL      

4.1 The Average Function In Excel

4.2 The Date Function In Excel      

4.3 Time Functions In Excel

4.4 Financial Functions                   

 

PART FIVE:  PROCESSING DATA IN EXCEL   

5.1 Data Tables In Excel     

5.2 Goal Seek In Excel        

5.3 Absolute Cell References         

5.4 Named Ranges In Excel

 

PART SIX: MACROS – AUTOMATION

6.1 Macros – Automation    


PART SEVEN: ADVANCED EXCEL

7.1 Create A Worksheet Template

7.2 Dropdown Lists In Excel

7.3 Web Integration 

7.4 How To Insert Hyperlinks In Excel       

     

PART EIGHT: PRINTING WITH EXCEL    

8.1 Viewing and Printing      

 

 

 

Comments

Post a Comment

Popular posts from this blog

INSTALLATION OF LINUX OS (UBUNTU) IN YOUR COMPUTER

Image
WHAT IS THE COMPUTER INSTALLATION This is how to connect the computer before use for example install it with operating system, driver, Microsoft office, adobe and so on and connect it also to the keyboard, monitor, mouse and to the power either direct or indirect. First before we continue with installation, we need to connect the computer to the monitor, keyboard and mouse and to the power through UPS or direct to the main supply. After that we switch on the computer and insert the CD which contain operating system and continue. WHAT IS THE FORMATTING OF A COMPUTER Is the process of remove or delete software program or data in a computer for example we format operating system due to virus and replace it with another operating system or format data and replace it with new data. There are many methods of formatting computer either through the disk by go to my computer on your desktop and erase all data from it, if your computer has affected by virus the best way is to format th...
Read more

INSTALLATION OF WINDOWS SERVER IN YOUR COMPUTER

Image
What is the computer installation This is how to connect the computer before use for example install it with operating system, driver, Microsoft office, adobe and so on and connect it also to the keyboard, monitor, mouse and to the power either direct or indirect. First before we continue with installation, we need to connect the computer to the monitor, keyboard and mouse and to the power through UPS or direct to the main supply. After that we switch on the computer and insert the CD which contain operating system and continue. What is the formatting of a computer Is the process of remove or delete software program or data in a computer for example we format operating system due to virus and replace it with another operating system or format data and replace it with new data. There are many methods of formatting computer either through the disk by go to my computer on your desktop and erase all data from it, if your computer has affected by virus the best way is to format the...
Read more

INSTALLATION OF WINDOWS 11 PRO IN YOUR COMPUTER

Image
WHAT IS THE COMPUTER INSTALLATION This is how to connect the computer before use for example install it with operating system, driver, ms-office, adobe and so on and connect it also to the keyboard, monitor, mouse and to the power either direct or indirect. First before we continue with installation, we need to connect the computer to the monitor, keyboard and mouse and to the power through UPS or direct to the main supply. After that we switch on the computer and insert the CD which contain operating system and continue. WHAT IS THE FORMATTING OF A COMPUTER Is the process of remove or delete software program or data in a computer for example we format operating system due to virus and replace it with another operating system or format data and replace it with new data. There are many methods of formatting computer either through the disk by go to my computer on your desktop and erase all data from it, if your computer has affected by virus the best way to format, I will exp...
Read more

INSTALLATION OF WINDOWS 10 PROFESSIONAL IN YOUR COMPUTER

Image
What is the computer installation This is how to connect the computer before use for example install it with operating system, driver, ms-office, adobe and so on and connect it also to the keyboard, monitor, mouse and to the power either direct or indirect. First before we continue with installation, we need to connect the computer to the monitor, keyboard and mouse and to the power through UPS or direct to the main supply. After that we switch on the computer and insert the CD which contain operating system and continue. What is the formatting of a computer Is the process of remove or delete software program or data in a computer for example we format operating system due to virus and replace it with another operating system or format data and replace it with new data. There are many methods of formatting computer either through the disk by go to my computer on your desktop and erase all data from it, if your computer has affected by virus the best way to format, I will exp...
Read more

HOW TO CHANGE THE COLOUR OF A CELL

Image
  In the previous lesson, you saw how to change the font and font size in Excel. In this lesson, we'll look at how to change the color of a cell.   Change the Background Color of a Cell   To change the background color of cells, you first must highlight the ones you want to alter. We'll start with the cells A2 to A5. So, highlight these cells on your spreadsheet.   With the cells A2 to A5 highlighted, locate the Font panel on the Ribbon at the top of the Excel: (The image below is from Excel)     ·          Locate the Paint Bucket and click the arrow just to the right of it. You'll see some colors appear:   Move your mouse over any of the colors and the cells will change automatically. You can then see what the new color looks like. Click with the left mouse button to set the color you want. If you don't like any o...
Read more

UNDERSTANDING BASIC COMPUTER TERMS

Image
   Data  is electronic information. A computer file  is a collection of data stored as an individual entity. Computers contain many different types of files, which we’ll discuss as we go through this workshop. Some files are called documents. Files are stored in folders, or directories, which, like drawers in a filing cabinet, keep related files together. There are two basic parts of a computer: hardware and software. 1.     Hardware  refers to all the physical components of a computer, including the monitor, system unit, keyboard, mouse, microphone, speakers, and printer. 2.      Software  refers to the electronic files that enable users to accomplish tasks with the computer. A software program is sometimes referred to as an application. a) UNDERSTANDING HARDWARE A computer is composed of three types of hardware. The following table summarizes and gives examples of these types of hardware Type of Hardware Function Example...
Read more