• Speedo Champions Series
    March 29 12:00am
    Swim Meet more »
  • Phyllis Bramson | Love and Affection in a Hostile World
    March 29 10:00am
    A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
  • Philip Powell presents Business and the Poor:The Ethics and the Economics
    March 29 7:00pm
    The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
  • Philip Powell presents Business and the Poor:The Ethics and the Economics
    March 29 7:00pm
    The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
  • The Rufus and Louise Reiberg Reading Series presents Angela Palm
    March 29 7:30pm
    A native of Indiana, Angela Palm is the author of Riverine: A Memoir from Anywhere but Here, published by Graywolf Press in 2016. She owns Ink + Lead Literary Services and is the editor of an anthology of Vermont writers, Please Do Not Remove. Her work has appeared in Paper Darts, Midwestern Gothic, Tampa Review, and elsewhere. She lives in Burl more »
Wednesday, March 29, 2017
    IU Calendar




    • Speedo Champions Series
      March 29 12:00am
      Swim Meet more »
    • Phyllis Bramson | Love and Affection in a Hostile World
      March 29 10:00am
      A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
    • Philip Powell presents Business and the Poor:The Ethics and the Economics
      March 29 7:00pm
      The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
    • Philip Powell presents Business and the Poor:The Ethics and the Economics
      March 29 7:00pm
      The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
    • The Rufus and Louise Reiberg Reading Series presents Angela Palm
      March 29 7:30pm
      A native of Indiana, Angela Palm is the author of Riverine: A Memoir from Anywhere but Here, published by Graywolf Press in 2016. She owns Ink + Lead Literary Services and is the editor of an anthology of Vermont writers, Please Do Not Remove. Her work has appeared in Paper Darts, Midwestern Gothic, Tampa Review, and elsewhere. She lives in Burl more »
    Wednesday, March 29, 2017
      IU Calendar




      • Speedo Champions Series
        March 29 12:00am
        Swim Meet more »
      • Phyllis Bramson | Love and Affection in a Hostile World
        March 29 10:00am
        A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
      • Philip Powell presents Business and the Poor:The Ethics and the Economics
        March 29 7:00pm
        The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
      • Philip Powell presents Business and the Poor:The Ethics and the Economics
        March 29 7:00pm
        The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
      • The Rufus and Louise Reiberg Reading Series presents Angela Palm
        March 29 7:30pm
        A native of Indiana, Angela Palm is the author of Riverine: A Memoir from Anywhere but Here, published by Graywolf Press in 2016. She owns Ink + Lead Literary Services and is the editor of an anthology of Vermont writers, Please Do Not Remove. Her work has appeared in Paper Darts, Midwestern Gothic, Tampa Review, and elsewhere. She lives in Burl more »
      Wednesday, March 29, 2017
        IU Calendar




        • Speedo Champions Series
          March 29 12:00am
          Swim Meet more »
        • Phyllis Bramson | Love and Affection in a Hostile World
          March 29 10:00am
          A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
        • Philip Powell presents Business and the Poor:The Ethics and the Economics
          March 29 7:00pm
          The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
        • Philip Powell presents Business and the Poor:The Ethics and the Economics
          March 29 7:00pm
          The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
        • The Rufus and Louise Reiberg Reading Series presents Angela Palm
          March 29 7:30pm
          A native of Indiana, Angela Palm is the author of Riverine: A Memoir from Anywhere but Here, published by Graywolf Press in 2016. She owns Ink + Lead Literary Services and is the editor of an anthology of Vermont writers, Please Do Not Remove. Her work has appeared in Paper Darts, Midwestern Gothic, Tampa Review, and elsewhere. She lives in Burl more »
        Wednesday, March 29, 2017

          About This Event

          Summary

          This workshop will explore arrays and conditional functions used to summarize or count data with certain criteria. Discover how to use IF and Nested IF functions to test for specific conditions and how to apply different types of conditional formats. Participants will also explore various techniques to look up values in a range of data using VLOOKUP. Challenge exercises will be provided for reinforcement.

           What you'll learn:

          •perform calculations using array formulas

          •create IF and nested IF functions

          •use conditional functions to summarize or count data

          •use the CONCATENATE function to join text

          •look up data using VLOOKUP

          •apply different types of conditional formatting

           

          What you need to know :

          •create and manage named ranges

          •create formulas and functions

          •create and apply validation criteria

          •work with tables

          •sort and filter data

           If you don't have those skills, consider first taking the workshop:

          Excel 2013: Data Management

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • Speedo Champions Series
            March 29 12:00am
            Swim Meet more »
          • Phyllis Bramson | Love and Affection in a Hostile World
            March 29 10:00am
            A survey of Chicago-based artist Phyllis Bramson's provocative painting and mixed-media work, which examine Eastern iconography as constructed in the Western imagination. more »
          • Philip Powell presents Business and the Poor:The Ethics and the Economics
            March 29 7:00pm
            The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
          • Philip Powell presents Business and the Poor:The Ethics and the Economics
            March 29 7:00pm
            The world's economic resources are overwhelming consolidated in business, or markets.  While governments and NGOs have a role to play in economic development and poverty alleviation, the power of business to radically transform the lives of the world's income-poor communities is exponentially greater.  The six-part seminar will more »
          • The Rufus and Louise Reiberg Reading Series presents Angela Palm
            March 29 7:30pm
            A native of Indiana, Angela Palm is the author of Riverine: A Memoir from Anywhere but Here, published by Graywolf Press in 2016. She owns Ink + Lead Literary Services and is the editor of an anthology of Vermont writers, Please Do Not Remove. Her work has appeared in Paper Darts, Midwestern Gothic, Tampa Review, and elsewhere. She lives in Burl more »
          Wednesday, March 29, 2017