Excel Guide: Practical Basic to Advanced
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