- Duration: 2 days (14 hours)
- Timings: Monday-Thursday 9am-5pm
Course details
This 2-days hands-on basic to intermediate course covers all the basics you need to start entering your data and building organized workbooks. This course teaches you how to create a proper database, enter and organize data, work with multiple worksheets, format the appearance of your data, data referencing, creating formula and basic Excel functions to perform calculations, and applying different types of security. You'll also learn the power of Flash Fill feature inplemented only in Excel 2013.
What will I learn?
- Introduction to Excel 2013
- Excel 2013 Interface
- Understanding the different types of data
- Manipulating worksheet
- Learn different ways of viewing large amount of data
- Auto filling data in worksheet including Flash Fill, a new feature in Excel 2013
- Different types of data formatting
- How to applying formatting on data based on condition
- Different types of calculation operator
- Create formula to automate works and solve problems
- Create Excel basic functions
- Create different types of hyperlink
- Learn how to prepare the worksheet for printing
- Apply worksheets and workbook protection
Who is this course for?
Learners with zero to little knowledge of using Microsoft Excel 2013.
Updated on 08 November, 2015Course Location
About Oaks Training
Oaks Training operates as a closely knitted family with a team that is passionate in sharing knowledge and has a love for teaching. Our team's experience in training began as early as 1990. Oaks Training considers everyone (admin staff, trainers, management) who works in the company as a family member. Our philosophy is “Everyone is indispensable. Everyone plays a crucial part in the success of the company and for the benefit of our customers.
See all Oaks Training courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office 2016 Advanced John AcademySGD 34
SGD 509Duration: Upto 76 Hours - MS Office 365 OneNote Online Skill-UpSGD 20
SGD 179Duration: Upto 1 Hour
