Documentation:Excel Guide for LFS Students
Introduction
Some courses require you to have some basic excel knowledge, so this guide's aim is to introduce a beginner level student to excel. Feel free to skip some of the videos if you are already familiar with the subject.
Common Operations Used in Class
Here is a list of some operations that are useful for data manipulation:
- Data Organization: numeric and date formats (e.g. number digits).
- Functions.
- Formulas.
- Data Summary: count, mean, median, min, max.
- Pivot tables to automatically summarize large data sets.
- Graphs: pie chart, bar chart, scatter plot, line graph.
- Combined bar and line graph.
- Formatting axis (min, max, major units, decimal places)
This is by no means a comprehensive list, it is just some of the things you might encounter.
Instructions
In this guide our main resource will be the GCF Global videos page. After watching the chosen videos below you should be able to navigate excel with ease. Check out the extra tips section for more specialized operations.
Main
- Getting Started: Familiarize yourself with the excel page.
- WorkBooks & Save and Share: Save, load and understand workbooks.
- Cell Basics: Introduction to basic cell manipulation.
- Modifying Columns, Rows and cells
- Formating Cells
- Number Formats
- Intro to formulas
- Complex Formuals
- Functions
- Working With Data
- Freezing Panes
- Sorting Data
- Filtering Data
- Tables
- Charts
- Optional: Conditional Formating
- Intro to Pivot Tables
- More on Pivot Tables
Here is a Quiz to test your knowledge.
Extra Tips
More Resources
For more about formulas Visit this guide.
A useful website for finding a specific task: http://www.excel-easy.com/
Another Possible Resource: http://chandoo.org/wp/excel-basics/