Microsoft Excel Training Asia IT Academy

Course Modules:

Module 1: 

  • Set Up a Workbook 
  • Creating Workbooks 
  • Modifying Workbooks 
  • Modifying Worksheets 
  • Customizing the Excel 2010 Program Window 
  • Zooming In on a Worksheet 
  • Arranging Multiple Workbook Windows 
  • Adding Buttons to the Quick Access Toolbar 
  • Customizing the Ribbon 
  • Maximizing Usable Space in the Program Window 
 

Module 2: 

  • Work with Data and Excel Tables 
  • Entering and Revising Data 
  • Moving Data Within a Workbook 
  • Finding and Replacing Data 
  • Correcting and Expanding Upon Worksheet Data 
  • Defining Excel Tables 

 

Module 3: 

  • Perform Calculations on Data 
  • Naming Groups of Data 
  • Creating Formulas to Calculate Values 
  • Summarizing Data That Meets Specific Conditions 
  • Finding and Correcting Errors in Calculations 

 

Module 4:

  • Change Workbook Appearance 
  • Formatting Cells 
  • Defining Styles 
  • Applying Workbook Themes and Excel Table Styles 
  • Making Numbers Easier to Read 
  • Changing the Appearance of Data Based on Its Value 
  • Adding Images to Worksheets 

 Module 5: 

  • Focus on Specific Data by Using Filters 
  • Limiting Data That Appears on Your Screen 
  • Manipulating Worksheet Data 
  • Selecting List Rows at Random 
  • Summarizing Worksheets with Hidden and Filtered Rows 
  • Finding Unique Values Within a Data Set 
  • Defining Valid Sets of Values for Ranges of Cells

IT Academy Asia is a platform created for people who are looking to training courses related to I.T. ranging from Microsoft Office courses to Photoshop graphic design classes. On top of that, we also have Web Design Training courses. We gathered the best instructors in the town to provide you the best teaching material. We conduct classes for individual as well as corporate.

Wait no more, start checking out our classes or call to enquire!

See all Asia IT Academy courses

Contact information not available.

Courses you can instantly connect with...
Microsoft Excel Basic Tour Aeternus Excel VBA for Absolute Beginners Itrain Intermediate Excel VBA Itrain

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or