*** 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/
