ExcelFlash

Tips & Tricks

Pages

  • Home
  • Blogs
  • Functions
  • Query
  • Forum
  • About Us
  • YouTube

Functions


  • Text Functions
    1. Concatenate
    2. Find/Search
    3. Left/Right/Mid
    4. Proper/Lower/Upper
    5. Trim
    6. Len
    7. Replace/Substitute
  • Mathematical Functions
    1. Count
    2. Sum
    3. Average
    4. Max
    5. Min
    6. Large
    7. Small
  • The Sum, SumIf & SumIfs Function 
  • The Count, CountIf & CountIfs Function
    Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

    No comments:

    Post a Comment

    Home
    Subscribe to: Posts (Atom)

    Blog Archive

    • ▼  2018 (2)
      • ▼  December (2)
        • Create Pareto Chart in Excel!!!
        • How To Create Dynamic Charts/Graphs!!!
    • ►  2017 (17)
      • ►  March (6)
      • ►  February (11)

    Labels

    • Blogs (9)
    • Charts (2)
    • Functions (4)
    • Query (4)

    Popular Posts

    • Text Functions
    • Query3. Remove Special Characters from Name/String
    • Query4. Ramji - Concatenate Unique assignments as per the Name
    • 3 Easy ways to get First Name from Name!
    • How to remove Page Break lines

    Blog Archive

    • December (2)
    • March (6)
    • February (11)

    Followers

    Search This Blog

    About Me

    My photo
    Sachin Gupta
    Hi, This is Sachin Gupta from Meerut (India), working as a Freelancer having more than 6 years of experience as Analyst & VBA Developer.
    View my complete profile

    Contact Us

    Name

    Email *

    Message *

    Sachin Gupta. Watermark theme. Powered by Blogger.