Microsoft Excel: from Beginner to Advanced (Full course) (Udemy.com)

Became in confident user Microsoft Excel just for a couples of hours! It is POSSIBLE

Created by: Denis Kulikov

Produced in 2021

icon
What you will learn

  • Learn all Microsoft Excel tools
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table
  • Microsoft Excel Interface (menu bar, sheets, cells, columns, rows)
  • Basic functions Microsoft Excel (printing, resizing, Autofill, Fleshfill, Shortcuts)
  • Work with data (find and replacing text, Constant link in formulas, Import text, Linking text)
  • Work with formulas ( brief information about all types of formulas)
  • Studying math formulas SUMM, AUTOSUM, AVERAGE, AVERAGEA
  • Studying logical formulas and statements (TRUE, FALSE, IF, IFERROR)
  • Studying other types of formulas ( VLOOKUP, HLOOKUP, MIN,MAX, DATE, DAY, TODAY
  • Studying advance formulas (SUMIF, SUMIFS, COUNTIF, COUNTIFS)
  • Formatting (Draw, Merging, Splitting text, Bordering, Filing (Coloring), Data grouping, text formatting)
  • Filtering and sorting
  • Working with Smart Tables (and slicing)<

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

icon
Course Description

*** Course access includes project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a money-back guarantee!***
__________
FULL COURSE DESCRIPTION:
Microsoft Excel nowadays is an absolutely essential tools for life. The truth is that, Excel is a really powerful, and dynamic data performing software . Absolutely everyone could get their life on a new level after studying this course and applying this knowledge in their lives.
This course provides you with all the tools and instruments which you need, to understand this software.
I am sure it is not so important to remember each of the functions, more essential is how to understand how Microsoft Excel "thinks" and know where you could find explanation of function which do you need.

Thats why my course consists of very individual, deep and simple explanations of each of the functions, which I placed separately. In this case if you forget some function you could come back to my video course and refresh all information in your memory.
__________
We will be raising such topics as:
  • Microsoft Excel Interface
  • Microsoft Excel basic skills (Printing, Resizing, Creating/saving/editing sheets and workbooks, Autofill, Shortcuts)
  • Microsoft Excel data skills (Import, finding and replacing text, constant links, linking text)
  • Formulas (SUMM, AVERAGE, SUMIF, COUNTIF, IF, TODAY, VLOOKUP, HLOOKUP etc.)
  • Formatting skills ( Filling, Bordering, work with pictures and other)
  • Visualisation skills ( Charts, Conditional formatting)
  • Extra skills ( Smart tables, Protection information, changing menu bars)
  • And more...
__________
NOTE: Full course includes downloadable resources and project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee.

Who this course is for:
  • People who want to start study Excel and have no any experience in it
  • Excel users who have basic skills but want to be BETTER
  • Anyone who want to expand their analytics skills, work more efficiently with data
  • Anyone who want to take their career to a new level
  • entrepreneurs, marketers, office workers,
  • Students, who want to develop their skills, and make their labor and life more effective

icon
Instructor Details

placeholder

Hi there! I am so glad you have found our page :)
I am founder of 7 years old group of the companies , also, owner of two dance schools (more then 200 students and more then 20 staff (Since 2011 y.) (Russia and USA); Russian far east child camp.
I have organized more then 100 hip hop events (include the biggest urban festival in last 10 years in far east of Russia (more then 4000 participants) and three international dance competitions (there was participate seven Russian's cities and five Chine's cities). And now I've started to share our experience with you my friend.

I was created this account with the only one reason - to share my knowledge.
I believe, that each person on the Earth able to do a business and achieve a financial freedom. We are - people! We are very talented and have a lot of potential. All what we need - it is a couple of advices from specialist. And I hope that I going to be that person, who will give you those advices.

icon
Reviews

4.2

29 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

It's ok and I have something new

yes.. till now i founf it good anf also rated it 4 star. The reason to cut one star was the accent of the tutor is a little bit difficult to understand and my suggestion is if possible please add subtitles..

Amazing course!! There's so much to do with Excel that i couldnt imagine. Now im able to use it not only better in my work, but also for personal stuffs, even for gaming! Thanks a lot!!!!!

didnt meet my expectation

his voice is very low and can't hear him much.

Nice lectures.I have learned amazing stuff about excel.

great leanings and good usage of various examples

Chapters 1 & 2 were hard going, but the trainer has started to cover some more challenging concepts further on, I just wish that the tests covered more material for students to practice rather than just theory.

it's very good , i benefit from every minute in this course

and intructor is be graet

thank to him

The Author is so cool. Explained everything in a very simple manner and loved his accent.

Quiz in the section need to be improved. Data validation and conditional formatting are great tools I have learnt.