MICROSOFT EXCEL Complete: Zero to Pro Level With 8 Projects

Complete Microsoft Excel and Google Spreadsheets for Business Professionals. Manage Sales, Make Pivot Tables and Reports

Created by: Ivan Lourenço Gomes
Top-Rated Programming Instructor

What Will I Learn?

• Learn all the most important Excel & Google Spreadsheets built-in functions with practical examples: SUM, COUNT, SUMIF, COUNTIF, VLOOKUP, IF, AND, OR, etc.
• Apply formulas and use dynamic values for high productivity with your day-to-day work
• Master both Micosoft Excel and Google Spreadsheets for office use and collaborative work
• Create dynamic management reports and have a better understanding of your business data
• Have a deep understanding of pivot tables & charts and create corporate knowledge from your data
• Control the sales, purchases, stock, payroll and other management areas of your organization
• Create invoices and documents with formulas & calculations
• Work with several real-life projects: stock system, consumer price calculator, students grades & attendance control, sales projections, meal planner, etc.
• Learn how to work with CSV files that are interoperable with most software programs in the market to analyze external sources of data on Microsoft Excel
• Work with Macros and automate actions
• Protect your workbooks with password and block specific cells to make your worksheets safe and error-free
• Format your sheets for better usability and add menu with buttons to create your own system for all your office tasks

Requirements

• Students are required to have a computer with access to the Internet

Target audience

• Professionals of any business career seeking to master Microsoft Excel and Google Spreadsheets
• Sales managers and employees willing to improve the control over sales data and reports
• Any person willing to improve their Microsoft Excel skills for usage in many different applications