Over 75% of jobs require digital skills such as Excel and word-processing. Your ability to create spreadsheets, utilize basic formulas, and work with datasets could advance your career or help you land your next job!
In Excel 101 Sessions 1-4, you will learn how to create basic spreadsheets from scratch, enhance the look and readability of those spreadsheets, and practice the most common and useful formulas and functions. Then this training will teach you how to visually present your data using charts, sparklines, and conditional formatting. Moving to the next level, work alongside the instructor to discover how to manipulate and quickly analyze data by discovering the subtotal command and creating structured tables.
Create and Format a Spreadsheet
Work along with an instructor to explore how to use the Excel application. Design and create a spreadsheet and then enhance it with text and number formatting techniques. Use basic formulas and understand the difference between relative and absolute cell references. Learn how to save and print your spreadsheet and import or export data. And to increase your efficiency and accuracy with this program, key navigation and selection techniques will be demonstrated throughout the course.
Top 12 Functions
Excel is a program that will happily “do math” for you! In this course you will learn how to summarize data in Excel using the most common and useful formulas and functions. You will work along with the instructor to create basic formulas using absolute and relative cell references and the order of operations. Then you will learn how to find and unlock the power of functions in Excel. There are over 450 functions in Excel - you will learn how to find and use any function in Excel and become competent with the top 12 functions.
Charting and Conditional Formatting
Make your data easier to understand by displaying your data graphically. Create the 3 most common charts in Excel – the Pie, Column, and Line Charts. And learn about Sparklines, a new mini-chart that will show data trends. You will also discover how to highlight data by using Conditional Formatting to apply colors, formats, and icons when certain data conditions are met. These visual summary techniques will help your audience understand your data analysis faster and easier!
Beginning Data Analysis
This course will improve your ability to manipulate data and quickly extract the data and answers you need from your dataset. Start by working alongside the instructor to discover the Sort and Subtotal commands to help you easily summarize your data. Then learn to create a Structured Table in Excel. These tables provide 5 great benefits for data analysis: 1. Structured Formula References, 2. Autofill Formulas, 3. Quick Summation using the Total Row, 4. Sort and Filter Capabilities, and 5. Enhanced Formatting.
Login/Create account
checkout
view cart (
0
)
