Udemy - Excel 2016 Beginner's Crash Course
MP4 | Video: 1152x720 | 64 kbps | 44 KHz | Duration: 2 Hours | 358 MB
Genre: eLearning | Language: English
Learn how to use Excel to professionally juggle dozens of simultaneous projects and budgets.
Learn the basic techniques and strategies to make rock solid schedules and budgets in Excel, without burying yourself in the financial and data mining side of the program.
These are the essentials techniques for everyone outside of the accounting dept.
Coordinate schedules between dozens of employees
Create budgets as a freelancer
Create budgets as an entrepreneur and/or manager
Let's not waste time on features you'll never use
Learning to use the features in Excel takes some practice, and the real challenge comes from coming up with strategies to combine the features together in powerful, readable and easily customizable ways.
How do you create documents that anyone in your organization can pick up and immediately start using?
How do you split up a budget in an efficient manner?
What do you do when there are hundreds of simultaneous projects happening, each with half a dozen people involved?
While Excel can't solve all of your problems as a freelancer or entrepreneur, using it efficiently goes a long way towards getting you the best possible results in the most productive way possible.
Content and Overview
Suitable for people relatively new to the program, this course starts with the basics of keyboard shortcuts, formatting, basic formulas, and generally working with cells.
After that's covered, it drops right into creating and growing out a schedule that's easy to adjust as surprises and changes occur. It digs into different tips and techniques to help you get things in the spreadsheet in the most readable adjustable way possible, which is crucial when you start having thousands of moving parts and cells to correspond with it.
Dealing with budgets can take many forms, from a personal budget through project budgets. Whether you're asking, how much should a project cost, how should you split up a budget with a specific starting number, or how can you create a template to apply to future budgets, this course digs in and shows you different strategies.
By the end, you should be in an incredible place to start improving your efficiency and work practices through Excel, and have a foundation to keep exploring the program even further.