Basic Excel Training in Lahore Islamabad Karachi

1 Day Course 

Course Overview

Microsoft Excel delivers rich, new and enhanced features to the world’s most popular productivity suite. This Basic Excel Training is ideal for those who know nothing or very little about Excel.

Excel makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions.

With new data analysis and visualization tools, along with managed self-service business intelligence technologies, you can create effective business or information.

You can also extract insights that track and highlight important data trends and communicate your results through high-quality charts and graphs.

Key Takeaways

  • Gain basic and intermediate skills to perform the calculations and functions in excel
  • Use spreadsheet skills for effective data management
  • Understand the use of worksheets and formulas in excel tool
  • Work efficiently with new reporting and presentation techniques

Who should attend this Basic Excel Training

This course is designed for Delegates who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

This Basic Excel Training is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and Pivot Charts for analyzing data, and customizing workbooks.

Upon completion of this course, students will be able to:

  • Create a basic worksheet by using Microsoft Office Excel
  • Perform calculations in an Excel worksheet
  • Modify an Excel worksheet
  • Print the content of an Excel workbook
  • Manage an Excel workbook
  • How to Use advanced formulas
  • Organize worksheet and table data using various techniques
  • Create and modify charts
  • Analyze data using PivotTables, Slicers, and PivotCharts
  • Insert and modify graphic objects in a worksheet
  • Customize and enhance workbooks and the Microsoft Office Excel environment
  • Enhance productivity and efficiency by streamlining the workflow
  • Collaborate with other workbook users
  • Audit worksheets
  • Analyze data
  • Work with multiple workbooks
  • Import and export data
  • Integrate Excel data with the web

COURSE OUTLINE

Getting started

  • Spreadsheet terminology
  • The Excel environment
  • Navigating a worksheet
  • Using a template
  • Entering and editing data
  • Entering and editing text and values
  • Entering and editing formulas
  • Saving and updating workbooks

Modifying a worksheet & Functions

  • Moving and copying data
  • Moving, copying, and viewing formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows, and columns
  • Entering functions
  • AutoSum
  • Other common functions

Basic Excel Formatting

  • Text formatting
  • Row and column formatting
  • Number formatting

Managing workbooks and worksheets

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Using multiple workbooks
  • Using special number formats
  • Other advance formatting

Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals
  • Cell and range names
  • Creating and using names
  • Managing names
  • Data structure and tables
  • Sorting and filtering data
  • Working with tables

Performing Calculations

  • Create Basic Formulas
  • Calculate the Cell Values by Using Functions
  • Copy Formulas and Functions

Send your queries for Basic Excel Training at info@thebscon.com or call at +92 321 8408828.