OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Using Function In Excel

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

Using Function In Excel

PREVIOUS NEXT

Excel comes with different functions which you can use for different purposes. Excel built in functions are grouped into different categories for easy understanding and usage when the need arises.

Excel functions are categorized into the following:

  • AutoSum - This category contains functions for calculating sum, average, showing minimum and maximum values of range of numbers and counting numbers.
  • Financial - This function category contains functions used for executing various financial calculations such as interest rates, depreciation, yield calculations, pricing, payment functions and lots more.
  • Logical - The logical function category contains functions used to test for true or false from selected data. It also contains functions used for comparing multiple data to give results that can be used for further calculations.
  • Text - The Text functions category contains functions that are used to change the way text is displayed in a cell such as changing to uppercase or lowercase, formatting text and numbers etc.
  • Date and Time - This category contains different functions for formatting date and time.
  • Lookup and References - This category contains different functions that is used to perform operations in array of data such as providing information on data sets, getting data address and other similar operations.
  • Math and Trig - This category contains functions that are used for mathematical calculations and trigonometrical operations.
  • Statistical - This category contains other functions which are used in mathematics for statistical operations, computations and calculations.
  • Engineering - This category contains functions which are used for both simple and complex engineering calculations.
  • Cube - Cube function category in excel contains functions which are used to retrieve data from any SQL sources.
  • Information - The information function category contains functions that are able to return information about the contents, location or formatting of a cell.
  • Compatibility - This category of functions contains other functions which are used to support functions or replace pre-existing functions for better performance and operation.
  • Web - Web function category includes functions which can be used to return information from the internet or intranet in a specific form.
COMMONLY USED FUNCTIONS
AND

This function returns TRUE if all the arguments being compared are TRUE, but returns FALSE if one or more arguments being compared are false.
OR

This function returns TRUE if any of the arguments being compared are TRUE, but returns FALSE if all the arguments being compared are false.
NOT

This function returns the opposite of the logical value. That is if a value is false, it returns TRUE, and if a value is TRUE, it returns FALSE.
XOR

This function returns TRUE if one of the argument being compared is true, and it will return FALSE if both arguments being compared are true.
IF

This function is used to make logical comparison for values. This function returns one value for TRUE and another value for FALSE.
MAX

Max function is used to get the largest number from a group or list of numbers
MIN

Min function is used to get the smallest number from a group or list of numbers
AVERAGE

The function is used to calculate the average value from a group or list of numbers. Remember the average is the sum of all numbers divided by the count of the numbers.
COUNT

Count function is used to count the return the total count of the selected values.
SUM

The sum function is used to return the total addition of the selected numbers.
ABS

ABS is a function in Excel that is used to return the absolute value of the selected number. Absolute value is the distance from zero that a number is on the number line, without taking into consideration the direction of the number. E.g. Absolute value of -5 = 5
SIGN

This function returns the sign that is associated with the selected number in the format (+1, -1 or 0).
PRODUCT

The product function is used to calculate the multiplication of the selected numbers.
LCM

The LCM function is used to calculate the least common multiple of the selected numbers.
MOD

This function in excel is used to return the reminder of any division between two selected numbers. E.g. MOD(7,3) will return 1, because 7/3 will give you 2 reminder 1.
MEDIAN

Median function returns the middle value of the selected group of numbers in a list.
MODE

It is used to return the number that appears most in a range or list of data being selected.
SQRT

This function in excel is used to return the positive square root of the selected number.
LOWER

This function converts the selected data (alphabets) to lowercase (small letters).
UPPER

This function converts the selected data (alphabets) to uppercase (Capital Letters).
LEN

Len function is used to return the length of the selected string or data.
CONCAT

This function is used to join two or more selected data together.
TRIM

The trim function is used to remove extra spaces at the beginning and ending and duplicates of the selected data.
DATE

Date function is used to return the date from the selected day, month and year. Make sure the three data are complete when using this function.
TIME

Time function is used to return the time from the selected second, minute and hour. Make sure the three data are complete when using this function.
NOW

This function returns the current date and time.
TODAY

This function is used to display today's date.
PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT