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
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)<
Quality Score
Overall Score : 84 / 100
Course Description
__________
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
Instructor Details
- 4.2 Rating
29 Reviews
Denis Kulikov
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.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
Provider: Chandoo.org
Time: 1h 30m
Free


