Microsoft® Excel Basic Formulas Demo

Click Here For More Information

Events Search and Views Navigation

Event Views Navigation

Today

Recurring

Project Management Professional (PMP®) Exam Prep Virtual Course – M/W/F, 12:00 p.m. – 4:30 p.m.

Virtual Live

PMI’s Project Management Professional (PMP)® credential is the most important industry-recognized certification for project managers. Globally recognized and demanded, the PMP® demonstrates that you have the experience, education and competency to lead and direct projects.

This recognition is seen through increased marketability to employers and higher salary; according to the PMI Project Management Salary Survey–Eighth Edition, certification positively impacts project manager salaries.

Book Now $1,795.00

Duke Energy PMP Boot Camp – Lake Mary, FL

Duke Energy - Lake Mary, FL 3300 Exchange Plaza, Room 155, Lake Mary, FL, United States

The PMI’s Project Management Professional (PMP)® credential stands as a crucial industry-recognized certification for project managers worldwide. Holding the PMP® signifies your proven competence, experience, and education in leading and […]

Book Now $1,145.00

Microsoft® Power BI® Data Analytics Introduction

Virtual Live

Course Description: This course involves the creation of exploration, analysis, and reporting of data insights and trends using the Microsoft Power BI® software. Power BI was built to connect to […]

Book Now $399.00

Microsoft Excel® Power Query

Virtual Live

Description This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will […]

Book Now $225.00

Microsoft Excel® Power Query

Virtual Live

Description This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will […]

Book Now $225.00

Microsoft® Excel: Data Analysis With PowerPivot

Virtual Live

Microsoft® Excel 2016: Data Analysis With PowerPivot involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to […]

Book Now $225.00

Microsoft Excel® Power Query

Virtual Live

Description This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will […]

Book Now $225.00

The Basic Formulas class will acquaint the user with an overview of Excel formulas where cell addresses are featured for effective formula copying. Relative vs. absolute referencing is discussed and demonstrated as well as exposure to general formula functions such as SUM, AVERAGE, MAX, MIN, and COUNT. The user will also be shown various Date functions such as TODAY, NOW, MONTH, YEAR, and DAY.

Objective: Upon completion of this course the novice Excel user will be able to complete spreadsheets by using a variety of formulas featuring basic computation along with using built-in Excel Functions.

  • Copying formulas using the Fill Handle
  • Relative vs. Absolute References
  • Using AUTOSUM
  • Basic Functions
    1. AVERAGE
    2. MAX
    3. MIN
    4. COUNT
    5. Date Functions
      1. TODAY & NOW
      2. MONTH, YEAR, and DAY
      3. The DATE Function
  • Conditional Formatting

IMPORTANT INFORMATION ABOUT PARTICIPATION:  As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes).  These may come in the form of open-ended questions, hand-raising, polling, and other techniques.  You MUST answer or respond to all three opportunities to engage in order to receive credit for that CPE hour.   Knowledge Source Inc. retains these responses after all CPE classes for audit purposes.

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Course Information
  • Course Level:Basic
  • Prerequisite:None
  • Credit:1 CPE Hours
  • Delivery:Group Internet Based
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelBasic
  • Advanced PreparationNone
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to info@knowledgesourceinc.com or by calling 919-878-7100. Refunds will be issued within 30 days after the course.
Department
Microsoft® Office Hands-On Courses

Related Courses