Microsoft Excel : Complete Excel for Absolute Beginners
What you'll learn
- Use Formulas
- Use variety of function
- Create professional charts and tables
- Create Pivot charts and Pivot Tables
- Secure you workbooks and worksheets
- Do data management
- Do data analysis
Requirements
- Lots of motivation and passion
- Internet connection
- Computer (Linux, Mac or Windows)
Description
This course was designed for all who do not have any background but want to learn Excel very well and do professional and real-world projects. So you will learn Excel from very basic concepts professional concepts, functions and formulas. In this course, the approach is simple: learning useful and practical techniques and tools. So we avoid wasting our time on useless concepts which are not used in real projects. This course teaches you every dimension of Excel in which you learn how to use special methods, codes and tricks to have write complex codes with least codes and finally create professional programs, apps and games. Generally, some of the topics and concepts you learn in this course are as the following:
· Create Functions
· Create Formulas
· If, VLOOKUP and other Essential Functions
· Data Management
· Data Analysis
· Adjusting Worksheets
· Printing
· Formatting
· Create Pivot chart
· Create Pivot table
· Use Macros
· Secure your workbooks and Worksheets
· Financial formulas and functions
· And much more
Who this course is for:
- People who don’t have any background on Excel
- Those who are at beginner level and want to learn Excel and do their projects
- People who want to do data management, data analysis and use special formulas and function of Excel in their projects
- Marketers, managers, financial analysists who want to classify, analyze and forecast their data using Excel
Instructors
Mostafa Bigdeli (Merlin)
A talented one!
Mostafa Bigdeli known as Merlin is a professional programmer (Python, JavaScript, C++, C#) ,and experienced IELTS instructor with almost 8 years of experience.
As a programmer and IELTS instructor with both academic and in field experience and due to lack of good courses on IELTS, designing and programming, he has decided to create applicative and up-to-date courses with clear explanations.
Therefore, his courses not only covers the techniques and tips which other courses of market place do not cover, but also is a combination of academic background and 8 years of programming and IELTS.
Today, Merlin has hundreds of students worldwide most of who admire and thank him for being a responsive and friendly teacher with clear explanations
In addition to numerous seminars and webinars he holds annually on programming and IELTS.
Milad has a Bachelor of Software Engineering and Masters of Electronics and is also a Certified National Instrument (NI).
Regardless of his academic background, he has in-field experience in programming as he started programming and doing professional projects for many companies based in and out of the USA since 2004. He has taught LabVIEW from fundamental to advanced since 2012. He is also professional in PLC, Altium Designer (Designing PCB), AVR and ARM Microcontroller Programming, Designing Analogues and Digital Electronics, Simulation, and Modeling of Multiple Systems in the Matlab Simulink environment.
Being passionate about the world of graphics, he started working on Graphic Design (Photoshop, Illustrator, Adobe Lightroom) since 2008. Today, he is working on Graphic Design professionally and has some students as well.
Milad today is holding many Seminars, Webinars, and creating courses on programming and graphic design and has thousands of students who admire him as a great and knowledgeable teacher with clear explanations.