Connect with us

Udemy

Microsoft Excel Training: From Zero to Hero in 8 Hours

George

Published

on

Excel with this Microsoft Excel Course. Learn Excel from A to Z in just 8 hours!!

Description

Welcome to Microsoft Excel 2016 Training course.

If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.

Learning Excel will become very easy if you do it the right way. First, you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.

In this Excel course, you will learn about:

Worksheet basics: Creating a worksheet, Entering data automatically with AutoFill, Inserting/deleting cells, columns, and rows, and cell formatting.

READ ALSO:  Deep Web- The complete Introduction to the hidden web

Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming, and using cell ranges.

Excel Formatting: Adjusting fonts, colors, adding pictures, shapes, and borders, inserting SmartArt, built-in styles, and creating and using templates.

Printing: Inserting headers and footers, generating PDFs.

Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek, and using the scenario manager in excel.

Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.

Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.

Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.

READ ALSO:  Big Data on Amazon web services (AWS)

Macros: Understanding, recording, using, and editing a macro.

Enjoy and happy learning!!

Who this course is for:

  • Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course.

What you’ll learn

  • Worksheet basics: Creating a worksheet, Entering data automatically with AutoFill, Inserting/deleting cells, columns, and rows, and cell formatting.
  • Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming, and using cell ranges.
  • Excel Formatting: Adjusting fonts, colors, adding pictures, shapes, and borders, inserting SmartArt, built-in styles, and creating and using templates.
  • Printing: Inserting headers and footers, generating PDFs.
  • Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek, and using the scenario manager in excel.
  • Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.
  • Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.
  • Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.
  • Macros: Understanding, recording, using, and editing a macro.
Enroll Now!

Requirements

  • Nothing is required! This course assumes you are a beginner at Excel.
READ ALSO:  Build Web-App without writing single Line of Code
Join us on Telegram
Advertisement
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Trending

NaijaTechClan