Become Expert In MS Excel For Mac
Learn MS Excel, MS Excel integration in Mac, inserting data, cells, row, columns, data formatting, formulas, data freezing, adjusting, patterns, automation, charts, graphs, data analysis, data prediction and much more.
This course is made by following the MS Excel integration in Mac. It defines the effective use of MS Excel and elaborates the key features like pivot tables, data handling tool, application, arranges fields applying formulas etc. The main purpose of this course is to increase your productivity within the short span of time.
Furthermore, this courses also explain the shortcut command that actually provides the acceleration to your work. There are much difference between MS Excel use in window PCs and Mac operating system. Therefore you must need to understand the efficient usage of MS Excel for Mac.
- Starting with Excel
- Introduction to Basic Mac
- Exploring the window
- Exploring the Ribbon
- Customizing the Ribbon
- Setting up program preferences
- Using help in Excel
- Working with workbooks
- Using workbook templates
- Managing Worksheets
- Working with cells
- Using Auto-fill to input data
- Create an excel table
- Using find and replace
- Using Data Validation rules
- Limiting data entry using lists
- Sorting tools
- Using filter
- Splitting and Feezing
- How to manage worksheets
- Header and Footer 1 and 2
- Using formulas and functions
- Introduction to formulas and functions
- How to add a formula
- Absolute and relative cell references
- Using Auto sum formula
- Using Status bar to summarize data
- Joining text using concatenation
- Using IF function 1 and 2
- Using SUM IF function
- Finding data using V LOOKUP
- Goal Seek analysis 1 and 2
- Formatting Worksheets
- Fonts, colors and borders
- Number and date formatting
- Using Text Allignment
- How to copy cell formats
- Creating cell styles
- Rule based condtional formatting
- Top bottom rules and removing conditional formatting
- Introduction to Charts
- Column charts and their formatting
- Other charts
- COMMON ERRORS 1 and 2
- Introduction
- Useful Excel Functions
- Paste Special
- Count Functions
- Cell information functions
- Data Functions
- Choose Function
- Database functions
- Offset Function-Example 1
- Offset Function-Dynamic use
- Forecast function
- WhatIfAnalysis
- One Dimensional Data Tables
- Two Dimensional data table
- Solver1
- Arrays
- Arrays Introduction
- Transpose 1 and 2
- Pivot Tables
- Pivot tables
- Pivot Table Styles
- Names and Dynamic Range
- Naming a range
- Dynamic ranges
- Important Excel Tools
- Text to Columns
- Grouping Tabs
- Sub-total FUnction
- Hyperlinks
- Data Validation
- Random Function
- Custom View
- Protecting Sheet
- Protecting workbook
- Printing the worksheet
- Advanced Charts
- Sparklines
- Two Axis Graph
- Average Line
- Bar to Pie Chart
- Combo Chart Video
- Invert Negatives
- Scrolling Chart-Step 1 and 2
- Scrolling Chart- Step 3 and 4
Rating 4.5 (50 Reviews)
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud
-
Media heading
incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud