
Welcome to Excel Essentials. This will help you get started and some tips to get the most out of this course.
This section helps you understand what a spreadsheet is, how to navigate around a spreadsheet, and how to create one of your own.
This section will help you understand how to format a spreadsheet to make it easier to understand.
Learning to find and use templates can speed up your processes and help you to get the most out of your time in Excel.
The basics about formulas and functions, their differences, and how to get started with both.
Some examples of formulas created as potential answers for participants in other trainings.
How to quickly find specific data in a huge data set.
What are tables and why would you want to use one?
One way to speed up your text tasks in Excel.
Adding objects to a spreadsheet to help people understand your data.
Using page views, margins and scaling to adjust printing.
Using charts and graphs to communicate your information even better (people always like pictures better than just numbers!)
Final thoughts about where to go from here.
Excel is one of the most used software programs by businesses around the world. A basic knowledge of Excel is required for most jobs. This Excel foundational training provides new users with a basic to intermediate working knowledge of Excel. It also raises the skill level of self-taught Excel users by filling gaps in their working knowledge.
How You Will Benefit:
Get a firm understanding of the basics of working with Excel. How to find what you’re looking for, what can I do to speed up my processes , how can I not lose my data.
Understand how to work with data. How do you find data, import it, manipulate it, and export it for use in another program.
Become familiar with basic formatting and data analysis tools. Spreadsheets were developed to crunch numbers. While they have been used for many other things, analyzing data (crunching numbers) is their greatest asset.
Understand different ways of viewing and printing your data. If you have worked with Excel a lot you have probably wasted paper on a print. I’ll show you ways to work more efficiently without wasting so much paper and ink.
Understand how to add graphics and objects to your spreadsheets. Pictures sell. That’s why advertising is so image rich. Once you crunched you data, you need to put it in a format other people understand. Charts, graphs, objects can help you convince other people to go with your conclusions.