Description
Stay Focused. Learn for Real!
The Microsoft Excel Zero to Master Complete Course made up of max 15-minute long lessons.
A complete Master, recorded with Excel 365, constantly updated, made up of 5 levels which will make you a new Excel hero: Zero, Base, Intermediate, Advanced and Master.
The schedule provides a project with which you will be able to create and manage - on your own- a hypothetical Company- both as for the commercial part and for the administrative and bureaucratic part- in addition to a VBA project, with which you will create a data entry system, within an Excel file.
Suitable to any type of person, this course does not require any type of ITC know -how, you just need to have a PC to start off the adventure with this fantastic application program.
Every single recorded video was framed in a specific section so that to facilitate the learning, to give you the chance to follow it at your ease and at your own pace distributing the span of every step in the best possible way.
You will find more than 10 exercises helping you test what you’ve learned in the various phases of the course: the structure of every group of lesson was carefully planned to simulate a classroom experience, with the difference that it’s entirely up to you when to stop, easily acknowledging by yourself whether every topic has been fully grasped.
The topics of the lessons are the ones we consider essential to match the best expertise in the software with a perfect learning experience so that to enable you to work with Excel fully exploiting its potentials, at every level.
Every published update will be signposted: we will give you the opportunity to choose the topics to drill down.
Go through the list of the sections to get the idea of the carefulness displayed along this course: nothing is left to chance, everything is put forward in the easiest and in the most practical way and ...don’t forget to follow our personal pages, where we will gradually insert all our courses, to become an absolute expert in the ITC realm!
If you have any questions, you can: check the list provided in this course- in case they have already been posted and answered-, use the Forum or simply ask! Any doubt deserves being resolved to enable you to learn everything without any difficulty.
What Will You Learn?
- Learn to use Excel at the highest level, become a professional
- You will be guided to consolidate your Excel basic Knowledge
- Look into common and new Excel formulas
- Manage large amounts of data, make your reports automatic and simplify your work routine
- Follow the exercises and upgrade your Excel projects
Requirements
- No previous knowledge of Microsoft Excel is required
- The Microsoft Excel software already installed
- Course recorded with Excel 365, the updates will ALWAYS be provided with the latest version available; the use of the 2010, 2013, 2016, 2019 and following versions is also possible
Curriculum
Course consist of total 12h 57min of content, in total.
Section 1: Course Introduction
Section 2: Excel Zero: Getting Started
Section 3: Excel Zero: Work Environment
Section 4: Excel Zero: Text Formatting
Section 5: Excel Zero: Formulas
Section 6: Excel Basics
Section 7: Excel Basics: Fundamentals
Section 8: Excel Basics: Cells Formats
Section 9: Excel Basics: Formulas
Section 10: Excel Intermediate
Section 11: Excel Intermediate: Text Formatting
Section 12: Excel Intermediate: Content Management
Section 13: Excel Intermediate: Formulas
Section 14: Excel Intermediate: Charts
Section 15: Excel Advanced
Section 16: Excel Advanced: Formulas
Section 17: Excel Advanced: Data Management
Section 18: Excel Advanced: Charts and Maps
Section 19: Excel Advanced: Pivot Tables
Section 20: Excel Master
Section 21: Excel Master: Array
Section 22: Excel Master: Array Formulas
Section 23: Excel Master: Data Management
Section 24: Excel Master: Macro
Section 25: Excel Master: VBA Start
Section 26: Excel Master: VBA Objects and Collections
Section 27: Excel Master: VBA Properties
Section 28: Excel Master: VBA Methods
Section 29: Excel Master: VBA Functions
Section 30: Excel Projects: VBA
Section 31: Excel Projects: MyCorp
Section 32: Excel Projects: MyCorp - The Warehouse
Section 33: Excel Projects: MyCorp - Charges
Section 34: Excel Projects: MyCorp - The Warehouse
About the Instructor
Hi, my name’s Manuel :) I've been a full stack web developer, designer and marketer since 2006 with a computer technology degree.
I had my first computer at 10 years old and I started programming at 13, then I started my ITC education focusing on statistics and web technologies.
I've been working for several international companies since 2006, and in 2019 I established my own company.
Now I am setting up websites, I ‘m supporting some companies in their online growth and I dedicate myself to my greatest desire, to teach others what I am most passionate about.
I want my courses to be clear and useful, without you ever losing concentration: if you find a lesson longer than 10 minutes, I'm sorry, but I couldn't explain it to you in less time.
BitDegree platform reviews
