ONCE1164 - Intermediate Excel

Course Description

Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!

This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.

This 4-Week, self-paced Online course (no Live meetings) is offered through partnership with LERN/UGotClass. This course has a start and end date.  Registration stays open for the first full week of class. 
Note: This course can be taken as part of the "Certificate in Mastering Excel"

Course Outline

Unit 1

Organizing Worksheet and Table Data

• Introduction to tables
• Formatting tables using table styles
• Using formulas in tables
• Sorting and Filtering table data

Unit 2

Understanding Popular Excel Functions

• Understanding Named Ranges
• Applying business functions
• Creating functions that handle text
• Performing basic lookup functions
• Creating functions that work with dates and times

Unit 3

Improving Worksheet Appearance

• Formatting cells in worksheets
• Correcting common function errors
• Creating and using templates
• Customizing Excel toolbar

Unit 4

Analyzing Data Using Data Validation and Pivot Tables

• Understanding how to convert text to columns
• Understanding how to analyze spreadsheet data
• Understanding the basic pivot table layout and key terms
• Creating and formatting simple pivot tables
   

Notes

This course can be taken as part of the “Certificate in Mastering Excel”

Certificate in Mastering Excel | Temple University

• Mastering MS Excel (ONCE1163)
• Intermediate Excel (ONCE1164)
• Advanced Excel (ONCE1165)

Cancellation, Withdrawal and Refund Policy

A participant who withdraws from a non-credit course, in writing, up to one-week prior to the starting date of the course, will receive a refund, minus a $25 withdrawal fee; for all certificate programs the withdrawal fee is $50. For courses costing $75 or less, the withdrawal fee is $10 per course. No refunds will be given after that time. E-mail your withdrawal request to: ncce@temple.edu. Please note that if you do not officially withdrawal from a course and you do not attend the course, you are still responsible for payment. Temple University reserves the right to cancel a course for any reason. If the course is cancelled, you will be notified, and your entire tuition will be refunded.

For more information contact us at ncce@temple.edu or 267-468-8500.

Applies Towards the Following Certificates

• Certificate in Mastering Excel : Certificate in Mastering Excel