Excel Course

Microsoft Excel is a spreadsheet application.

Excel Course Online Training

In this introductory course to Excel, participants will explore Excel activities that go beyond the basic. After successful completion of this session, participants can expect to have the skills required to work efficiently in an existing worksheet and to also create new worksheets from a template and from scratch.

What you will learn

The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. Find out how you can utilise advanced ‘If’ statements.

  • Introduction to Excel
  • Formatting, Printing, View tab in Excel

Excel Course Online Training Content

 

  • Introduction to Excel
  • History of Excel , diff. versions
  • Excel Features , Application Window
  • Understanding Workbook Structure
  • Managing diff. workbooks and worksheets
  • Entering Data in Excel, Copying & Moving Data between cells and worksheets
  • Formatting, Printing, View tab in Excel
  • Formatting data with Shortcut keys and Format menu
  • Filling Series
  • Page layouts, Printing in Excel
  • Workbook Views and Custom views
  • Introduction to Formulas and Functions
  • Diff. between Formulas and Functions
  • Creating Formulas in Excel , BEDMAS rule
  • Using Excel Built-in Functions (Sum, Count, Min, Max, Average, Product)
  • References – Absolute , Relative and Mixed
  • Using Auto sum & Formula Tab
  • Working with Formula Auditing Group ( Circular References, Evaluation Formula, Tracing Precedents & Dependents , Controlling Calculation Options)
  • Advance Data Formatting in Excel
  • Creating & Applying Styles
  • Conditional Formatting
  • Applying & Editing Conditional Format Rules
  • Working with Filters, Advance filters, Sorting in Excel
  • Introduction to Charts in Excel
  • Creating Simple Charts
  • Working with Charts Design , Layout and Format
  • Saving & Using a Chart Template
  • Trend lines in Charts, Secondary Axes Chart
  • Creating Pareto Chart , Pie Chart, Combo Chart
  • Functions in Depth
  • Text Functions– Upper, Lower, Proper, Len, Trim, Char, Code, Clean, Concatenate, Left, Right, Mid, Find and Substitute
  • Date & Time Functions – Today, Now, Day, Month, Year, Date, Weekday, Weeknum, Datedif, Networkdays, Workday, Networkdays.intl, Workday.intl , Datevalue
  • Logical Functions – IF, And, Or, Not, Iferror, Iserror, Istext, Isnumber, Isblank
  • Lookup Functions – Vlookup, Hlookup, Index, Match, Offset, Indirect, Address
  • Mathematical & Statistical Functions- Sumif, Sumifs, Counta, Countblank, Countif, Countifs, Averagea, Averageif, Averageifs, Round, Roundup, Roundown, Large, Small, Mod, Sumproduct, Subtotal, Fact
  • Other Functions – Choose, Transpose

 

  • Define Names in Excel
  • Defining Names
  • Creating Names from Selections
  • Creating Named Formulas
  • Using Names in diff. Formulas
  • Managing & Displaying Names
  • Data Validation in Excel
  • Introduction to Data Validation, Rules in Data Validation
  • Creating ListBox, Multiple List Boxes
  • Introduction to Pivot Tables
  • Creating Pivot tables
  • Creating Pivot Charts
  • Working with Multiple Pivot Tables with Slicer , Getpivotdata Function
  • Excel Templates
  • Creating Templates
  • Protecting Templates
  • Workbook and Worksheet Security
  • Introduction to Analysis Pack – Whatif Analysis
  • Goalseek, Scenario Manager, Data Table
  • Introduction to Excel 2013
  • New Features in Excel 2013
  • Excel 2013 User Interface
  • Powerview
  • Sparklines
  • Timeline
  • New Excel 2013 Functions
Back to top