Microsoft Excel Beginner & Intermediate Training w/ Projects
A Beginners and Intermediate Guide to Using Microsoft Excel in the Real World
Course Description
Course Highlights:
Microsoft Excel is an amazing application. Over the last 30 years, it has become the industry
standard for organizing, analyzing, manipulating, and storing data in tabular form.
Why Learn Excel
?
Microsoft Excel is the world’s most popular spreadsheet
program.
Maybe you have a small business, and you need to learn Excel for tracking your sales. Maybe you want to work at a startup, consulting firm, or investment bank... Maybe you're a recent graduate apply for an analyst job at a Fortune 500,,,, Or maybe you're like me and you want to be able to do more in less time, perhaps get a raise or job promotion.
Knowing how to use Excel to solve real-world problems can be an awesome tool
to help differentiate you from the competition!
In this Course:
Learning Excel takes time, particularly if you try to do it without any structure
!
In this course, we'll talk you through the basics from how to create a spreadsheet, to how to sort and filter your data in tables, even create charts and use awesome tools like Sparklines and Flash Fill!
In this training course, we’ve broken down Microsoft Excel into ten main sections:
In each section, we walk you through the core components of the skills and techniques that you need to use Microsoft Excel in the real-world.
Each lesson will cover one single topic, delivered in a short bite-sized video.
At the end of each section we’ll do a small project, in which you can apply the core skills that you’ve learned in the section.
We've made it easy to follow along with the course, by providing a course PDF, and for those of you interested- feel free to download the course Exercise and Project files.
So...
If you have questions, comments, ideas, we’d love to hear from you.
Email or message us any time.
Look forward to having you in class!
Cheers,
Ryan & Tolan
Co-Founders of ProductivityMe
- 80+ Individual, Bite-Sized Lessons
- 9 Real-World Mini-Projects
- Course PDF & Road Map
- Verifiable Certificate of Completion
- Downloadable Excel Files & Corresponding Project Files
- Instant to Instructor and the ProductivityMe Community
- Regular Course Updates and Bonus Materials Provided
Microsoft Excel is an amazing application. Over the last 30 years, it has become the industry
standard for organizing, analyzing, manipulating, and storing data in tabular form.Why Learn Excel
?Microsoft Excel is the world’s most popular spreadsheet
program.Maybe you have a small business, and you need to learn Excel for tracking your sales. Maybe you want to work at a startup, consulting firm, or investment bank... Maybe you're a recent graduate apply for an analyst job at a Fortune 500,,,, Or maybe you're like me and you want to be able to do more in less time, perhaps get a raise or job promotion.
Knowing how to use Excel to solve real-world problems can be an awesome tool
to help differentiate you from the competition!In this Course:
Learning Excel takes time, particularly if you try to do it without any structure
!In this course, we'll talk you through the basics from how to create a spreadsheet, to how to sort and filter your data in tables, even create charts and use awesome tools like Sparklines and Flash Fill!
In this training course, we’ve broken down Microsoft Excel into ten main sections:
- Getting Started with Excel 2013
- Entering Data
- Formulas and Functions
- Formatting & Presenting Data
- Database Features
- Using Tables
- Charts & Graphs
- Modifying & Adjusting Data
- Using Special View Features within Workbooks
- Managing Worksheets within a Workbook
In each section, we walk you through the core components of the skills and techniques that you need to use Microsoft Excel in the real-world.
Each lesson will cover one single topic, delivered in a short bite-sized video.
At the end of each section we’ll do a small project, in which you can apply the core skills that you’ve learned in the section.
We've made it easy to follow along with the course, by providing a course PDF, and for those of you interested- feel free to download the course Exercise and Project files.
So...
If you have questions, comments, ideas, we’d love to hear from you.
Email or message us any time.
Look forward to having you in class!
Cheers,
Ryan & Tolan
Co-Founders of ProductivityMe
What are the requirements?
- No previous knowledge of Excel or spreadsheets is required
What am I going to get from this course?
- Over 96 lectures and 8.5 hours of content!
- Create, modify, and delete worksheets
- Create, manage, and format complex Excel workbooks
- Understand and employ special views and features within Microsoft Excel worksheets
- Enter, edit, organize, and manipulate data
- Use common formulas and functions
- Create charts, tables, filters, and other useful tools in Excel
- Sort, dissect, remove, re-aggregate sets and subsets of data
- Create compelling visual presentations of your data
- Create own unique problem sets to practice with
- Use Microsoft Excel to solve real-world problems
- Understand possible next steps to continue building own skills in Microsoft Excel
What is the target audience?
- Excel 2010, 2013, or 2016 (Windows)
- Beginner and intermediate users
for Beginners 
and VBA Code with Practical Exercises. 
programs, come with a powerful scripting language known as VBA. With a little bit of programming knowledge, complex tasks can be fully automated and completed in seconds. This course assumes no programming experience; only a reasonable level of familiarity with Excel.
for the demonstrations, and comes with .xlsm files for the code examples. These demos and files will be compatible with later versions of Excel as well. If you are using Excel 2003, you will not be able to open the .xlsm files, but you will be able to follow along with the demos. 
are used in programming to represents words and characters. For example, "hello world" could be stored in your VBA code as a string. You could then perform various operations on your string, such as converting it to upper-case, replacing a word, counting the number of characters, and many others.
. You will able to write code that implements logical rules and makes decisions.
will be introduced next. These objects are what will allow you to read and manipulate your Excel data from your VBA code. We will then move on to subs and functions. These will allow you to organize your code into small, cohesive pieces, making it easier to reason about complex tasks.
required.
.