Course details
Course OutlineData - Numbers and Text in Excel
- Entering Numbers and Text
- Overflowing Numbers and Text
- Editing Numbers and Text
- Selecting Multiple Cells
- Autofill: Numbers, Months, Days of Week, Dates
Calculations Concept
- Relative and Absolute Reference Use of F4 Key
- Entering Formulas
- Using the Mouse to Enter Cell References in Formulas
- Editing Formulas - Using F2 Key the Order of Evaluation: BODMAS
- Using Parentheses to Change the Order Entering Functions
- The Structure of Functions the =SUM () Function
- Using the Mouse to Enter Range References Entering Functions in the Formula Bar Inserting Functions
Applying AutoSum
Formatting Numbers, Text, Reports
- Number Formatting
- Dates Formatting
- Text Formatting
- Row and Column Formatting
- Additional Formatting Options: Styles
- Other Advanced Formatting
- Merging Cells
- Wrapping Text
- Transposing Data
- Using Paste Special Operations
- Viewing Large Worksheets
- Locking Row and Columns Heading in Place Hiding and Unhiding Worksheets Minimizing the Ribbon to see more of the
- Worksheet
- Using Multiple Worksheets
- Inserting Worksheets
Moving and Copying Worksheets - Deleting Worksheets
- Naming Worksheets
- Coloring Worksheets Tab
- Linking Worksheets
- Linking Workbooks
- Workspace
Printing
- Preparing to Print
- Using the Spelling Checker
- Using Page Break Preview Page Setup Options
- Page Orientation Page Size Scaling
- Margins
- Custom Headers and Footers
- Print Titles: Rows or Column to Repeat Printing Worksheets
Power of IF and VLOOKUP - a Teaser
=IF () Function
=VLOOKUP () Function
Conditional Formatting - the Basics
- Bars
- Highlight Cell Rule
- Top-Bottom Rule
- Finding Duplicate
Intro - Pivot Tables
- Reports with ZERO Errors & ZERO Formulas Using Styles to Format Pivot Reports
Intro - Charts
- Creating Charts with One Key Press!
- The FOUR Critical Steps
- Pie and Column Charts
- Relevant Shortcuts
- Demonstration: The Power of Macros
Updated on 31 May, 2018
Eligibility / Requirements
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
About Evanson Training
Who we are?
We help organisations and individuals achieve results in the areas of Finance, Accounts, Reports, Audit, Work Management and Operational Efficiencies.
What we do?
Our team of experts can help you select the right initiatives, deeply customize our training solutions to fit your world, and excel at delivering your training through our network of top-rated facilitators, who have frontline industry experience.
How we do it?
- We take the time to listen and understand your needs and your situation. And then we define training objectives.
- Careful need analysis helps us develop training solutions in the context of addressing your specific objectives.
- After successful completion of training we direct you towards productivity and performance, under guidance of industry experts in our network.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Office 2016 Excel Advanced John AcademyUSD 72
USD 1,440Duration: Upto 3 Hours - Microsoft Office 2016 Excel Intermediate John AcademyUSD 72
USD 1,440Duration: Upto 4 Hours
