Learn everything about Analytics

Excel 2013 Essential Training – Lynda

Lynda
0-6 Month Online
Advanced Contact Institute
Online Business Intelligence
Online Self Paced 685
Rate this post
DescriptionProgram StructureToolsFacultyContact

Whether you’re a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Course Program:

  • What is Excel and what is it used for?
  • Using the menus
  • Working with dates and times
  • Creating simple formulas
  • Formatting fonts, row and column sizes, borders, and more
  • Inserting shapes, arrows, and other graphics
  • Adding and deleting rows and columns
  • Hiding data
  • Moving, copying, and pasting
  • Sorting and filtering data
  • Printing your worksheet
  • Securing your workbooks
  • Tracking changes

Fees:

INR 15,00 (assuming $ = INR 60)

Duration:

6 hour 32 minutes

  • Excel
  • Pivot table
  • Vlookup
  • Macro
  • Dennis Taylor
Name :
Email :
Contact Number :
Message :
Code :

Leave A Reply

Your email address will not be published.

Join 50,000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.