Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Advanced Excel, macros and Vba Training" is no longer available

No Reviews Yet

Vijayanagar, Bangalore

Course ID: 46267

Vijayanagar, Bangalore

No Reviews Yet

About the Course

Customizing the Excel 2013 program window
Creating workbooks
Modifying workbooks
Modifying worksheets
Merging and unmerging cells
Entering and revising data
Managing data by using Flash Fill
Moving data within a workbook
Finding and replacing data
Correcting and expanding upon worksheet data
Defining Excel tables
Naming groups of data
Creating formulas to calculate values
Summarizing data that meets specific conditions
Working with iterative calculation options and automatic
Using array formulas
Finding and correcting errors in calculations
Formatting cells
Defining styles
Applying workbook themes and Excel table styles
Making numbers easier to read
Changing the appearance of data based on its value
Adding images to worksheets
Limiting data that appears on your screen
Filtering Excel table data by using slicers
Manipulating worksheet data
Defining valid sets of values for ranges of cells
Sorting worksheet data
Sorting data by using custom lists
Organizing data into levels
Looking up information in a worksheet
Using workbooks as templates for other workbooks
Linking to data in other worksheets and workbooks
Consolidating multiple sets of data into a single workbo
Examining data by using the Quick Analysis Lens
Defining an alternative data set
7 Combining data from multiple sources
4 Changing workbook appearance
5 Focusing on specific data by using filters
6 Reordering and summarizing data
1 Getting started with Excel 2013
2 Working with data and Excel tables
3 Performing calculations on data
Defining multiple alternative data sets
Analyzing data by using data tables
Varying your data to get a specific result by using Goal S
Finding optimal solutions by using Solver
Analyzing data by using descriptive statistics
Creating charts
Customizing the appearance of charts
Finding trends in your data
Creating dual-axis charts
Summarizing your data by using sparklines
Creating diagrams by using SmartArt
Creating shapes and mathematical equations
Analyzing data dynamically by using PivotTables
Filtering, showing, and hiding PivotTable data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from external data
Creating dynamic charts by using PivotCharts
Adding headers and footers to printed pages
Preparing worksheets for printing
Printing worksheets
Printing parts of worksheets
Printing charts
Linking to Office documents from workbooks
Embedding workbooks into other Office documents
Modifying an Inserted Excel Worksheet
Creating hyperlinks
Pasting charts into other Office documents
Enabling and examining macros
Creating and modifying macros
Running macros when a button is clicked
Running macros when a workbook is opened
Inserting form controls and setting form properties
Using the Visual Basic Editor
Editing recorded macros
Finding and replacing code in the macro
13 Working with macros and forms
12 Working with other Office programs
14 VBA Concepts
9 Creating charts and graphics
10 Using PivotTables and PivotCharts
11 Printing worksheets and charts
8 Analyzing data and alternative data sets
Changing settings for VBA properties
Getting macro input by adding a dialog box
Writing new macros in the Visual Basic Editor
Saving Macros in Global template
Creating workbook and perform specified operations
Creating and populate Tables
Creating Charts
Creating a Pivot and summarize data
VBA - input / msgbox sample
VBA - Decision structures
VBA - Loops
15 Assignments
14 VBA Concepts
Zooming in on a worksheet
Arranging multiple workbook windows
Adding buttons to the Quick Access Toolbar
Customizing the ribbon
Maximizing usable space in the program window
Inserting rows, columns, and cells
matic workbook calculation
Selecting list rows at random
Summarizing worksheets by using hidden and filtered rows
Finding unique values within a data set
rkbook
oal Seek
Previewing worksheets before printing
Changing page breaks in a worksheet
Changing the page printing order for worksheets
Changing macro security settings
Examining macros
Adding text boxes to UserForms
Adding list boxes to UserForms
Adding combo boxes to UserForms
Adding option buttons to UserForms
Writing UserForm data to a worksheet
Displaying, loading, and hiding UserForms

Date and Time

Not decided yet.

About the Trainer

4.71 Avg Rating

31 Reviews

31 Students

2 Courses

Digital communications,analog communication,signals and systems,network analysis,information thery,logic design,control system,dsp having teaching experience.

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more