About Excel
Excel allows you to organise data in the format of rows and columns with the use of mathematical functions which are useful for:
- Data Entry, Analysis and Management
- Visualisation of Data and Graphs
- Financial Modeling, Accounting and Budgeting
- Programming
These are just some of the few uses for Excel! But the uses of this program is really limitless in what you’d like to create.
Overview
Excels interface is built up of your top Ribbon and the current Sheet. Your Excel file is referred to as a Workbook which is made out of multiple Sheets. Each Sheet has rows labeled in number format and columns labeled in letter format.
A cell refers to a single box which has a reference to where the column and row intersect to meet this single box.
Here we are in Sheet1 and Cell Reference B2. At the top shows the workbook name of Book1.
Lesson Guide
This excel section increases in difficulty, range of automation and efficiency with your spreadsheets.
Starting with useful functions to allow you to create spreadsheets more efficient branching into creating a sheet that is dynamic with your data. This allows you to streamline your processes and reduce time spent on changing formulas when things change.
Pivot Tables and Power Query are great tools that not many people know are within Excel and are extremely useful to sort data and summarise it.
To tie into the end of the Excel Basic is the use of backend Visual Basics code to automate and connect with Excels functions to make processing anything with ease.
- Functions
- Name Ranges
- Conditional Formatting
- Charts and Graphs
- Pivot Tables
- Power Query
- Macros and VBA
- Formatting & Cell Manipulation
- Data Import & Export
- Data Analysis
- Data Validation
- Keyboard Shortcuts
Spreadsheet Examples
There are several spreadsheet examples that tie into the lesson guide to help provide direction on how to efficiently plan your sheets and the data within them to allow to streamline your process.
When creating a spreadsheet that will be used again, it’s good practice to create the sheet so it will suit and conform to different data so when using it again you don’t have to rework everything.
Skill Level
If you’re completely new to excel we recommend w3schools to learn the formatting, syntax, and getting familiar with Excel.
We will go through the useful functions, advanced formatting and analysis in detail along with the units in the Lesson Guide
There’s are great Youtube Video to get the excel basics The Beginner’s Guide to Excel - Excel Basics Tutorial
Since we do go through functions to improve the efficiency with your spreadsheets its good to have a basic level understanding around excel before enhancing your skills here!