Vikom Institute
Screenshot_1

Excel Basic to advance

2.24$

This booklet is the summary of the Basic of Advance topics of the Excel. We have used simple English
language to make Excel simpler & easier for you. This book is open to all readers interested in learning
excel, however, the book will produce more advantage for readers who have attended the seminars
related to it.
Important Information
 You CANNOT take the print of booklet
 You CANNOT copy the contents of the booklet
 This book considers “TREES ARE THE GREEN GOLD”. So keep E-Reading.

Category:

Product Description

CONTENTS
WHAT IS EXCEL ……………………………………………………………………………………………………………………………. 5
WHY EXCEL …………………………………………………………………………………………………………………………………. 5
BASICS OF EXCEL …………………………………………………………………………………………………………………………. 6
OPENING OF EXCEL ………………………………………………………………………………………………………………….. 6
WHAT IS EXCEL WORKBOOK, WORKSHEET AND CELL? …………………………………………………………………. 6
CLOSING OF WORKBOOK AND WORKSHEET ……………………………………………………………………………….. 6
SAVE AND SAVE AS YOUR EXCEL WORKBOOK ……………………………………………………………………………… 7
FORGET MOUSE ………………………………………………………………………………………………………………………….. 7
BASIC MATH’S …………………………………………………………………………………………………………………………….. 8
ADDITION ……………………………………………………………………………………………………………………………….. 8
SUBTRACT, MULTIPLICATION AND DIVISION ……………………………………………………………………………… 10
ABSOLUTE AND RELATIVE REFERENCE ……………………………………………………………………………………… 10
PASTE SPECIAL……………………………………………………………………………………………………………………….. 11
BASIC FUNCTIONS. …………………………………………………………………………………………………………………….. 13
AVERAGE ………………………………………………………………………………………………………………………………. 13
COUNT ………………………………………………………………………………………………………………………………….. 14
COUNTA ……………………………………………………………………………………………………………………………….. 15
NOW AND TODAY ………………………………………………………………………………………………………………….. 16
RANDBETWEEN. …………………………………………………………………………………………………………………….. 17
LEFT ……………………………………………………………………………………………………………………………………… 17
RIGHT …………………………………………………………………………………………………………………………………… 18
MID ………………………………………………………………………………………………………………………………………. 18
LEN ………………………………………………………………………………………………………………………………………. 18
VLOOKUP………………………………………………………………………………………………………………………………. 19
DATE ANALYSIS …………………………………………………………………………………………………………………………. 23
IF ……………………………………………………………………………………………………………………………………………… 23
SORTING AND FILTERING ……………………………………………………………………………………………………………. 25
SORTING ……………………………………………………………………………………………………………………………….. 25
FILTER …………………………………………………………………………………………………………………………………… 29
NAME THE RANGES ……………………………………………………………………………………………………………………. 32
PIVOT TABLE ……………………………………………………………………………………………………………………………… 34
CONDITIONAL FORMATTING ………………………………………………………………………………………………………. 38

MACROs …………………………………………………………………………………………………………………………………… 40
IMPORTANT LINKS …………………………………………………………………………………………………………………….. 45
CONTACT DETAILS ……………………………………………………………………………………………………………………… 45

Reviews

There are no reviews yet.

Be the first to review “Excel Basic to advance”

top
Vikom-institute @  Developed By Velik Technologies