Skip Navigation
 

Gather Here. Go Far

With locations in Tahlequah, Muskogee and Broken Arrow, NSU is Oklahoma’s immersive learning institution. Choose from in-person, blended or online learning options.

Explore Our Degrees

Scholarships

NSU is committed to assisting students in applying and earning scholarships. Whether you are an incoming freshman or a continuing/returning student, NSU has a wide variety of scholarship options for students to choose from.

Learn More

Clubs and Organizations

From networking to leadership opportunities, NSU’s over 80 clubs and organizations allow our students to build lasting relationships while getting the full college experience.

Learn More

Transfer Students

Whether you’re an incoming or current transfer student, NSU’s transfer advisors are available to assist you with transcript evaluation, information on degree programs and support services. NSU is where You Belong.

More Information

Graduate College

Whether transitioning to graduate school or returning to higher education, NSU’s graduate college is your next step. Choose from over 25 master's degrees and several certificate programs.

Learn More
Academics/Continuing education/Courses/Excel

Excel Tips and Tricks

Register

  • Dates: Open enrollment
  • Duration: 90 days
  • Time: 3 hours
  • Location: Online
  • Course Fee: $95.00 USD
  • CEUs: .3
  • Code: 01 - EDU - TR - ON
Course Description
This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace.

Learning Outcomes

  • Employ copy and paste shortcuts
  • Arrange, filter, and sort data by text, color, and by custom criterions
  • Modify the worksheet view with various display tools, such as Freeze Panes, Hide/Unhide, Text-To Column, and Zoom In/Out
  • Understand and apply data organization tools and functions
  • Retrieve data using VLOOKUP, HLOOKUP, and Find + Replace
  • Apply patterns, gradients, cell borders, and other style elements to data
  • Experiment with the Quick Analysis Tools to create charts, graphs, and calculations
  • Make use of the lock/unlock and track changes features

Key Features

  • Expert-supported
  • Mobile-friendly Accessible Badge and
  • credit-awarding Games & Flashcards
  • Audio-enabled in app

Refund Policy
You may request a refund up to 5 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed. Completion percentage can be viewed on the Course Progress page from within the course.

Notes
This course has an "Ask the Expert" feature, which submits your questions directly to an expert in the field you are studying. Questions are answered as quickly as possible and usually within 24 hours.

This course does not require any additional purchases of supplementary materials.