*** Proof of Product ***
Exploring the Essential Features of “Anne Walsh – Excel Essentials – build a strong foundation for your Excel journey”
Does this sound familiar?
You hear all the time that ‘Excel is a great tool’, but you have no idea what that means
You’ve tried using formulas, but can’t get them to work for you
No matter what you’ve tried, printing from Excel NEVER comes out the way you want
You’ve seen people present snazzy Excel charts in a meeting and wondered how they did it
Excel absolutely terrifies you
So what’s in it for you?
- Excel is one of the most portable skill-sets on the planet: good Excel skills make you immediately more employable!
- Everything is presented in bite-sized chunks, so easy to watch and go back to as often as you want
- Take the course at a time and location of your choosing, no travel or parking issues to deal with
- You don’t need any previous knowledge, but you might find you already know more than you think!
Course Curriculum
Welcome
4 Lessons
Overview and what to expect
About the instructor
Let’s meet the Excel environment
Let us begin
Data Entry
7 Lessons
Introduction to data entry
Why is data entry so important
Do’s and don’ts of data entry
Enter dates and numbers in sequence
What to do when you see ######
Here’s your homework
Quiz on data entry
Data Formatting
8 Lessons
Introduction to data formatting
Formatting text
Formatting text – alignment
Formatting numbers
Copying the formatting from another cell – Using the format painter
Clearing all formats
Here’s your homework
Quiz on data formatting
Introduction to Formulas
7 Lessons
Introduction to basic formulas
Basic formula entry
Addition and subtraction
Multiplication and division
Using brackets
Here’s your homework
Quiz on basic formulas
Fixing Cells
4 Lessons
Introduction to fixing cells aka making it absolute
Fixing cells
Here’s your homework
Quiz on fixing cells
Navigation around Excel
4 Lessons
Excel keyboard shortcuts
Working with rows and columns
Here’s your homework
Quiz on navigating in Excel
Basic Functions
5 Lessons
Introduction to basic functions
Using autosum to create totals
Basic functions: Max, min, count, average, count, counta
Here’s your homework
Quiz on basic functions
Creating Charts
5 Lessons
Introduction to charts
Use recommended charts and clean data
Chart formatting
Here’s your homework
Quiz on charts
Worksheets
6 Lessons
Introduction to working with worksheets aka tabs
Move/copy to another worksheet
Add/colour/delete/hide/new worksheets
Creating 3-D formulas i.e creating a formula across worksheets
Here’s your homework
Quiz on worksheets
Creating Lists in Excel
9 Lessons
Introduction to lists in Excel
Guidelines on setting up a list
Sorting by one level
Sorting by more than one level
Filtering with text
Filtering with numbers
Filtering with dates
Here’s your homework
Quiz on creating lists in Excel
Printing
5 Lessons
Introduction to printing
Getting the text to fit
Adding headings aka using print titles
Here’s your homework
Quiz on printing
You’ve done it
1 Lesson
Congratulations and well done – you are part of an elite group that actually finishes courses
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
