
Hi and Welcome!! :) I hope you thoroughly enjoy this course on spreadsheets for business!
Please reach out to me if you have any questions or just want to say "Hey!". You can do so via any of the channels below!
LINKEDIN: https://au.linkedin.com/in/dannyblaker
TWITTER: https://twitter.com/DannyBlaker
or here at Udemy! :)
Just incase you skipped the first lecture, you can join the Spreadsheets for Business LIVE Community here :) https://plus.google.com/communities/114814516574323718643
Setting up Google Sheets:
1. Login to your google account. (If you don’t have a google account, just visit google and sign up - takes a few minutes but it’s well worth it! & it's Free!)
2. Open a new tab in your browser and search for google drive, then open it.
(For those unfamiliar, google drive is just a free place for storing files on the web - and it’s an especially great place for files you need to work on collaboratively with others.)
3. Create your first sheet by clicking on NEW, then go down to google sheets.
and Ta daa! Your sheet is being created before your very eyes! It may not look like much… but this little sheet is extraordinarily powerful. Lets go straight to the next lecture to begin exploring this extraordinarily powerful tool.
Haven't used spreadsheets before? Do you have your own projects, businesses, startups? This is the course for you.
Welcome to my introduction to spreadsheets for business owners and entrepreneurs! Learn how to use spreadsheets to discover interesting things about your business, make number crunching easy, and generally make your life easier as a business owner!
In this course we'll cover:
an introduction from scratch, including basic first impressions and use cases.
an introduction for basic formulars, including dependent formulars
an introduction to how spreadhseet can be used as a dataset
printing, formatting & links
conditional formatting
merging and positioning
applying filters
creating and customising charts
navigation help and shortcuts efficiently
By the end of the course, you'll be ready start other more advanced spreadsheet courses out there with some basic confidence.
If you already use spreadsheets on a daily basis, you might find this course too basic.
Thanks and Enjoy!
Below, i've included the top reasons Spreadsheets are useful for running businesses.
1. Financial Tracking and Budgeting
Spreadsheets make it easy to manage cash flow, track expenses, and build budgets. With formulas, you can automatically calculate totals, variances, and forecasts, reducing the risk of manual errors.
2. Data Organization and Storage
They allow you to store large amounts of structured information—like customer lists, supplier contacts, or inventory records—in a way that’s easy to search, filter, and update.
3. Decision-Making with Analysis Tools
Spreadsheets offer powerful functions like pivot tables, charts, and conditional formatting that help turn raw data into insights. Business owners can quickly spot trends, outliers, and opportunities.
4. Project and Task Management
Even without dedicated software, spreadsheets can act as lightweight project trackers. You can assign tasks, track progress, and set deadlines in a simple grid format.
5. Flexibility and Customization
Unlike rigid systems, spreadsheets are fully customizable. You can design them to fit the specific workflows of your business—whether that’s sales tracking, employee scheduling, or performance monitoring.
6. Collaboration and Sharing
Modern spreadsheet tools (like Google Sheets or Excel Online) let multiple team members work together in real time. This makes it easy to maintain a single source of truth for important business data.
7. Cost-Effective Solution
Most spreadsheet software is inexpensive—or even free. For small and growing businesses, this makes spreadsheets an accessible alternative to specialized (and costly) software.