Excel Beginner Level

Excel Beginner Level Training Programs

Excel Beginner Level courses teach basic skills such as formatting, data entry, and simple formulas. Participants learn to create and modify spreadsheets, use built-in functions, and create charts and graphs. Excel Beginner Level courses are essential for improving proficiency and productivity in the workplace.

Course Objectives

Learn the essential skills of using Excel. By the end of this course, participants will be able to create Excel workbooks and worksheets, navigate around them, and create formulae and format worksheets.

Prerequisites

This route assumes that you have a basic expertise of windows. This includes an capability to work with multiple home windows and navigate the computing device, as well as knowledge computer record storage (i.E., drives, documents, and folders). This course is trainer led, with examples and guidance physical games in a workshop environment.

Exercises

This course is instructor led, with examples and practise exercises in a workshop environment.

Course Duration : 16 Hours

Course Content

Getting to Know Excel

  • How to Start Excel
  • The Excel Workbook Screen
  • Using the Ribbon
  • Understanding the Backstage View
  • Understanding the Quick Access Toolbar

Creating a New Workbook

  • Understanding Workbooks, Worksheets
  • Entering Text, Numbers and Dates
  • Understanding the Fill Handle
  • Entering Formulas
  • Saving, Closing Workbooks
  • Printing a Worksheet

Working with Ranges

  • Understanding Cells and Ranges
  • Selecting Contiguous and Non- Contiguous Ranges
  • Selecting Rows, Columns
  • Inserting, Deleting Rows and Columns
  • Hide and Unhide Rows and Columns
  • Copy, Paste, PasteSpecial
  • Editing Data and Formulas in Excel
  • Undo and Redo
  • Fill Series – Text, Number, Date
  • Add and Delete Custom Fill List
  • Flash Fill

Working with Formulas and Functions

  • BODMAS Rule and Mathematical Operators
  • SUM, Average, Max, Min Function
  • Summing Non-Contiguous Range

Formula Referencing

  • Absolute Versus Relative Referencing
  • Creating Absolute References
  • Creating Mixed References

Apply Formatting

  • Changing Fonts, Font Size, Font Color, Background Colors
  • Bold, Italic, Underline
  • Growing and Shrinking Fonts
  • Using Format Painter
  • Applying Strikethrough, Subscripting Text, Superscripting Text
  • Number Formatting, Date and Time Formatting
  • Create Custom Formatting
  • Applying and Removing Borders

Working with a Worksheet

  • Inserting and Deleting Worksheet
  • Hide, Unhide and Zooming Worksheet
  • Viewing Formula Bar, Worksheet Gridlines, Ruler
  • Renaming, Grouping and Copying the Worksheet
  • Add Tab Color to Worksheet

Creating Charts

  • Create New Chart
  • Changing Chart type
  • Printing, Resizing and Deleting Chart
  • Using Recommended chart
  • Working with Chart Elements – Chart Title, Axes Titles, Legends
  • Showing Data Labels and Gridlines
  • Adding a Data Table

Sorting and Filtering Data

  • Performing an Alphabetical and Numerical Sort
  • Sorting on More Than One Column
  • Applying and Using a Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards in Filters

Worksheet Tables

  • Creating a Table
  • Working With Table Styles
  • Inserting or Deleting Table Columns and Rows
  • Converting a Table to a Range
  • Creating a Table from Data
  • Removing Duplicates
  • Sorting and Filtering Tables
  • Renaming, Splitting and Deleting a Table

Conditional Formatting

  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top Ten Items
  • More Top and Bottom Formatting Options
  • Working With Data Bars
  • Working With Colour Scales
  • Working With Icon Sets
  • Creating and Editing Sparklines
  • Creating Custom Rules
  • Managing and Clearing Rules

Some Useful Basic Functions

  • COUNT Functions – COUNT, COUNTA, COUNTBLANK, COUNTIF
  • SUM Functions – SUMIF, SUMIFS
  • TEXT Functions – UPPER, LOWER, PROPER, CONCATENATE

Printing and Page setup

  • Understanding Printing, Print Preview
  • Printing a Range, Entire Workbook
  • Specifying the Number of Copies
  • The Print Options
  • Understanding Page Layout
  • Using Built in Margins, Setting Custom Margins
  • Centring on a Page and Changing Orientation
  • Setting and Clearing the Print Area
  • Inserting and Removing Page Breaks
  • Setting and Clearing the Background
  • Settings Rows as Repeating Print Titles

Other Courses

EXCEL – BEGINNER LEVEL

Course Duration: 8 hours
Modes: Online/ Classroom/ Workshop
In Batch Training Cost: Rs.3000
In One-One Training Cost: Rs.6000

Enquiry Form