Microsoft® Excel Basic Formulas Demo

Click Here For More Information

Loading view.

Courses Search and Views Navigation

Search

Enter Keyword. Search for Courses by Keyword.

Find Courses

Courses Views Navigation

List

• List
• Month
• Day

Today

Now Now - 2023-10-24 October 24 Select date.

September 2023

Sun 24

September 11 @ 12:30 pm - September 29 @ 4:30 pm

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

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.

$1,895.00

Tue 26

September 26 @ 9:30 am - 11:30 pm

Microsoft® Excel Charts

Virtual Live

Virtual Courses

Microsoft® Excel Charts will demonstrate to the Excel user how to create effective charts off of spreadsheet data. A discussion of chart basics will be featured along with the creation […]

Book Now $99.00

Tue 26

September 26 @ 1:00 pm - 5:00 pm

Microsoft® Power BI: Part 1

Virtual Live

Virtual Courses

Objective: Upon successful completion of this course the user will be able to navigate the Power BI interface, explore data diagrams, model and query data. Description: This course is designed for individuals […]

Book Now $199.00

October 2023

Tue 3

October 3 @ 9:30 am - 11:30 am

Microsoft® Excel VBA Level I: Macros

Virtual Live

Microsoft® Excel VBA: Macros will demonstrate to the user how to effectively coordinate macros along with exposing them to the basic foundations of Visual Basic programming. The macro recorder will […]

Book Now $99.00

Tue 3

October 3 @ 1:30 pm - 3:00 pm

Microsoft® Excel VBA Level 2: Variables and Constants

Virtual Live

Microsoft® Excel VBA: Variables and Constants will delve deeper into the core components of the Visual Basic language. The internal framework of code structure will be discussed, including objects, properties, […]

Book Now $99.00

Tue 10

October 10 @ 9:30 am - 11:30 am

Administrative Microsoft® Excel

Virtual Live

Administrative Microsoft® Excel will demonstrate to the power user how to edit spreadsheets for both individual and group use. Featured topics included validating data, applying various levels of protection, sharing […]

Book Now $99.00

Tue 10

October 10 @ 2:00 pm - 4:00 pm

Microsoft® Excel Advanced Formulas: Logical Functions

Virtual Live

Microsoft® Excel Advanced Formulas: Logical Functions course will demonstrate how to use conditional formulas namely in the Logical category. In addition, aggregate functions with testing conditions will be featured. This […]

Book Now $99.00

Tue 10

October 10 @ 5:30 pm - 7:30 pm

Microsoft® Excel Tips & Tricks

Virtual Live

Microsoft® Excel Tips & Tricks will demonstrate to the user how to use effective techniques for viewing large worksheet data, hiding data, using paste special and Go To, and using […]

Book Now $99.00

Tue 17

October 17 @ 8:00 am - 12:00 pm

Microsoft® Power BI: Part 2

Virtual Live

Microsoft® Power BI: Part 2 is designed to provide proficiency in modifying charts and graphs along with creating advanced formulas and functions. The Power BI program will involve the connection […]

Book Now $199.00

Wed 18

October 18 @ 9:30 am - 11:30 am

Microsoft® Excel Data Lists and Tables

Virtual Live

Microsoft® Excel Data Lists and Tables will expose the user to the use of data lists and tables where both simple and complex sorting is involved. They will also work […]

Book Now $99.00

Wed 18

October 18 @ 1:30 pm - 3:30 pm

Microsoft® Excel PivotTables

Virtual Live

Microsoft® Excel PivotTables will demonstrate to the Excel user how to create and use list and table data to create analytical Pivot Tables. This will include an exploration of both […]

Book Now $99.00

Tue 24

October 24 @ 9:00 am - 11:00 am

Microsoft® Excel Advanced Formulas: Lookup Functions

Virtual Live

Microsoft® Excel Advanced Formulas: Lookup Functions will demonstrate to the user how to use formulas that extend across multiple worksheets as well as exploring the deeper function category Lookup and […]

Book Now $99.00

Subscribe to calendar

• Google Calendar
• iCalendar
• Outlook 365
• Outlook Live
• Export .ics file
• Export Outlook .ics file

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.

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

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.