Excel Amazing Course | Tips & Tricks 2020 | Accountech Training & Solutions

Excel Amazing Course | Tips & Tricks 2020 | Accountech Training & Solutions

Excel Amazing Course | Tips & Tricks 2020 | Accountech Training & Solutions
Learn Excel from Scratch OR become more CONFIDENT. Looking to learn Excel but don’t know where to start? OR, you’ve been using Microsoft Excel for a while but don’t feel 100% confident? There is so much information out there. What do you need to succeed at work? I’ve picked out the Excel Essential skills as a Data Analyst needs and packaged them in a complete Excel course.
In fact, I collected the most common Excel problems faced by my clients. I have included all the hidden tips and tricks I came to learn. I also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You’ll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don’t use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
This course will get you confident and comfortable designing simple to complex spreadsheets. You’ll go beyond Excel basics. As you go through the course, you’ll be able to apply what you learnt immediately to your job.
You’ll master new formulas and find better ways to setup your existing spreadsheets. Management loves efficiency. In this course you’ll solve dozens of practical real-world examples. They’ll help you think outside the box so you can work smarter not harder
Basics of Using the Ribbon
Quick Access Toolbar
Mini Toolbars and Contextual Menus
Status Bar
Basics of Entering and Editing Data in a Workbook
Formatting Dates
Formatting Numbers
Working with Fill and Series
Flash Fill
Workbook Views, Zoom, and Freeze
Printing –
Methods of Cutting, Copying, and Pasting
Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles Exercise 04
Basics of Formulas and Functions
Complex Examples of Formulas
Managing Worksheets
Working with Multiple Workbooks
Saving in Different File Types
The Spell Checker
Inserting Comments
The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions
Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
SUM Function
SUMIF Function
COUNT Function
COUNTIF Function
COUNTIFS Function
AVERAGE Function
ROUND Function
CONCATENATE Function
INDEX Function
OFFSET Function
MATCH Function
MAX Function
TRIM Function
EN Function
SQRT Function
IF Function
AND Function
TODAY Function
Quick Access Bar
Conditional Fomatting
Color Scale
Using Excel Formulas for Conditional Formatting
Logical Excel Functions
IFERROR Function
IFNA Function
NESTED IF Function
TEXT Functions
LOWER Function
UPPER Function
RANDBETWEEN Function
Lookup Functions
VLOOKUP Function
HLOOKUP Function
Formula Auditing
Error Checking
Show Formulas
Text To Column
Data Validation
What-if Tools
Scenario Manager
Data Table
Filter
WRAP Text
Merge Cell
Insert Comments
Charts In Excel
Pie Charts In Excel
Pivot Tables
Data Analysis Using Excel
To buy our basic to advance complete training click below

Leave a Reply

Close Menu