Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel : Complete Excel for Absolute Beginners
Rating: 4.3 out of 5(51 ratings)
1,846 students

Microsoft Excel : Complete Excel for Absolute Beginners

In this Excel course, you learn every essential thing about Excel and you learn to do your work and projects with Excel
Last updated 7/2020
English

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

Course content

14 sections69 lectures5h 18m total length
  • Introduction5:00
  • Menus4:09
  • Arrows1:43
  • Quick access bar5:22
  • Tabs and Ribbons2:07
  • Workbooks and worksheets3:07
  • Formula Bar1:52
  • Status bar3:46
  • Navigational process3:32
  • Shortcuts and mini tool bar4:26
  • Creating new work book4:05
  • Excel Help6:15

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