Microsoft Excel from Beginner to Advanced (Full course)

Bo0mB0oma · February 17, 2019

MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch

Genre: eLearning | Language: English + .VTT | Duration: 3.5 hours | Size: 1.99 GB

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

What you'll 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)

Creating Charts

Extra functions (Protect information, Changing menu bars, Notes and )

Requirements

You need PC or MacBook

You have to have Microsoft Excel or access to Google Spreadsheets

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, 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...

Who this course is for:

People who want to start study Excel and have no any experience in it