The Complete Excel 2013 Course for Beginners: Learn by Doing
The Drop-Dead Simple Method to Mastering Microsoft Excel 2013 and VBA, Without Books, in Less Time Than You Thought
4.30 (22 reviews)
1,261
students
25.5 hours
content
Mar 2023
last update
$19.99
regular price
What you will learn
Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
Tips for mouse and touch screen users.
Graphs and charts using templates or custom designs.
SkyDrive and other tools for sharing work.
Pivot tables and slicing.
Working with flash fill.
Bonus exercise files.
Working with dates and times
Averages, percentiles, and LINEST functions
Calculating depreciation
Inserting and formatting tables
Sparklines and data bars
Pivot charts
How to automate tasks and operations that you perform frequently.
How to set Excel up for VBA.
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code
How to use intellitext with variables, particularly those that are defined constants
What functions are, how they are used, and how to stage a scenario to complete
How functions return values
How to use input boxes and message boxes to interact with the user
The intricacies surrounding creating an array formula
How to use the application object to control the user experience
How to use the workbook and worksheet objects and how they function as data containers.
How to use errors to improve your code
How to use the name and names object to manage named ranges
General information about the PivotTable object and basic approaches to utilizing it
Related Topics
558676
udemy ID
7/19/2015
course created date
1/6/2023
course indexed date
ANUBHAV JAIN
course submited by