Editor choice

100% free-Learn Basic Excel Skills For Beginners

Spread the love

Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data-Free.

What you’ll learn

  • Enter data in a spreadsheet
  • Save and open spreadsheet
  • Create formulas and functions
  • Format rows, columns, cells, and data
  • Align text in a cell
  • Adjust rows and columns
  • Find and replace data
  • Insert and delete sheets
  • Sort data
  • Add Borders and Fill Colours
  • Use Number Formatting
  • Use AutoSum
  • Insert Functions

Requirements

  • You should be able to use a PC at a beginner level

Description

Microsoft Excel is a powerful tool essential for managing and presenting data
in today’s working environment. In this one day excel course,
you  will gain the knowledge and skills required  to create and edit worksheets, use formulas
and functions, sort and filter detail data visually, and present summary information
in a consumable and professional format.(free)


What You Will Learn Include:

  •  What is Office 365
  • Setting up Office 365
  • Excel 2016 user interface
  • Exploring the Excel Ribbon 
  • Customizing the Quick Access Toolbar
  • Keeping Tabs on the Ribbon
  • Entering Data 
  • Opening a new workbook 
  • Entering Data in Excel
  • Basic Data entry
  • Entering Data with Autofill
  • Entering Date
  • Entering Time
  • Undo and Redo Changes
  • Adding Comments
  • Giving your worksheet a title
  • Saving your work
  • Creating Formulas and Functions 
  • Using formulas for arithmetic tasks
  • Re-using Formulas
  • Calculating YTD Profits
  • Calculating Percentage Change
  • Using Relative and Absolute Reference
  • Using RANK Function
  • STD Function
  • Small and Large Functions
  • Median Function
  • Count and counta functions
  • Formatting   
    Exploring Fonts
  • Adjusting Column Width and Row Height
  • Using Alignment  
    Designing Borders
  •  Formatting Numbers
  •  Conditional Formatting
  • Creating Tables
  • Inserting Shapes

After completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets  that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more.

Who this course is for:

  • Beginners to spreadsheets and excel
  • Those who need a refresher to excel.

This course includes:

  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

DOUBLE CLICK TO ENROLL

Note: This Udemy discount (offer) will expire within two days-Once you enrolled means, You can an access this course for life time.

Join with us to get free Udemy Courses with Certificate

WhatsappClick Here
TelegramClick Here
FacebookClick Here
TwitterCLick Here
InstagramClick Here
Free Udemy Courses

Which Udemy Courses You want? Mention it in comments! It Will Be Post soon

Free Udemy course- Udemy coupon


Spread the love

We will be happy to hear your thoughts

Leave a reply

Techietweets
Logo