Arslan ud Din Shafiq | Learn Cybers

Excel Tutorial

INDEX Function in Excel: Step by Step Guide

ByArslan ud Din ShafiqDecember 10, 2019

In our previous post, we have already cover Excel Match function. The Match function in excel returns the position of an item in array whereas the Index function in Excel returns the value present in that position in the array. Hence if you want to extract any value from an

Excel Tutorial

Find Duplicates in Excel (Filter / Count If / Conditional Formatting)

ByArslan ud Din ShafiqDecember 10, 2019

Here we have provided the step by step process on how to find duplicates in excel. When you are working on a large number of data then you will encounter few duplicate entries. Sometimes these duplicate values are very useful but many times you want to remove the duplicate

Excel Tutorial

Excel Subtraction Formula: How to use Subtract Function

ByArslan ud Din ShafiqDecember 10, 2019

There are various excel formulas basic including excel subtraction formula and advanced available in Microsoft Excel that you can use for different purposes. You might have used sum and average functions in excel as its icon is available at Excel ribbon. But you will not

Excel Tutorial

Bullets in Excel: How to Insert Bullet Points in Excel

ByArslan ud Din ShafiqDecember 10, 2019

Here you can see how to insert bullets in Excel. If you are a daily user of Microsoft tools, then surely, you must have seen bullets in MS Word. Like bullet points in Word, Excel does not offer a direct and bullet point shortcut method to add a bullet. But to add the bullet

Excel Tutorial

Excel Slicer: Easy Tricks to FILTER DATA [In Pivot Table]

ByArslan ud Din ShafiqDecember 10, 2019

To know everything about excel slicer, continue reading this page. In Excel, you will find numerous functions and formulas available like excel macros, vlookup, hlookup, and many others. Slicers are basically used to filter pivot tables easily and quickly. The Slicer is the

Excel Tutorial

Excel Hyperlink Functions and Formulae [With Examples]

ByArslan ud Din ShafiqDecember 10, 2019

There are various ways to use Excel Hyperlink. Similarly like MS Word or a website, you can also create a hyperlink in Excel. The hyperlink is used whenever you want to switch the sheet or you want to show things that are not available at the same place. Here you can check

Excel Tutorial

How to do Filtering in Excel to find data [Sorting Data]

ByArslan ud Din ShafiqDecember 10, 2019

Here you can check how you can perform filtering in excel to sort the data and to find the data. You can filter your excel data whichever meet the certain criteria and displays the records that you want to show. Along with filtering of data, you can also check the sorting of

Excel Tutorial

How to merge cells in excel [Shrink to Fit / Wrap Text]

ByArslan ud Din ShafiqDecember 10, 2019

Here we have commuted steps that will tell you how to merge cells in excel. In Excel, you can merge more than two cells together. Merging two cells together doesn’t mean combining the cell content together but you are combining cells together that has the same space. Check

Excel Tutorial

How to open excel file online free

ByArslan ud Din ShafiqDecember 10, 2019

When you open excel file online, you will find a new workbook automatically displayed. The workbook contains various worksheets that hold actual data and information. Initially, workbook opens up with three worksheets, but you can add and delete worksheets whenever you want.

Cookie	Duration	Description
cookielawinfo-checbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.