Professional Training on Microsoft Excel 2016: Basic to Advanced Level training centre in Bangladesh


Professional Training on Microsoft Excel 2016: Basic to Advanced Level


Microsoft Excel is one of the most widely used tools for organizing, analyzing, modelling, and visualizing data. Proficiency with Microsoft Excel is a highly desired skill-set in today`s complex business environment, one that can position you way ahead of your peers. By this course, you`ll learn how to design sophisticated spreadsheets from scratch and perform complex calculations using advanced Excel features and techniques. It`ll enable you to solve a broad range of real-time business problems and help you propel your career forward.

How Participant will be Benefited

After completing this Advanced Excel course, you`ll find yourself competent using Microsoft Excel. This advanced excel certification course will help you:

a) Master Excel Functions and Formulas that save time and increases productivity
b) Cut hours of labor by using Pivot tables to analyze data
c) Discover new tools to share your work
d) Find new and more efficient ways to analyze data
e) Tricks to produce professional charts and graphs
g) Find new ways to visualize data
h) Many useful tips & tricks



Contents of Training:

01: Getting Started with Microsoft® Excel® 2016

a) Interface and Saving , Property
b) Basic Calculations
c) Fill and Auto Fill
d) Case Change & Join Text
e) Text Apart working with illustrator
f) Picture & Screen Short
g) Shapes, SmartArt
h) Extra

I. Structure of the Excel working area,
II. How to navigate in Excel,
III. Ribbons and tabs,
IV. Quick Access Toolbar (QAT)
V. Dialog Box & Task Panes,
VI. Customizing ribbons and QAT,
VII. What is an active cell
VIII. How to use ALT shortcuts

02: Excel Operations - Prepare, Manage and Change Workbooks

a) Modifying existing templates
b) Merging multiple workbooks
c) Managing versions of a workbook
d) Copying styles from template to template
e) Linking to external data
f) Setting tracking options
g) Limiting editors
h) Opening workspace
i) Restricting editing
j) Controlling recalculation
k) Protecting worksheet structure
l) Marking as final
m) Removing workbook metadata
n) Encrypting workbooks with a password
o) Modifying Page setup
p) Changing Document Themes
q) Inserting Simple Headers & Footers
r) Inserting Watermarks & Page number
s) Print Magic!!! Print Titles
t) Managing comments

03: Formatting Data (Custom Data Formats, Advanced Conditional Formatting and Filtering, Custom Styles and Templates)

a) Format Painter
b) Function And Formula in Excel
c) Formatting Cell by Alignment
d) Formatting Cell by data type
e) Formatting Cell by Fill and Border
f) Formatting Cell by Font
g) Creating custom formats (Number, Time, Date)
h) Creating custom accounting formats
i) Using advanced Fill Series options
j) Writing custom conditional formats
k) Using functions to format cells
l) Creating advanced filters
m) Managing conditional formatting rules
n) Creating custom color formats
o) Creating and modifying cell styles
p) Creating and modifying custom templates

4: Orientation with Excel

a) Cell References (Relative & Absolute)
b) Find and Replace, Replace all
c) Freeze Panes
d) Hyperlink
e) Managing Multiple Windows
f) Paste Specials
g) Selecting, Moving & Resizing
h) Structure of Excel Function(fx)
i) Consolidating
j) Data Validation

5: Advance Functions (Functions in Formulas, Look up Data with Functions, Advanced Date and Time Functions)

a) IF Function (Basic & Advanced)
b) IF Functions (sum, count, average)
c) IFS Function (sum, count, average)
d) Index and Match Functions
e) Vlookup, Hlookup Functions
f) Subtotal
g) IF function in conjunction with other functions
h) Utilizing AND/OR functions
i) Utilizing nested functions
k) Utilizing the LOOKUP function
l) Utilizing the VLOOKUP function
m) Utilizing the HLOOKUP function
n) Utilizing the TRANSPOSE function
o) Utilizing Index & Match function
p) Utilizing the NOW functions
q) Utilizing the TODAY functions

6: Advance Tools & Big Data Management

a) Manage Duplicate Data
b) Managing Data by Group
c) Table ,Slicer
d) Sort and filtering
e) Formatting by Formula
f) Formula Auditing
g) Managing Comments in Excel

Related Courses

Md. Feroz Kibria
  • 9 - 10 Oct 2020 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

This is an exclusive training for them who wants to learn Microsoft Excel.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.