*Advanced Excel offers numerous features and function for a proficient approach and working of the program. *These features are basically an implementation of general methodologies which are vital for performing various tasks. Every function of Advanced Excel contributes in the productivity and performance by simplifying complex tasks. *Some of the Advanced excel features and their functionalities are as follows:*
*1. **Filters* *Excel supports two different ways to filter data that are in tabular format. Auto filter is a built-in capability driven via the user interface. As sophisticated as Auto filter has become in recent versions of Excel, no pre - defined setup can possibly cater to all the different questions that the consumer may want answered. * These require a custom filter and Advanced Filter provides that capability. There are basically two types of filters in Advanced Excel namely, Advanced Filter and Auto Filter. *Filters are used to obtain certain and specified data form a massive collection of spreadsheets and data structures.* *2. **Mathematical Functions* Mathematical Functions are generally used to perform computational and calculations over a set of data. *These functions are instrumental in saving time and efforts while computing and calculation data. There are numerous functions by which you can simply find the sum, average, count, subtotal and sumpr oduct of data.* These functions are extremely beneficial for accounting and financial tasks. *3. **Text Functions* *Text functions are generally implemented to perform various operations over text and characters. These functions are really very helpful in finding and manipulating text items of the spreadsheets.* With the help of these functions one can easily search, replace, and substitute any text from the data set. *4. **Date and Time Functions* These functions are vital for assigning date and time to every data set as per its entry and position in the Data set. *These functions are helpful in order to sort and search data based on the Date and Time values*. These functions involve every minute detail which is associated with date and time such as date, time, day, month, and year. The Date and time functions are even capable of managing hours, minutes and seconds associated with the data sets. *5. **Logical Functions* *Logical Functions are basically used for computing and calculating the data values in order to simplify the complexity of the data associated*. These functions are AND. OR, If error, NOT and nested IF. These functions are called logical functions as they are derived by using logic; gates. *6. **Lookup and Reference Functions* These functions are generally used to synchronize various data elements together. *Here various functions such as matching two data elements together, indexing data elements, and finding address of a particular data element are utilized.* Some other functions are also utilized to make tasks and functionalities more proficient and productive*. An Advanced Excel Program lets you understand about methods of data collection and security. It enables you to share your work on share drive without compromising with the originality of the work.* The course also helps you in s Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables. *Share and comment to help this post serve you better...* *thanks & regards,* *Arbind Gaba* *sla consultants india,* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
