Microsoft Excel is the industry standard in spreadsheet tools – part of the Microsoft Office Suite, it’s used by top analysts and professionals across a wide range of industries. Whether you want to work on Windows, macOS, Android or iOS, Excel will allow you to develop valuable insights by storing, organizing, and manipulating your data with ease.
With The Complete Excel Productivity Bundle, you’ll transform Excel from a basic spreadsheet app into a dynamic and powerful analytics tool. From mastering the application’s most useful and powerful functions to conducting sophisticated analyses, you’ll be able to increase your productivity and save yourself time and effort.
You’ll learn through a hands-on, project-based approach – working with real datasets that will help to cement your knowledge.
You will master:
- Excel’s basic features
- Working with large quantities of data
- Basic to advanced mathematical operations
- Logic, formulas, and functions
- Statistical analyses
- Visualizing data on charts and tables
Build Excel Projects
Create a portfolio of Excel projects, including:
Curriculum
- Menus & shortcuts
- Sorting & filtering
- Basic formulas
- Spreadsheet organization
- Conditional formatting
- Referencing cell data
- Looking up & indexing data
- Matching data
- Validation & error handling
- Flash fill
- Statistical formulas
- Advanced text functions
- Charts & trends
- Interactive visualizations
- Table styling
- Formulas & slicers
- Aggregating data
- Data summarizing
- Custom fields
Why Learn Excel?
As data and data-tracking become more integral to business decisions, so too does the need for Excel. Millions of businesses prefer Excel for their day-to-day operations, and a high percentage of employees use Excel every week for data management and office productivity. Knowledge of Excel will help you to work more quickly and efficiently, and provide you with access to more career opportunities.
WHO CAN TAKE THESE COURSES?
We start with the absolute basics and go through everything step-by-step – so even if you have zero experience in programming, you’ll be able to easily follow along.
More experienced? Whether you’re wanting to brush up, expand your skills, or learn a new technology, our courses are structured in a way that makes it easy to skip ahead to the lessons that are relevant and interesting to you.
REINFORCE YOUR LEARNING
Zenva’s courses feature quick challenges that will speed up your learning.
Access live coding lessons where you can practice coding right in your browser, and instantly see the results of any changes you make to the code:
Reinforce key concepts with in-course quizzes, which appear throughout courses:
COURSES BY THE WORLD’S BEST
Our course instructors aren’t just fun to learn from – they’re also serious gamers, qualified coders, and have been formally certified by Unity Technologies and CompTIA for their excellent programming and teaching skills. That way, you can be confident that you’re developing strong, modern skills that will set you up for success as a game developer.
