MS Excel Training for Business Professionals (Long-Term Course)

Course Content

  • A basic overview of Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using hyperlinks
  • Workbooks & Worksheets
  • Open an Existing Workbook
  • Close a Workbook
  • Select a Worksheet
  • Rename a Worksheet
  • Insert a Worksheet
  • Move a Worksheet
  • Delete a Worksheet
  • Spelling Check

 

What you will learn

  • Learning more about intermediate Excel functions including ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA
  • Data validation with date, list, time, and numbers
  • Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • How to remove duplicates in Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Excel
  • Adding custom backgrounds
  • How to auto fill data
  • Adding special characters
  • Changing border colour and theme
  • Formatting in Excel
  • Format Painter
  • Merge Cell
  • Wrap Text
  • Text Alignment
  • Numbers to Text
  • Leading Zeros
  • Add Text
  • Conditional Formatting
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars

 

Requirements & who can attend

Install Microsoft 2016, 2013 or 2010

No previous knowledge is required!

Great for students who want to learn at their own pace

Though the training is titled as “Beginner to Intermediate Excel…”, anyone who needs to use Excel will benefit from this course. Whether you are an absolute beginner, a newly started Excel user, for a while Excel user, a ‘less frequently use Excel’ kind of Excel user, a student Excel user, a freelancer (Graphics designer, Web designer, etc.) Excel user, or someone who deals with financial data, HR data, Supply Chain data, Admin data or anything of data, this course will help you advance your Excel skills. This course will help you rethink and improve your current process and way of data handling.

 

Learn by doing

  • Work comfortably with Microsoft Excel 2016 and many of its advanced features
  • Learn what is new in Excel 2016
  • Be much quicker at carrying out regular tasks
  • Become your team’s go-to-guy when it comes to Excel
  • Use sophisticated functions that will improve the quality of your work

 

Course at a Glance

Price:

Starting and Ending Date

Last Date of Registration

Class Schedule

Enroll Now

Resource Person