# MS Excel Basic to Intermediate Level

Category:
• 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
• 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

#### Be the first to add a review.

Enrolled: 2 students
Duration: 09 Hours
Lectures: 10
Video: 3

### Talk to Our Experts

Please prove you are human by selecting the House.