PREFACE

This book is a concrete success manual to computer literacy. It is a practical guidebook for whosoever that wants to have a practical knowledge of Excel from Basic to Advanced level. It is a comprehensive study guide for beginners and gurus as is compiled with step to step and some short-cut keys that can enable you work as a professional.

This manual is primarily aimed at helping those who encounter any practical challenge in Electronic spread sheet (Excel), the screenshots here will help you to quickly understand it.

Success is yours, Happy reading…

TABLE OF CONTENTS

INTRODUCTION

AREAS OF APPLICATION

EXCEL’S ENVIRONMENT

FORMATTING TOOLS OR FORMATTING BAR

HOW TO FIT A LONG LABEL

HOW TO LOAD MICRO SOFT EXCEL

UNDERSTANDING EXCEL (ESS) DEEP

HOW TO SAVE

HOW TO SAVE WITH SECURITY

HOW TO OPEN

HOW TO COPY AND PASTE

HOW TO DELETE

HOW TO MERGE CELLS

HOW TO WRAP A TEXT

HOW TO SHRINK TEXT

HOW TO ADJUST FONT SIZE, STYLE AND COLOUR

HOW TO APPLY SUPER SCRIPT OR SUBSCRIPT

HOW TO APPLY FILL COLOUR

HOW TO SHOW GRID LINES IN THE SHEET

HOW TO HIDE OR REMOVE IT

ALIGNMENT

TEXT ORIENTATION

HOW TO ADD CURRENCY ($)SYMBOL TO NUMBERS

ADDING PERCENTAGE

TO APPLY COMMA

HOW TO INSERT A CELL, ROW, COLUMN OR SHEET

HOW TO DELETE CELL, COLUMN, ROW AND SHEET

FIND (CTRL + F)

FIND AND REPLACE (CTRL + H)

HOW TO SELECT OBJECTS (WITH OBJECT SELECTING TOOL)

HOW TO PROTECT/LOCK YOUR SHEET

HOW TO USE DICTIONARY

TEXT BOX

HOW TO APPLY TEXT BOX

HOW TO INSERT WORDART

INSERT FUNCTION

HOW TO PERFORM MATHEMATICAL OPERATIONS LIKE ADDITION, SUBTRACTION & MULTIPLICATIONS

HOW TO ADD

SAMPLE 1

SAMPLE 2

EXERCISE

COMMON SYMBOLS USED IN EXCEL FOR CALCULATION

HOW TO SUBTRACT

HOW TO MULTIPLY

SCIENTIFIC ANALYSIS

STEPS TO SOLVE TAN

STEPS TO SOLVE COS

STEPS TO SOLVE SIN

STEPS TO SOLVE LOG

STEPS TO SOLVE PRODUCT OR MULTIPLICATION

STEPS TO SOLVE POWER

STEPS TO SOLVE POWER (COLUMN G)

STEPS TO SOLVE SQUARE-ROOT

STEPS TO ROUNDUP OR APPROXIMATE

EXERCISE

EXERCISE ONE

EXERCISE TWO

STATISTICAL ANALYSIS

EXERCISE THREE

EXPLANATIONS

SPREAD SHEET USED IN INEC TO ANALYZE DATA

SALES REPORT ANALYSIS

ACCOUNTING REPORTS

ACCOUNT REPORT FOR EXAMS EXPENDITURE

HOW TO USE/INSERT PIE CHART

COLUMN

HOW TO APPLY COLUMN

LINE (GRAPH)

CONVERTING CURRENCIES

HOW TO CONVERT US DOLLAR TO NAIRA

CONVERTING FROM NAIRA TO DOLLAR & OTHER CURRENCIES

E-FORMULA

COMMONLY USED SYMBOLS

HOW TO COMPUTE EXAMS RESULT

EXERCISE 1

HOW TO PREPARE PAYMENT VOUCHER

EXERCISE 2

MEAN/AVERAGE

STANDARD DEVIATION

CONCATENATION

CELL REFERENCING

RELATIVE CELL REFERENCING AND ABSOLUTE CELL REFERENCING

AUTOMATING SPREADSHEETS OR SALES IN EXCEL

HOW TO PRINT

Key Usen