• BUS 115 - Business Applications: Excel in Practice
  • Acknowledgements
  • Excel Overview
  • Time Saver
  • Auto Fill and Fill Series
  • Cell Referencing
  • Absolute and Relative Referencing
  • Navigation Shortcuts
  • Managing Cells
  • Sorting and Filtering
  • Hiding and Grouping
  • Paste Special
  • Named Ranges
  • Ranking
  • Rounding
  • Sum and Count
  • Managing Worksheets
  • Lookup Functions
  • Data Validation
  • IF Statements
  • Formula Errors
  • Text Functions
  • Text to Columns
  • Logic Functions 2
  • Date and Time
  • Conditional Formatting 1
  • Standards of Professionalism
  • Spreadsheet Formatting and Design
  • Basic Charts
  • Dashboards
  • Conditional Formatting 2
  • Spreadsheet Protection
  • Basic Pivot Tables
  • Advanced Pivot Tables and Slicers
  • Logic Functions 3
  • Advanced Lookup Functions
  • Loan Amortization Schedule
  • Advanced Charts
  • Macros 1
  • Macros 2
  • Macros 3
  • How to Use Search Engines
  • Sandbox
  • Author Biographies
  • Why the Standards of Professionalism?
  • Learning New Functions
  • Abstracts
  • Download
  • Search
  • Publication Information

    BUS 115 - Business Applications: Excel in Practice

    Kevin Poaletti

    Brigham Young University–Idaho

    Kevin has held various roles in merchandising at Walmart—supporting both categories and central initiatives. He is currently a senior director of pricing for the United States business with a focus on using data science and machine learning to make better pricing decisions. From the start of his time at Walmart, he has worked to leverage data and technology within the business to increase speed to action and to accelerate growth. In addition to retail, Kevin also enjoys teaching and helping people expand their options through education. At BYU–Idaho he has helped redesign business and finance courses focused on learning to use Excel to solve business problems.
    Ashley Smith

    Brigham Young University Idaho

    Ashley Smith is an online Curriculum Designer for Brigham Young University-Idaho where he designs and develops online university courses for a worldwide audience. He also teaches an online business course for the university. Prior to his current role in higher education, he worked for Walmart for 18 years. As a corporate trainer, he traveled coast to coast in the United States facilitating classes to leaders and managers. He led and managed multiple company-wide training projects and programs. Ashley developed many training courses which were implemented across all of Walmart U.S. He is passionate about worldwide higher education. He believes with innovation, and creativity, any individual with a desire to learn, can gain an education no matter where they live in the world.

    This content is provided to you freely by BYU-I Books.

    Access it online or download it at https://books.byui.edu/bus_115_business_app.