Introduction to Microsoft Excel
Pima Community College
Course Details
Create worksheets to manage, store, organize, and analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel. This course will introduce you to the 2019 version of Microsoft Excel's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons.
Software Requirements: PC: Windows 10 or later operating system. Latest broser version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Excel software, Acrobate Reader.
What You'll LearnExplore the Excel interface Create a worksheet Practice using shortcuts Explain relative, absolute, mixed and circular reference Build a table, subtotal, sort and filter Create a graph and adjust chart type, labels, titles, colors Personalize charts Perform statistical functions Create an amortization table and practice financial functions Use macros to reduce complex tasks Use Excel's IF function to aid in comparing variables Lesson 4 - Re...View moreSkills you'll acquire
Knowledge Outcomes and Experience
- Office Clerks, General
- First-Line Supervisors of Office & Administrative Support Workers
- Bookkeeping, Accounting, & Auditing Clerks
- Bill & Account Collectors
Course Content
Eligibility
There are no prerequisites. Instructional materials are included in the enrollment cost.
Related Courses
Blogs and Articles
.webp)