- 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.
MS Excel Basic to Intermediate Level
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