Are you relatively new to Microsoft Excel? Have you received a quote form from someone and wondered how they created it? Yeah, me too. You can do some crazy things with Excel if you know what you’re doing. In today’s video we will show you how to create a very basic quote form and price sheet. Some of the things you’ll learn in this video are:
How to merge cells
How to hide worksheets
How to hide columns
How to create if, then formulas
How to create validated lists
How to use conditional formatting to show required fields
How to define the print area
How to protect cells in a worksheet
How to protect a worksheet from edits
How to protect a workbook from edits
Again, this is a very, very simple example of a price sheet and quote form but it should give you a few tips that my maybe didn’t know before. Make sure you subscribe to our YouTube channel to get more Microsoft Excel tips. And please remember that Excel is great for a lot of things but it’s not the perfect tool for everything. Please consider e2b teknologies for your business technology needs when you’ve outgrown Excel and need a professional business intelligence application to create professional reports and business forms.
Contact us to learn more about our passion for solving problems and how it drives us to deliver innovative solutions for everyone we work with!
For today’s competitive staffing organizations, fast growth depends on fast decisions derived by leveraging the right information at the right time. The answer: Cloud Accounting Cloud accounting helps reduce hours to minutes, helping professional services firms take advantage of automated revenue management for real-time reporting and operational transparency. Today’s growing staffing organizations require real-time business […]
In virtually any healthcare organization, corporate accounting is the custodian and curator of financial data to monitor and manage the organization and drive it forward to new levels of success. But as any controller or CFO of a multi-entity healthcare organization can tell you, financial consolidations remain one of the key hurdles. The time-intensive nature […]
WHY CHOOSE US?
Our PASSION for solving problems drives us to DELIVER INNOVATIVE
SOLUTIONS for everyone we work with.