MS Excel Basic to Intermediate Level

MS Excel Basic to Intermediate Level
  • Pre-Requisite :
    Basic Computer knowledge and working on keyboard
  • Objective :
    This course will familiarize you with the basic use of Microsoft Excel for doing calculations using formulas, functions and using charts.
  • Take Away:
    Once you complete this course, you’ll be able to create and develop Excel worksheets and analyze business data.

Starting Course

1
Lesson 1: Creating a Basic Worksheet
  • Explore the User Interface and the Ribbon
  • Navigate and Select in Excel
  • Obtain Help
  • Enter Data and Save a Workbook
2
Lesson 2: Performing Calculations
  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
3
Lesson 3: Modifying a Worksheet
  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet
4
Lesson 4: Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles
5
Lesson 5: Printing Workbook Contents
  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks
6
Lesson 6: Managing Large Workbooks
  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets
7
Lesson 7: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
8
Lesson 8: Analyzing Data Using PivotTables and Pivot Charts
  • Create a PivotTable Report
  • Analyze Data Using Pivot Charts
9
Lesson 9: Organizing Worksheet and Table Data
  • Sort data
  • Using Filters
  • Using Hyperlinks
  • Remove duplicates
10
Lesson 10: Calculating Data with Advanced Formulas
  • Logical Functions like IF
  • Text Functions like concatenate, upper, Lower, Proper & Trim
  • Date Functions like Now,Today
  • Lookup Functions like Vlookup

Onetime payment at the time of admission


Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 2 students
Duration: 09 Hours
Lectures: 10
Video: 3

Talk to Our Experts














    Please prove you are human by selecting the House.