A blended course with exercises – learn as you create a working Gift Budget worksheet step by step with the instructor
What you will learn
Launch Excel and start a blank workbook
Alter size, colour and alignment of text and numbers
Set cell format as a currency with decimal points
Create basic formulas and use AutoSum
Use Conditional Formatting to highlight a problem
Insert and resize images
Manage language, check spelling and use the thesaurus
Print, save and close Excel
Find help within Excel and from the Instructor
Use the above skills to create a working Gift Budget for any occasion
Why take this course?
Super Simple Excel 2016 for Beginners is a concise course with exercises, aimed at getting you from no knowledge to to creating and using a gift buying budget. Follow along as we create the budget together step-by-step.
What type of learner are you?
- Reading Learners will benefit from reading the written step-by-step instructions
- Writing Learners will benefit from using the printable ‘Personal Quick Reference Guide’ download sheet as they make their own notes throughout the course
- Visual Learners will love the screen shots and video tutorials
- Auditory Learners benefit from the step-by-step commentary on the videos
- Kinaesthetic Learners will enjoy the hand on exercise at the end of each section as they get their work to the same stage as that part of the course
You are most likely a blend of learning types. Each topic is covered in a way that ensures that every learner gets the maximum out of the session.
Get Instant Notification of New Courses on our Telegram channel.
Note➛ Make sure your 𝐔𝐝𝐞𝐦𝐲 cart has only this course you're going to enroll it now, Remove all other courses from the 𝐔𝐝𝐞𝐦𝐲 cart before Enrolling!
This course is not a spectator sport; you won’t watch hours of video and hope it sinks in. Also, it will take you longer than you might expect if you do it right. We’ll start with a new, blank workbook and gradually build it up until it is ready to run a basic budget for buying gifts. Here’s how we’ll work together:
- You’ll read the lesson notes; step by step instructions supported by screen shots
- Watch and listen to the ‘how to’ video – I tend to talk on these videos as if I’m sitting right next to you
- You’ll do an exercise at the end of every section to get your own workbook to the same point as I got to in the lesson. Either do these exercises by following the instructions on-screen or by using the downloadable exercise book
- Finally, you’ll make make your own notes, a kind of quick reference guide to refer back to using the ‘Personal Quick Reference Guide’
If you have a question about a topic just ask in the lesson or in the supporting Facebook Group and I’ll answer.
What are you waiting for? Sign up and get started, If you’re not delighted you can have your money back, no questions asked.
English
Add-On Information:
- Course Overview
- This introductory program is specifically tailored for absolute novices who find the complex grid of a spreadsheet intimidating or overwhelming.
- It adopts a project-centric methodology, moving away from dry theory to focus on the immediate construction of a functional Gift Budget application.
- The curriculum is delivered through a “watch-and-do” synchronized approach, where the instructor and the student build the project simultaneously to ensure total comprehension.
- By stripping away advanced, unnecessary features, the course concentrates on the 20% of Excel functions that provide 80% of the daily utility for home and office tasks.
- Requirements / Prerequisites
- A working computer or laptop equipped with Microsoft Excel 2016 or an active Microsoft Office 365 subscription.
- Fundamental knowledge of operating a PC, including how to use a mouse, keyboard, and basic file navigation within Windows or macOS.
- Zero prior experience with spreadsheet software is expected; the course starts from the very moment you launch the application for the first time.
- A desire to move beyond manual pen-and-paper tracking toward digital automation for personal organization.
- Skills Covered / Tools Used
- Interface Navigation: Getting comfortable with the Ribbon, the Formula Bar, and the Status Bar to find tools quickly.
- Data Entry Foundations: Mastering the art of inputting text, dates, and numerical values without disrupting cell formatting.
- Basic Arithmetic Syntax: Learning how to write simple formulas that add, subtract, and multiply values to track spending.
- Visual Organization: Utilizing cell borders, background fills, and font styles to differentiate headers from data.
- The Power of AutoSum: Implementing the most popular shortcut in Excel to instantly total up columns of expenses.
- Sheet Maintenance: Managing multiple tabs, renaming worksheets, and ensuring the workbook is saved correctly for future use.
- Benefits / Outcomes
- Develop the confidence to open any Excel file and understand the basic relationship between rows, columns, and cells.
- Produce a custom-built Gift Budget that can be reused annually for holidays, birthdays, or special events.
- Reduce the risk of manual calculation errors by letting the software handle the math for you.
- Establish a solid foundational logic that makes transitioning to intermediate or advanced Excel courses much easier in the future.
- PROS
- Hands-on Experience: You don’t just watch; you build a tangible asset that you can actually use.
- Bite-Sized Lessons: Content is broken down into digestible segments to prevent cognitive overload for beginners.
- Immediate Practicality: The gift budget theme makes the learning experience relatable and less clinical than standard business tutorials.
- CONS
- This course is strictly foundational and will not satisfy the needs of users looking for complex data analysis, PivotTables, or Macro programming.
language
Found It Free? Share It Fast!