MS EXCEL

 In this course you will learn how to get started with excel and how to process data in the excel. Excel program is important in our society today because it help to manage and manipulate data easily and save time which is lost due to many mistakes made during the processing of the data manually. So, it is important to know excel in detail, after you finish reading you will understand why need this course.

Other courses in this series which you can learn are the following:


Lesson 1: Learn How to Use Computer (New Versions of Windows)

Lesson 2: Learn How to Use Microsoft Word (New Versions of Word)

Lesson 3: Learn How to Use Microsoft Excel (New Versions of Excel)

Lesson 4: Learn How to Use Microsoft PowerPoint (New Versions of PPT)

Lesson 5: Learn How to Use Microsoft Publisher (New Versions of Publisher)

Lesson 6: Learn About Computer Repair and Maintenance

 

You can contact me if you have any suggestion about this course by the following contact

Email info: francisreagan88@gmail.com

 



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      

 

START TO LEARN (CLICK HERE)

 

 

Comments

Post a Comment

Popular posts from this blog

INTRODUCTION TO COMPUTER

Image
  A computer is an electronic machine that can input, process, store, and output a vast amount of information at an extremely high speed.  (a) Types Of Computer  There are three types of computer  1. Micro or Personal computer(PCs)  2. Mainframe  3. Supercomputers  (i) Personal Computers  The personal computer or PC, is designed to be used by one person at a time. There are different kinds of personal computers such as desktops, laptops, handheld computers, and Tablets PCs.  (ii) Desktop Computers  Desktop computer are designed for use at a desk or table. They are typically larger and more powerful than other types of personal computers. Desktop computers are made up of separate components. The main component, called the system unit, is usually a rectangular case that sits on or underneath a desk. Other components, such as the monitor, mouse, and keyboard, connect to the system unit. (iii) Laptop and Netbooks Laptops are lightweight mobi...
Read more

IF YOU NEED HELP WHEN USING WINDOWS

Image
  At some point, you're likely to run into a computer problem or confusing task. To figure it out, you'll need to know how to get the right help. This article provides an overview of the best techniques. (a) Using Windows Help and Support Windows Help and Support is the built-in help system for Windows. It's a place to get quick answers to common questions, suggestions for troubleshooting, and instructions for how to do things. If you need help with a program that's not part of Windows, you'll need to consult that program's Help (see "Getting help with a program" below). To open Windows Help and Support, click the Start button Picture of the Start button, and then click Help and Support. (b) Get the latest Help content If you're connected to the Internet, make sure Windows Help and Support is set to Online Help. Online Help includes new Help topics and the latest versions of existing topics. 1.    Click the Start button Picture of the S...
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