Microsoft Excel
In this section, you will learn the basics of using Excel to help you make your work.
What You Will Learn in this Section:
- How to get Microsoft Excel
- Navigating the Homescreen (Home Button, Functions, workbook, templates
- Orientation Main Screen (Cell, Columns & Rows, Ranges)
- Formatting (Accounting, Comma, Fraction, Merge & Center Cells, Wrap Text, Colour Fill & Font Colour)
- Adjusting Cell, Row & Column Size
- Basic Formulas (+ – / * Count, Max, Sum)
- Fill Series (Absolute & Relative Reference)
- Spilt Data (Tab, Text to Columns, Delimiters & Destination)
- Tables (Format, Destination, Expand, Design)
- Total Row & Calculating Sums
- Quick Analysis
- Formatting, Data Bars, Icon Set
- Charts (Bar, Pie Line, combo)
- Freeze Pane
- Pivot Tables using (Filters,Columns, Rows & Values)
What You Will Learn in this Section:
- Convert Image to table in Excel using phone
- Use Ideas to generate Insights on your data
- Define Name
- Absolute & Relative Cell References
- Copy & drag formula for other cells
- Macros (Run & Record)
- Data Types (Stocks, Geography)
- Sum Function & Formula
- Concatenate & Flash Fill
- Sum IF, Count IF, IF ,convert function
- Adjust Column Width & Row Height Automatically
- Freeze Panes
- Pivot Tables Basics
- Shortcut Keys
- Commonly Used Formulas: Vlookups & Hlookups
- Navigating in Cells
- Formatting in Cells
What You Will Learn in this Section:
- Inserting a Pivot Table from data
- Basic Functions, Fields & Areas
- Using Filters, Columns, Rows & Values
- Distinct Counts
- Expand/Collapse Fields
- Formula
- Sorting data i.e. (Largest to Smallest)
- Value Field Settings
- Sum, Count, Average & Percentage
- Show Values As % of (Column Total. Grand Total, Row Total)
- Chart Types (Columns, Line, Bar, Area, Pie)
- Excel Online (Mircosoftonline.com, OneDrive)
- Understanding & Navigating Frontier’s Delivery Variance Report