Microsoft Power Platform
Microsoft Office 365
Introduction to Microsoft Office 365
Duration : 2 days
Navigate Office 365
MS Outlook 365
OneDrive for Business
Microsoft Teams
MS Share point
Yammer
Planner
Forms
One Note
MS Team
Microsoft Excel
Microsoft Word
Power Point
Basic Excel
Introduction to Microsoft Excel
Duration: 2 days
Excel 2016 Interface, Excel Version
Customizing Excel 2016,Spreadsheet Layout
Page Setup, Print Preview and Print options
Formatting Worksheet, Managing Worksheets
Managing Multiple sheets, Working with Windows
Using Illustrations
Linking difference data using Hyperlink
Working with Name Range, Fill Series
Creating Basic Formulae, Basic Text Functions
Numeric/Statistical Functions
Understanding References, Conditional Formatting
Protection in Excel Working with Flash Fill
Working with Larger Spreadsheets
Comments, Creating Dropdown List
Advanced Excel
Advanced Microsoft Excel
Duration: 2 days
Excel Cell References
Statistical Functions
Logical Functions
Date & Time Functions
Advanced Conditional Formatting
Advanced Sorting & Filter
Data Validation
Collaborating data from other applications
What if Analysis
Understanding error & Functions
Lookup Functions
Vlookup Functions
Hlookup Functions
Match Functions
Index Functions
Combining all these Functions
Xlookup Function
Filter Function
Table, Pivot Table, Pivot Chart
Macro VBA
Macro VBA
Duration: 2 days
Configuring Excel for Macros
The Visual Basic Environment
Excel VBA Using the Macro Recorder
The Visual Basic Editor
Programming Concepts
VBA Variables and Data Types
Control and Decision Structures
Looping
Error handling
Debugging the Code
Using Ranges
Using Names
Workbooks and Worksheets Objects
Communicating with Your Users
With years of experience in the industry, our team of trainers is highly skilled in delivering effective training on Microsoft tools. We have successfully trained numerous individuals and organizations, helping them enhance their skills and optimize their use of Microsoft applications.
My Background
Background
Experience
2010-present
Achievements
2020
Certifications
2021