Duration: 1 day
Time: 9am to 6pm
What Will Be Taught For This MS Excel Training Course?
This 1 day workshop empowers you the basic concepts of charting and to demonstrate the ability to create and use charts on a personal computer. You will be able to accomplish operations associated with developing, formatting and using charts in Microsoft Office.
- Introduction
- Philosophy
- Psychology
- Anatomy
- Chart Types
- Creating Charts with the Chart Wizard
- Moving and Resizing Charts
- Identifying Chart Objects
- Changing the Chart Type
- Changing the Chart Type and Sub-type
- Changing the Plot Direction
- Removing/Adding a Legend
- Moving the Legend
- Charting Non-adjacent Ranges
- Changing the Chart Range
- Changing the Data Source
- Changing the Chart Location
- Printing a Chart
- Creating Charts
- Adding Chart Titles
- Formatting Chart Objects
- Changing the Text Orientation
- Adding a Data Table
- Creating an Exploded Pie Chart
- Adjusting the 3-D View
- Deleting a Chart
- Formatting Charts
- Applying User-defined Charts
- Adding and Removing Gridlines
- Formatting Gridlines
- Formatting an Axis
- Changing the Axis Scaling
- Formatting the Data Series
- Adding Data - Different Worksheets
- Using a Secondary Axis
- Changing Data Series Chart Types
- Adding a Trendline
- Pie Chart
- Bar/Column Charts
- Pictogram Charts
- Histogram Charts
- Polygons Charts
- Line Charts
- XY – Scatter Charts
- Radar Charts
- Bubble
- Cartogram
- Use Bar and Column Charts Effectively
- Create Stacked Column
- Create a 100% Stacked Bar Chart
- Variations of Column and Bar Chart
- Create Pictogram Charts
- Use Line and Area Charts
- Create Line Chart with Markers
- Summarize Data into Months
- Use Stacked Line Chart to Determine Total
- Change Data Series Order in Area Chart
- Create a Simple Scatter (XY) Chart
- Create a Multiple XY Chart
- Create a Bubble Chart
- Format The Bubbles
- Use Excel Table For Creating Chart
- Create a New Table
- Create a Chart from a Table
- Get Answers with PivotTables
- Insert a PivotTable
- Create a PivotTable Layout
- View the Report Differently
- Rearrange The Layout
- Create a PivotChart Report
- Create a Filtered PivotChart
- Case Study 1
- Case Study 2
Who Should Attend This Microsoft Excel Course Training?
Anyone with general proficiency in Microsoft Excel 2013 and looking to create and use charts in Excel.
Pre-requisite
An understanding of Windows / MS Office Excel 2013 will be an added advantage.
w/o GST | w GST | |
Course Fee | $320 | $342.40 |
Please click on the course date to enrol.
- CL: Classroom Learning
- VILT: Virtual Instructor-Led Training
- GTR: Guaranteed To Run
- Sat: Saturday
- Wkn: Weekend