Microsoft Excel Complete Course - Beginner, Intermediate, Advanced

Excel is used everywhere, hence we want that everyone should have the knowledge of basic excel concepts. And if you are looking forward to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets, don't be late to grab this course now. Through this Microsoft Office 2016 Excel Beginners Training you will get access to video tutorials, PDF documents, excel sheets on excel 2016. You will learn to create and edit basic worksheets and workbooks, and more.

Microsoft Excel is a powerful tool that is used to create and format spreadsheets, analyze and share information to make more informed decisions. This Microsoft Office 2016 Excel Intermediate Training is designed to teach you creating advanced workbooks and worksheets. You'll have the ability to analyze massive amounts of data and extract actionable information from it as well as learn how to present that information to heighten your understanding of organizational intelligence.

To sum up, this course is perfect for you to expand your skills and knowledge of Excel 2016.

If you are looking for an engaging, hands-on, and highly interactive approach to Excel analytics training, then you've come to the right place.

Microsoft Excel is a spreadsheet and has become very popular as well as widely practised spreadsheet for various platforms for both office work or studies purpose. This video training course will give you an in-depth understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program. Through this Microsoft Office 2016 Excel Advanced Training, you'll learn the necessary skills to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, as well as create and manage macros.

Anyone interested.

CPD and IAO

Beginner Level:

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions
• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools
• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates
• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

Intermediate Level:

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions
• Sort Data3
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data
• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting
• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features
• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

Advanced Level:

• Use Links and External References
• Use 3-D References
• Consolidate Data
• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas
• Collaborate on a Workbook
• Protect Worksheets and Workbooks
• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros
• Create Sparklines3
• MapData
• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends

Alpha Academy is an online learning platform that provides one of the best e-learning experience. With a large variety of training courses to choose from, you are bound to find something to suit you. Whether it be to improve your current expertise or develop new skills, we can facilitate your goal.