- Location: Bukit Merah - Central
- Duration: 1 Day
Course details
In this course, students will apply visual elements and advanced formulas to a worksheet to display data in various formats.
What will I learn?
Lesson 1: Calculating Data with Advanced Formulas
- Apply Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Use Functions to Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
- Create a PivotTable Report
- Filter Data Using Slicers
- Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects(optional)
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
- Customize the Excel Environment
- Customize Workbooks
- Manage Themes (optional)
- Create and Use Templates
Requirements
Excel 2010 - Level 1
Updated on 08 November, 2015Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office 2010 Getting to speed Study 365SGD 34
SGD 243Duration: Upto 6 Hours - Advanced Excel for Real World Course LineSGD 33Duration: Upto 4 Hours