Online Free Google Sheets Courses with Zoran
Learn Google sheets
to boost your productivity.
CASE STUDY 9
OVERview ARCHI
Be in control of your projects from tasks to budget
OVERview ARCHI
FREE file included. Get it personalized from US $75
View Case Study
CASE STUDY 10
ARRIVING SOON
A new document will be released soon
CASE STUDY 7
SCHEDULE TEMPLATE
How to remove the used options from a Dropdown Menu
SCHEDULE TEMPLATE
FREE file included. Get it personalized from US $75
View Case Study
CASE STUDY 8
Dynamic Dashboards
FREE file included. Get it personalized from US $75
Dynamic Dashboards
How to create a Dynamic Dashboard over Multiple Sheets
View Case Study
CASE STUDY 5
MASTER QUOTE FILE
Create Quotes while keeping an eye on your Product Cost and Inventory
MASTER QUOTE FILE
FREE file included. Get it personalized from US$ 75
View Case Study
CASE STUDY 6
PERSONAL EXPENSES TEMPLATE
A fancy way to select data on a Personal Expenses Template
PERSONAL EXPENSES TEMPLATE
FREE file included. Get it personalized from US$ 75
View Case Study
CASE STUDY 3
Time zone calculator
Are you working with partners from other time zones than your? This will be a great file to have.
Time zone calculator
FREE file included. Get it personalized for Summer Time Zones for US$ 100
View Case Study
CASE STUDY 4
split data into multiple sheets
No need for complicated scripts to split your data in multiple sheets based on your defined criteria.
split data into multiple sheets
FREE file included. Get it personalized from US$ 50
View Case Study
CASE STUDY 1
Transaction Calculator & Brokerage Fee
An easy way to visualize data in a table.
Transaction Calculator & Brokerage Fee
FREE file included. Get it personalized from US$ 50
View Case Study
CASE STUDY 2
Translate entire sheets
A READY TO USE file allowing you to translate multiple cells at once with an easy to operate language selector.
Translate entire sheets
FREE file included. Get it personalized from US$ 10
View Case Study
Course 1
Google Sheets Essential Training
✔️ Navigate around Google Sheets
✔️ Write your first formulas
✔️ Cell references: absolute, relative, and mixed
✔️ Adjust the way data and information are displayed
✔️ Work with tables
✔️ Write your first formulas
✔️ Cell references: absolute, relative, and mixed
✔️ Adjust the way data and information are displayed
✔️ Work with tables
Google Sheets Essential Training
5 lessons - 4:11 hours
Course 2
Pivot Tables, Formulas and Functions
✔️ Sorting & filtering
✔️ Pivot Tables
✔️ Formulas
✔️ Functions
✔️ Tips & Tricks
✔️ Pivot Tables
✔️ Formulas
✔️ Functions
✔️ Tips & Tricks
Pivot Tables, Formulas and Functions
Personalized course - 1/2 day
Course 3
Google Sheets Advanced Training
✔️ Functions (part 2)
✔️ Data Validation
✔️ (Pivot) Tables & Graphs
✔️ Macros (basic)
✔️ Collaboration best practices
✔️ Data Validation
✔️ (Pivot) Tables & Graphs
✔️ Macros (basic)
✔️ Collaboration best practices
Google Sheets Advanced Training
Personalized course - 1 day
Course 4
Macros in Google Sheets
✔️ Advanced formatting options
✔️ Formatting with formulas
✔️ Links
✔️ Importing data
✔️ Advanced charts
✔️ Formatting with formulas
✔️ Links
✔️ Importing data
✔️ Advanced charts
Macros in Google Sheets
Personalized course - 1 day

Hey!
I Am Zoran!
With almost three decades of experience in Sales, Business Development, Product Management, Marketing, I am here to share my experience as a Google Guru & Office Expert.
Experienced Product Manager with a demonstrated history of working in the chemicals industry. Skilled in Marketing Management, Negotiation, Business Planning, Sales, and Partner Management.
Why My Courses
Grow your knowledge and
stay ahead of your competitors
100% free of charge
The Basic Google Sheets Course as well the presented Case Studies are FREE to use in any environment.
Trusted Knowledge
Almost 30 years of experience working mainly with FORTUNE 500 companies. It all started with "Quattro Pro" back in '93.
Anytime, Anywhere
In this connected world, distance is not a problem anymore: virtually everywhere & everytime!
Some Feedbacks
What people are saying
“Viorel Zoran has two business quality that i appreciate much: Patience and Perseverance. When the business gets tough, his patience wins him all the support he needs as a great team player. When customers solutions and creativity are needed he will not stop until the job is (well) done. His customer empathy and very good listening skill make Viorel Zoran an asset to any commercial team. Expect the best, but be ready for a change catalysator when he joins your company.”

"Viorel Zoran Bogdan is customer satisfaction oriented. He always knows and finds the fast and best solution in order to answer to customer request. Viorel Zoran Bogdan has very good technical, communication and sales skills.”
Mihaela CopaciHP Europe - Belgium
“Excellent customer and authority relationship, very good technical knowledge. Excellent long term vision on the business and the right balance corporate social responsibility versus business economics."
Rik Nuyttens3M Company
5/5 stars for Zoran! I approached Zoran with an idea, a concept and multiple messy google documents/sheets. I knew what I was looking to accomplish, but didn't have the knowledge or bandwidth to handle my work myself. So I went through the process of trying to source someone, and struck gold.
I was looking to create some formulas to track KPI's for my team members. All custom and a mess (TBH). He was able to make sense of the bad data, clean it up, and organize in a way that is easy to view and read. Also accurate too 🙂 Helped gained insight into what my team is able to accomplish and make my business more strategic and run more efficiently as a result.
