• Log In
  • Register
  • Profile
Have any Queries? Mail us at training@futureinhands.com | Call us at +918744007662
iLearn
  • Home
  • iLearn
    • Knowledge Bank
    • Random Articles
    • Library
    • Career Planner
    • Practice Assessments
  • Training
    • Courses
    • Our Mentors
    • Our Learners
    • Upcoming Workshops
    • Training Solutions
      • Professional Training
      • Corporate Training
    • Success Stories
    • Placements
  • Downloads
    • Softwares
  • Search
knowledge-bank-banner

An investment in knowledge always pays the best interest

data-cleaning

Reversing Row order in Excel

October 26, 2015/0 Comments/in Excel /by Vivekananda Sinha

In many cases we face challenges in reversing row order in Excel.  There are two simple approaches for doing this. One is to add an extra column with serial numbers and then sort on that column in descending order. This works perfect for small amount of data. For big data it is best to use Microsoft Power […]

history

Microsoft Excel Version History

October 16, 2015/0 Comments/in Excel /by Vivekananda Sinha

Microsoft Excel is the largest used Reporting and Data Analysis application now a days. Its important to know the Microsoft Excel version history since the version 1. The table below lists the various versions of Excel for Windows.

business-intelligence

Business Intelligence

October 5, 2015/0 Comments/in Industry's Hot /by Vivekananda Sinha

Wikipedia defines Business Intelligence (BI), the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. There are other definitions of Business Intelligence that are used in the Corporates, few of them are: Business Intelligence refers to skills, processes, technologies, applications and practices used to […]

find-something

VLOOKUP using Approximate Match

July 29, 2015/0 Comments/in Excel /by Vivekananda Sinha

In a lot of cases, we use VLOOKUP to find exact matches, based on some kind of unique id. But there are many situations where we can perform VLOOKUP using Approximate Match. A classic case is using VLOOKUP to find a Grade for the students where marks are provided. Suppose we are provided with Test scores […]

error

Excel Error and Related Information

July 7, 2015/0 Comments/in Excel /by Vivekananda Sinha

While working with Microsoft Excel, we come with various type of error. This Article will guide you through the different error in excel with example and fix for each of these error. #DIV/0! This error comes when something is divided with 0. Example: A Cell with the Formula =15/0 would return in this error. Fix: Do […]

table-design

Working with Excel Table

July 6, 2015/0 Comments/in Excel /by Vivekananda Sinha

An important but often underutilized feature in Excel is tables. This tip describes when to use a table and also lists the advantages and disadvantages. Understanding what a Table is: A table is a rectangular range of structured data. Each row in the table corresponds to a single entity. For example, a row can contain information about […]

files-folders-colorful

Generating a List of File Names

July 6, 2015/0 Comments/in Excel /by Vivekananda Sinha

This tip describes how to retrieve a list of file names in a folder and display them in a worksheet.This technique uses an Excel 4 XLM macro function in a named formula. It’s useful because it’s a relatively simple way of getting a list of file names into a worksheet – something that normally requires a complex […]

email

Send Outlook Mail from Excel VBA

July 1, 2015/0 Comments/in Excel, Outlook, VBA /by Vivekananda Sinha

This article features code that you can use to send outlook mail from Excel by using the Microsoft Outlook object model. The below code can be used to send an Outlook mail directly from Excel. Sub SendOutlookEmail() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject(“Outlook.Application”) Set OutlookMail = OutlookApp.CreateItem(0) On Error Resume Next […]

writing

Resume Writing Tips

June 27, 2015/0 Comments/in Career /by Vivekananda Sinha

Know the purpose of your Resume Some people write a resume as if the purpose of the document was to land a job. As a result they end up with a really long and boring piece that makes them look like desperate job hunters. The objective of your resume is to land an interview, and […]

positive-thinking

What 4 Common Interview Questions Really Mean

June 27, 2015/0 Comments/in Career /by Vivekananda Sinha

Acing the interview isn’t just about having the perfect canned speeches. Yes, you need to show off your experience, talents, and personality—but before answering each question, you also have to figure out what the interviewer is actually asking you. Those seemingly innocuous questions, like “tell me about yourself” and “where do you see yourself in a […]

Page 1 of 3123

Categories

  • Career (7)
  • Excel (19)
  • Industry's Hot (1)
  • Life Skills (1)
  • Outlook (1)
  • SAS (2)
  • VBA (3)
  • Windows (2)
Popular
  • typingExcel Macro Programming Interview Questions – Pra...June 26, 2015 - 2:22 PM
  • interviewExcel Macro Programming Interview Questions – The...June 23, 2015 - 6:08 PM
  • data-cleaningReversing Row order in ExcelOctober 26, 2015 - 5:37 PM
  • listInsert bulleted list in ExcelAugust 22, 2014 - 3:09 PM
  • calenderInsert Random Dates in ExcelAugust 22, 2014 - 3:27 PM
Recent
  • data-cleaningReversing Row order in ExcelOctober 26, 2015 - 5:37 PM
  • historyMicrosoft Excel Version HistoryOctober 16, 2015 - 12:38 PM
  • business-intelligenceBusiness IntelligenceOctober 5, 2015 - 12:29 PM
  • find-somethingVLOOKUP using Approximate MatchJuly 29, 2015 - 5:40 AM
  • errorExcel Error and Related InformationJuly 7, 2015 - 8:36 PM
Comments
  • Ashok KumarWow! Good to know.July 14, 2015 - 2:44 AM by Ashok Kumar
  • Ashok KumarWow! Great collection of VBA interview questions. Thanks...July 3, 2015 - 3:28 AM by Ashok Kumar
Tags
Analytics Data Cleaning Date & Time Error Format Formulas & Function Hidden Tricks Interview Lookup Mail Must Know Power Query Productivity Resume Shortcuts Table Text Tips & Tricks Training

Tags

Analytics Data Cleaning Date & Time Error Format Formulas & Function Hidden Tricks Interview Lookup Mail Must Know Power Query Productivity Resume Shortcuts Table Text Tips & Tricks Training

Tags

Analytics Data Cleaning Date & Time Error Format Formulas & Function Hidden Tricks Interview Lookup Mail Must Know Power Query Productivity Resume Shortcuts Table Text Tips & Tricks Training

Recent Articles

  • data-cleaningReversing Row order in ExcelOctober 26, 2015 - 5:37 PM
  • historyMicrosoft Excel Version HistoryOctober 16, 2015 - 12:38 PM
  • business-intelligenceBusiness IntelligenceOctober 5, 2015 - 12:29 PM
  • find-somethingVLOOKUP using Approximate MatchJuly 29, 2015 - 5:40 AM
  • errorExcel Error and Related InformationJuly 7, 2015 - 8:36 PM

Latest Courses

  • ssrsSQL Server Reporting Services – SSRSJuly 3, 2015 - 11:11 AM
  • mastering-microsoft-powerpointMastering Microsoft PowerPointJune 6, 2015 - 7:11 PM
  • emailMastering Microsoft OutlookMay 31, 2015 - 8:30 AM
  • itil-v3-foundationITIL V3 FoundationMay 6, 2015 - 10:48 AM
  • expertizing-sql-serverExpertizing SQL ServerMay 6, 2015 - 10:46 AM

Contact us

FIH Business Services Private Limited
Avaj Tower, Sector : 12, Vasundhara
Ghaziabad, Uttar Pradesh, INDIA
T : +91 8744007662
E : training@futureinhands.com

Proudly Powered by Future in Hands. An ISO 9001:2008 Certified Company.
  • Facebook
Scroll to top