The Microsoft Excel Zero to Master Complete Course
- Description
- Curriculum
- FAQ
- Reviews
The Microsoft Excel Zero to Master Complete Course
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.
-
13Create your first words listVideo lesson
-
14Create your first numbers listVideo lesson
-
15Select, copy, paste and cutVideo lesson
-
16Order, filter and remove duplicatesVideo lesson
-
17Find and replaceVideo lesson
-
18Fonts, text alignment and colorsVideo lesson
-
19Exercise #1 – To do ListVideo lesson
Create a printable version of your first To-do list with Excel
-
20Exercise #1 – SOLUTIONVideo lesson
-
21Structure of elementary Excel formulasVideo lesson
-
22SUM math functionVideo lesson
-
23UPPER, LOWER and PROPER text functionsVideo lesson
-
24Arithmetical operators and calculation logicVideo lesson
Let’s explore the Bodmas logic, which Excel exploits to perform the calculations
-
25Basic date and time functionsVideo lesson
Let’s drill down the TODAY and WEEKNUM basic formulas
-
26Exercise #2 – Name and yearsVideo lesson
Create a list of names and surnames, insert the ages and make the sum
-
27Exercise #2 – SOLUTIONVideo lesson
-
41Structure of basic Excel formulasVideo lesson
-
42COUNTA math functionVideo lesson
-
43AVERAGE math functionVideo lesson
-
44ROUNDUP and ROUNDDOWN math functionsVideo lesson
-
45LEN text functionVideo lesson
-
46CONCATENATE text functionVideo lesson
-
47ROW and COLUMN search functionsVideo lesson
-
48Exercise #4 – Text in five cellsVideo lesson
Calculate the length of the text inserted in 5 cells, average it out and round it up
-
49Exercise #4 – SOLUTIONVideo lesson
-
51Text in columnsVideo lesson
-
52Conditional formattingVideo lesson
-
53Format PainterVideo lesson
Copy the cell format into another cell
-
54TransposeVideo lesson
Move a series of cells from a column to a row, or vice versa
-
55Insert comments or notesVideo lesson
-
56Advanced orderVideo lesson
-
57Advanced filtersVideo lesson
-
58Exercise #5 – To Do List cells textVideo lesson
Insert a comment to the cells and apply the conditional formatting to the previously created TO DO LIST
-
59Exercise #5 – SOLUTIONVideo lesson
-
66IF logical functionVideo lesson
-
67IFERROR logical functionVideo lesson
-
68COUNTIF math functionVideo lesson
-
69VLOOKUP and HLOOKUP search functionsVideo lesson
-
70LEFT and RIGHT text functionsVideo lesson
-
71MID text functionVideo lesson
-
72SUBSTITUTE and REPLACE text functionsVideo lesson
-
73DATE, EMONTH and DATEVALUE date and time functionsVideo lesson
-
74Date and time expert functionsVideo lesson
Let’s break through the intermediate-level formulas: NOW, DAYS360, YEAR, MONTH, DAY, HOUR , MINUTE, SECOND and TIME
-
75Exercise #6 – Functions MixVideo lesson
Starting from exercise 2, perform the following operations: Merge, Substitute, Identify, and Assign
-
76Exercise #6 – SOLUTIONVideo lesson
External Links May Contain Affiliate Links read more