Microsoft Excel Complete
Course - Beginner, Intermediate & Advanced-3035530865
Description
MS Excel Beginners Course
The
Microsoft Excel beginner’s course will provide you with a comprehensive
overview of all of the most well-known features of Excel and the methods to
successfully use them.
The highlights of this course cover:
- A
broad overview of MS Excel
- Calculating
sums, averages, and totals
- Summing
columns or rows of numbers
- Including
cells
- Learning
formulas including IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
- Pivot
tables
- Inserting,
editing, and deleting comments
- Wrapping
text
- Creating
borders
- Merging
cells
- Pasting,
ordering, and converting columns to rows
- Designing
graphs, diagrams and charts
- Using
hyperlinks
This
beginner's level course highly recommended if you want to use Excel at home or
work for tracking simple expenses or calculating sums or totals, adding column
headings, and so on.
MS Excel Intermediate Course
The MS
Excel Intermediate Course focuses on teaching you more advanced concepts of
Excel in an accessible and more comprehensive guide to mind.
The highlights of the intermediate Excel course include
the following:
- Grasp
advanced Excel functions such as ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF,
AVERAGEIF, and AVERAGEIFS
- Data
validation with date, list, time, and numbers
- Other
functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and
EXACT
- Techniques
to eliminate duplicates in Excel
- Creating
random numbers
- Changing
text case
- Adding
passwords
- Sending
emails from Excel
- Adding
custom backgrounds
- How
to auto-fill data
- Adding
special data and characters
- Changing
border colour and theme
With
having a firm basic knowledge of the beginner Excel functions, you can
effortlessly get into the MS Excel Intermediate course.
The
course curriculum intended for making it much easier to work with Excel in the
workplace, and it is perfect for individuals who desire to enhance their skills
in Excel.
MS Excel Advanced Course
After
completing the beginner and intermediate courses successfully, you will move
onto the MS Excel Advanced Course where you will introduce with the curriculums
that well laid out with just the most essentials in Excel.
The highlights of MS Excel Advance Course cover:
- VLOOKUP
Advanced formula options and manipulations
- Other
advanced functions such as OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT,
FIND
- Functions
including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
- Highlighting
a cell with a formula
- Functions
including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
- Functions
including DGET, DMAX, PRODUCT, DCOUNTA, DCOUNT and DSUM
- Calculating
loan IPMT and EMI
- Functions
including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
- A
detail interpretation of the INDEX and MATCH functions
- How
to look up data
- Colouring
a column and row with a formula
- How
to select only cells carrying remarks
- Hiding
formulas
The MS
Excel Advanced Course will thoroughly prepare you for job posistion that
require excellent command over Excel. Upon successful completion of the course
it, you will gain the knowledge and skills and feel more confident that will be
ideal for your career success.
Beginners Course Modules
- Module
1: Navigate the Excel User Interface
- Module
2: Use Excel Commands
- Module
3: Create and Save a Basic Workbook
- Module
4: Enter Cell Data
- Module
5: Use Excel Help
- Module
6: Create Worksheet Formulas
- Module
7: Insert Functions
- Module
8: Reuse Formulas and Functions
- Module
9: Insert, Delete, and Adjust Cells, Columns, and Rows
- Module
10: Search for and Replace Data
- Module
11: Use Proofing and Research Tools
- Module
12: Apply Text Formats
- Module
13: Apply Number Format
- Module
14: Align Cell Contents
- Module
15: Apply Styles and Themes
- Module
16: Apply Basic Conditional Formatting
- Module
17: Create and Use Templates
- Module
18: Preview and Print a Workbook
- Module
19: Set Up the Page Layout
- Module
20: Configure Headers and Footers
- Module
21: Manage Worksheets
- Module
22: Manage Workbook and Worksheet Views
- Module
23: Manage Workbook Properties
Intermediate Course Modules
- Module
1: Work with Ranges
- Module
2: Use Specialized Functions
- Module
3: Work with Logical Functions
- Module
4: Work with Date & Time Functions
- Module
5: Work with Text Functions
- Module
6: Sort Data
- Module
7: Filter Data
- Module
8: Query Data with Database Functions
- Module
9: Outline and Subtotal Data
- Module
10: Create and Modify Tables
- Module
11: Apply Intermediate Conditional Formatting
- Module
12: Apply Advanced Conditional Formatting
- Module
13: Create Charts
- Module
14: Modify and Format Charts
- Module
15: Use Advanced Chart Features
- Module
16: Create a PivotTable
- Module
17: Analyze PivotTable Data
- Module
18: Present Data with PivotCharts
- Module
19: Filter Data by Using Timelines and Slicers
Advanced Course Modules
- Module
1: Use Links and External References
- Module
2: Use 3-D References
- Module
3: Consolidate Data
- Module
4: Use Lookup Functions
- Module
5: Trace Cells
- Module
6: Watch and Evaluate Formulas
- Module
7: Collaborate on a Workbook
- Module
8: Protect Worksheets and Workbooks
- Module
9: Apply Data Validation
- Module
10: Search for Invalid Data and Formulas with Errors
- Module
11: Work with Macros
- Module
12: Create Sparklines
- Module
13: MapData
- Module
14: Determine Potential Outcomes Using Data Tables
- Module
15: Determine Potential Outcomes Using Scenarios
- Module
16: Use the Goal Seek Feature
- Module
17: Forecasting Data Trends
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Excel 2016 Essentials - Training Course Microsoft
Office Certification-3035530865
Description
What is covered in this Excel 2016 Essentials online
course?
This
Excel 2016 Essentials online training course covers the following modules:
Module One: Create and Manage Worksheets and Workbooks
- Create
Worksheets and Workbooks
- Create
a workbook
- Import
data from a delimited text file
- Add
a worksheet to an existing workbook
- Copy
and move a worksheet
- Navigate
in Worksheets and Workbooks
- Search
for data within a workbook
- Navigate
to a named cell, range, or workbook element
- Insert
and remove hyperlinks
- Format
Worksheets and Workbooks
- Change
worksheet tab color
- Rename
a worksheet
- Change
worksheet order
- Modify
page setup
- Insert
and delete columns or rows
- Change
Workbook themes
- Adjust
row height and column width
- Insert
headers and footers
- Customize
Options and Views for Worksheets and Workbooks
- Hide
or unhide worksheets
- Hide
or unhide columns and rows
- Customize
the Quick Access toolbar
- Change
workbook views
- Change
window views
- Modify
document properties
- Change
magnification by using zoom tools
- Display
formulas
- Configure
Worksheets and Workbooks for Distribution
- Set
a print area
- Save
workbooks in alternative file formats
- Print
all or part of a workbook
- Set
print scaling
- Display
repeating row and column titles on multiple worksheets
- Inspect
a workbook for hidden properties or personal information
- Inspect
a workbook for accessibility issues
- Inspect
a workbook for compatibility issues
Module Two: Manage Data Cells and Ranges
- Insert
data in cells and ranges
- Replace
data
- Cut,
copy, or paste data
- Paste
data by using special paste options
fill cells by using Auto Fill - Insert
and delete cells
- Format
cells and ranges
- Merge
cells
- Modify
cell alignment and indentation
- Format
cells by using Format Painter
- Wrap
text within cells
- Apply
number formats
- Apply
cell formats, apply cell styles
- Summarize
and organize data
- Insert
sparklines
- Outline
data
- Insert
subtotals
- Apply
conditional formatting
Module Three: Create tables
- Create
and manage tables
- Create
an Excel table from a cell range
- Convert
a table to a cell range
- Add
or remove table rows and columns
- Manage
table styles and options
- Apply
styles to tables
- Configure
table style options
- Insert
total rows
- Filter
and sort a table
- Filter
records
- Sort
data by multiple columns
- Change
sort order
- Remove
duplicate records
Module Four: Perform operations with formulas and
functions
- Summarize
data by using functions
- Insert
references
- Perform
calculations by using the SUM function
Perform calculations by using MIN and MAX functions - Perform
calculations by using the COUNT function
- Perform
calculations by using the AVERAGE function
- Perform
conditional operations by using functions
- Perform
logical operations by using the IF function
- Pperform
logical operations by using the SUMIF function
- Perform
logical operations by using the AVERAGEIF function
- Perform
statistical operations by using the COUNTIF function
- Format
and modify text by using functions
- Format
text by using RIGHT, LEFT, and MID functions
- Format
text by using UPPER, LOWER, and PROPER functions
- Format
text by using the CONCATENATE function
Module Five: Create charts and objects
- Create
charts
- Create
a new chart
- Add
additional data series
- Switch
between rows and columns in source data
- Analyze
data by using Quick Analysis
- Format
graphic elements
- Resize
charts
- Add
and modify chart elements
- Apply
chart layouts and styles
- Move
charts to a chart sheet
- Insert
and format objects
- Insert
text boxes and shapes
- Insert
imagesModify object properties
- Add
alternative text to objects for accessibility
Career path
Anyone who successfully passes this course
could progress to any of the following positions:
- Software
Engineer
- Technical
Support
- Technical
Sales
- Business
Analyst
- Web
Developer
- Software
Tester
- IT
professionals
- Technical
IT professionals
- Project-based
technical analysts and engineers
- Technical
support personnel
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
No comments:
Post a Comment