Advertisement
Learn the simple tips and tricks in Excel, which make simple to complex tasks easy, with our step-by-step, practical, and hands-on Training.About this Event
Lesson 1: Getting Started with Excel 2016
- Starting Excel With Excel 2016
- Using the Ribbon as the Excel 2016 User Interface
- Navigating within the Worksheet
- Selecting a Cell or Range of Cells
- Entering Data
- Entering Cell Contents
- Cutting, Copying, and Pasting Cell Values
- Copy and Paste Special
- Saving your Workbook
- Opening your Workbook
Lesson 2: Managing Rows & Columns in Excel 2016
- Inserting, Moving & Deleting Cells
- Managing Columns and Rows
- Hide and Unhide Rows & Columns
- Changing Column Width & Row Height
Lesson 3: Managing Worksheets in Excel 2016
- Format Worksheet Tabs
- Insert and Delete Worksheet
- Move and Copy Worksheet
- Hide & Unhide Worksheet
Lesson 4: Formatting Cells in Excel 2016
- Formatting the Cell
- Number and Date Formatting
- Finding and Replacing Text
- Working with Styles
Lesson 5: Working with Formulas & Functions
- Excel Arithmetic Operators & Order of Operations
- Using Auto Fill Options
- Using Commonly Used Functions
- Writing simple & useful Formulas on your own
Lesson 6: Organizing Worksheet & Table Data
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Formatting a Table For Reporting
Lesson 7: Working with Charts
- Summarizing Data Visually Using Charts
- Customizing Chart Data
- Format Chart Legend and Titles
- Change the Chart Body
- Saving the Chart as a Template
- Creating a Pie Chart
- Using Chart Titles & Placing Charts
Lesson 8: Working with Graphics
- Adding Pictures into a Worksheet
- Customizing Pictures and Objects
- Adding Drawing Objects into a Worksheet
- Adding SmartArt into a Worksheet
- Adding Clip Art into a Worksheet
Lesson 9: Managing Large Workbooks with Excel 2016
- Managing Large Workbooks
- Printing Worksheets
- Setting Page Setup Options
- Setting Page Breaks
Lesson 10: Customizing & Enhancing Workbooks
- Customizing Excel to the Way You Work
- Creating Hyperlinks
- Working with Workbook Themes
- Working with Templates
- New Templates in Excel 2016
Advertisement
Event Venue & Nearby Stays
Intellisoft Training, 06-05 Beach Road, Singapore, Singapore
Tickets
SGD 395.00