Advanced MS-Excel

By SS Gayatree Devi Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

learn-Advance-Excel-with-SLI

What is Advanced Excel?

Advanced Excel refers to the utilization of advanced features and techniques within Microsoft Excel to manipulate, analyze, and visualize data effectively. This includes proficiency in complex formulas and functions, data analysis tools such as pivot tables and Power Query, automation through macros, and creating dynamic visualizations like charts and dashboards.

Why SLI?

Enrolling in the Advanced Excel course at SLI you can access to placement assistance, industry experts as faculty, and live online/offline classroom sessions, among other advantages. Earn a recognized certification to enhance your resume and career prospects in with your Advanced Excel skill.

Show More

What Will You Learn?

  • Learning advanced MS-Excel enhances efficiency, facilitates sophisticated data analysis, and empowers effective decision-making, indispensable skills in various professional settings.

Course Content

Setting Up a Workbook
In this chapter, you will learn how to Create workbooks, Modify workbooks, Modify worksheets, Customize the Excel 2010 program window.

Working with Data and Excel Tables
In this chapter, you will learn how to Enter and revise data, Move data within a workbook, Find and replace data, Correct and expand upon worksheet data, Define Excel tables.

Performing Calculations on Data
In this chapter, you will learn how to Name groups of data, Create formulas to calculate values, Summarize data that meets specific conditions, Find and correct errors in calculations.

Changing Workbook Appearance
In this chapter, you will learn how to Format cells, Define styles, Apply workbook themes and Excel table styles, Make numbers easier to read, Change the appearance of data based on its value, Add images to worksheets.

Focusing on Specific Data by Using Filters
In this chapter, you will learn how to Limit data that appears on your screen, Manipulate worksheet data, Define valid sets of values for ranges of cells.

Reordering and Summarizing Data
In this chapter, you will learn how to Sort worksheet data, Organize data into levels, Look up information in a worksheet.

Combining Data from Multiple Sources
In this chapter, you will learn how to Use workbooks as templates for other workbooks, Link to data in other worksheets and workbooks, Consolidate multiple sets of data into a single workbook, Group multiple sets of data.

Analyzing Alternative Data Sets
In this chapter, you will learn how to Define an alternative data set, Define multiple alternative data sets, Vary your data to get a desired result by using Goal Seek, Find optimal solutions by using Solver, Analyze data by using descriptive statistics.

Creating Dynamic Worksheets by Using PivotTables
In this chapter, you will learn how to Analyze data dynamically by using PivotTables, Filter, show, and hide PivotTable data, Edit PivotTables, Format PivotTables, Create PivotTables from external data.

Creating Charts and Graphics
In this chapter, you will learn how to Create charts, Customize the appearance of charts, Find trends in your data, Summarize your data by using sparklines, Create dynamic charts by using PivotCharts, Create diagrams by using SmartArt, Create shapes and mathematical equations.

Printing
In this chapter, you will learn how to Add headers and footers to printed pages, Prepare worksheets for printing, Print worksheets, Print parts of worksheets, Print charts.

Automating Repetitive Tasks by Using Macros
In this chapter, you will learn how to Enable and examine macros, Create and modify macros, Run macros when a button is clicked, Run macros when a workbook is opened.

Working with Other Microsoft Office Programs
In this chapter, you will learn how to Include Office documents in workbooks, Store workbooks as parts of other Office documents, Create hyperlinks, Paste charts into other documents.

Collaborating with Colleagues
In this chapter, you will learn how to Share workbooks, Manage comments, Track and manage colleagues’ changes, Protect workbooks and worksheets, Authenticate workbooks, Save workbooks for the Web.

Student Ratings & Reviews

No Review Yet
No Review Yet