- Duration / Course length: Upto 13 Hours Start now
- Accredited by: CiQCPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Since its inception in 1985, Microsoft Excel has an average of five new users added every minute. Now the total stands at more than thirty million users of this amazing spreadsheet program, who use it every day for personal and professional reasons. The 2016 version has many new features added to the program, and if you would like to learn more about them, you can do so with this Microsoft Excel 2016 Intermediate Training course.This course is designed to help all users get familiar with the different features of Excel. As such you start out with learning how to use range names in formulas and functions, along with using specialized functions. Next you get to analyze the data with logical and lookup functions, organise and analyze datasets and tables, and also visualize data with charts. Furthermore you will learn about creating Pivot Table, filtering data using slicers, and analyzing data using PivotCharts. Finally the course will teach you to insert graphics, and enhance workbooks through customizing them, managing themes, and creating and using templates.
Overall this course can help you rediscover Excel, and if used correctly, you will only get to add invaluable skills to your arsenal.
COURSE CURRICULUM
- Apply Range Names
- Use Specialized Functions
- Use Text Functions
- Use Logical Functions
- Use Lookup Functions
- Use Date Functions
- Use Financial Functions
- Create and Modify Tables
- Sort and Filter Data
- Use Subtotal and Database Functions to Calculate Data
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
- Create a PivotTable
- Filter Data by Using Slicers
- Analyze Data with PivotCharts
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
- Preparing a Workbook for Multiple Audiences
About Adams Academy
Adams Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.
Our Mission
To make learning more accessible to learning enthusiasts, regardless of where they are residing in the world. To offer different courses of different levels for the students to choose from. To position our company as a leader in the industry of online learning.
Our Vision
Maintain the good credibility and reputation that we have built as online courses provider.